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 check it in the BEx 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:18 PM

[former_member207028]

HI,

Check the keyfigure definition, right click on keyfigure vales in BEx Web and select keyfigure definition, you can see how the calculation is being done.

hope this helps

Regards

Daya Sagar

[Former Member]

As there is no scaling factor defined, can you check in the keyfigure definition?

[Former Member]

Hi,

You said you are in production system, but was this problem there in Dev and QA too ?

You can try T.Code - SU01 and see if the settings corresponding to your user id are proper or not.

Hopefully this will solve your problem.

[Former Member]

Hi

Thanks for your reply

In Dev and QA also the same problem is there.

Regards,

SAI Phani