BEx Query is displaying the values in decimals

[Former Member]

Hi SAPians,

My problem is When I check the value of a field for Ex: Net Sales:in InfoCube level it is displaying 148324.00

but when i checked it in the Report for the same field it is displaying 14832.40.

I have checked the field properties like its scaling factors No. of Decimal Places. But I didnt find any solution.

Could you please let me know what will be the reason.

FYI I am working in Bi 7 and in Production Server.

Thanks and Regards,

Sai Phani.

Edited by: Sai Phani on Sep 16, 2008 2:20 PM

[Former Member · Accepted solution]

The cube contains data that is hacn't gone through the currency display side of the OLAP processor (one of the good things about usign the OLAP processor in BW)

BW like R3 shows all data for all currencies in it's raw cubes and tables to 2 decimal places - even though the currency may be defined in TCURX as having no decimals

The OLAP processor then shifts the decimal places

For example cube

123.45 currency GBP - no entry on TCURX (TCURX is an exception table)

shows in report output as

123.45

123.45 currency HUF - TCURX for HUF shows 0 decimal places

shows in report output as

12345

In new versions of listcube this is handles but raw se16 and old listcibe shows the data without the effect of TCURX

[rajkumar_kandula]

Hi,

IN general you can find that property at two places.

1. At infoobject maintance screen, secon TAb 'Bex Descrption', there you can fix that objects precisionm and number of decimal properties.

2. At query definition level, goto query peoperties, there also you can define that required poperty.

I hope this helps you.

REvert back if u still hav queries.

Regards,

Rajkandula