Skip to Content
0
Former Member
Apr 24, 2009 at 12:04 PM

BO only pulling through whole numbers from SAP BW (no decimal amount)

80 Views

Can someone help or offer some advice?

We have a universe created from a BEx query. The BEx query contains several currency Keyfigures, displayed to 2 decimal places. When we build the BO universe, these decimal values are dropped and only the whole value is being brought through when I pull the measure into a WebI report. Without the decimal amount it's impossible for us to reconcile our new WebI reports.

The Formatted Value dimension that is created along with the measure does contain the decimal amount. However, it also contains the currency symbol making it difficult to use in any numerical calculations.

It makes no difference if the amount is a base keyfigure that is in the Cube, or a Restricted / Calculated Keyfigure.

Thanks,

Simon