Value of decimal places is different from the exported value from Web Intelligence document.
When we create a universe bases on SAP BW/ERP with a measure which calculates object divided by 100000000 and Web Intelligence with above the universe.
Column 2 is defined @Select(FolderColumn 1)/100000000 as Measure
See the Web Intelligence as below.
| Column 1 | Column 2 |
| 17 | 0 |
| 64 | 0 |
| 555 | 0 |
| 788 | 0 |
| 106 | 0 |
| 1699 | 0 |
| 1984 | 0 |
| 400 | 0 |
Export it to Excel or Excel 2007. Open it and you can see below values in the Excel sheet.
| Column 1 | Column 2 |
| 17 | 0 |
| 64 | 0.000001 |
| 555 | 0.000006 |
| 788 | 0.000008 |
| 106 | 0.000001 |
| 1699 | 0.000017 |
| 1984 | 0.00002 |
| 400 | 0.000004 |
Insert the following formula into each row in the Column 3 in the same Excel sheet.
e.g. =B2(the first row of Column 2)/100000000
Below here are the values and the values of Column 3 are different from the exported value from Web Intelligence document.
| Column 1 | Column 2 | Column 3 |
| 17 | 0 | 0.00000017 |
| 64 | 0.000001 | 0.00000064 |
| 555 | 0.000006 | 0.00000555 |
| 788 | 0.000008 | 0.00000788 |
| 106 | 0.000001 | 0.00000106 |
| 1699 | 0.000017 | 0.00001699 |
| 1984 | 0.00002 | 0.00001984 |
| 400 | 0.000004 | 0.000004 |
Answer:
Workaround: Use Measure object which is defined as Variable in the Web Intelligence document instead of IDT.
- Create a universe bases on SAP BW/ERP with a measure which calculates object divided by 100000000.
- Create Web Intelligence with above the universe.
- Right-click on Variables in the Available Objects and click New Variable.
- Type object name as Name, select "Measure" as Qualification, and type the following formula.
e.g. =[object]/100000000 - Click OK.
- Right-click on row of Variable column and click Format Number.
- Click Custom.
- Type 0.######## in the Positive text box and click Add.
- Click Apply and OK.
- You can see below values.
Column A Column B 17
0.00000017 64 0.00000064 555 0.00000555 788 0.00000788 106 0.00000106 1699 0.00001699 1984 0.00001984 400 0.000004
- Export it to Excel sheet.
- You can see the number of decimal places is same.