Inconsistent in Decimals format for a Measure in SAP BO Explorer 4.1 SP2?

[Former Member]

Hi,

I have created a Universe on top SAP BEx Query using Universe Designer Tool and to convert the values into Millions so i have divided each measure with 1000000. On top of this Universe, i have created Information Space and Indexed it and created an Exploration View Set.

Now i'm viewing my Exploration Views, I found an inconsistency with Decimal Format for a measure value like below.

I'm using SAP BO Explorer 4.1 SP2 version.

Can anyone please suggest me what could be the issue and how to solve this.

[Former Member]

Hi,

Create a formula in Universe like (Column_Name/1000000) Decimal(3,2)

This will restrict to two decimal places.

Regards,

Sundar