Amount showing in BPC without decimals.

Hi BPC Gurus,

I have uploaded data from BI Cube to BPC Cube successfully. When seen the report I am surprised to find that the amount in the Amount column has no decimal point i.e. Rs.500000 where as it should be Rs.5000.00/- . So my report is misleading the user. Pls help me in understanding what went wrong.

Regards

KumarMG