Online Tutorials & Training Materials | STechies.com
Register Login
Advertisement

Value of Decimal Places is different from the Exported Value

|| 0

Value of Decimal Places is different from the Exported Value
Stechies

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.


Advertisement
Advertisement
Advertisement