Decimal Places of Key Figure not displaying Correctly

[Former Member]

Hi BW Gurus,

I have a key Fig ZLENGTH of type Quantity. I am calculating length in Kilo Meters with this.When I am trying to load the data in my cube with flat file say if value for length is 8.123 Km it is showing in Cube 8.000 . As cklient requirement is for three decimal places I want to show exact value i.e. 8.123KM

Pls. help. Matter Urgent

Regards,

MANDAR

[Former Member · Accepted solution]

Hi,

are you sure that the data stored in your cube is really 8.000? Did you see that in its fact table or via a query?

Check the setting of this unit of measure in transaction CUNI (decimal places / rounding).

Check as well in your TRules and URules that your aren't passing the value to an Integer field in between....

let us know...

hope this helps...

Olivier.

[Former Member · Accepted solution]

Hi,

Yes the value cube is showing is 8.000. I am not passing the value to any integer.

In CUNI under Unit of Measurment tab I can't find KM.

Pls. help

Regards,

MANDAR

[Former Member · Accepted solution]

Hi,

in CUNI select LENGTH in front of Units of Measurement, click the button and then double click the KM row to open its properties.

Deciaml rounding should be empty there; if this is the case you'll have to simulate your update in order to see where the system is removing the decimals.

Check that the original record in the PSA has decimals.

Check that the communication structure record has decimals.

Finally the data target record.

It must happen somewhere in the dataflow.

hope this helps...

Olivier.

Message was edited by:

Olivier Cora

[Former Member · Accepted solution]

Dear Olivier,

Done!! Thanks !!

MANDAR

[Former Member]

hi,

Goto keyFig ZLENGTH in change mode --> Tab Additional Properties --> Decimal places --> select as 0.000 (as u required)

and load the flat file data with decimal values

thanks

[Former Member]

hI SRINIVAS,

The property is already set to 3 decimal places.

Regards,

MANDAR