Is there any way to format numbers in a view set table? Currently all the numbers appear with no formatting and up to 16 decimal places. These numbers are formatted as currency in Explorer.
sproctor722 (BOB member since 2011-01-04)
I have found a way to change the format of how numeric data is displayed in Explorer when you are in explore mode see instructions below. However, when you save the exploration to a view set, it ignores the formating and the table values show with up to 16 decimal places.
I am thnkng this is a bug in the Explorer product. Has anyone found a solution to change the number format for numbers in a table in an Explorer view set?
Instructions for setting format for numeric values in explorer (where data source is a business objects 4.0 universe unx)
1.) open IDT (Information Design Tool)
2.) Open Business Layer
3.) Open the object properties for the measure you want to change the formating on.
4.) select the Advanced Tab
5.) under display click on “create display format”
6.) Choose Numeric
7.) click on “custom format”
8.) Configure the correct format and choose “ok”
9.) Re index your information space
formieri 
(BOB member since 2007-03-21)