Rounding off keyfigure in SAP BW

[abhimanyu_sharma]

Hi,

I have created a keyfigure of Datatype as DEC in SAP BW of type Number in SAP BW ( 7.31)

In the data source my value of KF is 0.03582 but when loading it in DSO, it is becoming 0.0386.

I dont want rounding off as I need to lookup on this DSO with the exact number.

Could you please tell me how can I turn off the rounding off when loading the data into DSO or any alternative soultion for this.

[anshu_lilhori]

Hi,

You need to create the new domain and use that in your new keyfigure.

I would suggest to check out the following SAP Note.

Note 460652 - Extending key figures in BW

Hope this helps.

Regards,

AL

[Loed]

Hi,

In your DATA TYPE, use FLTP (floating) instead of DECIMAL so your keyfigure will allow the the 5 decimal places.

Regards,

Loed

[former_member231709]

Check "How to" https://blogs.sap.com/2014/04/14/customizing-the-domain-for-key-figures/

[former_member594385]

Hi Abhimanyu,

Please modify the key figure properties to not to truncate or round off the value.

Goto key figure->additional properties->Decimal places

You can choose the number of decimal places needed.

Also, Please check the data type of the key figure(Data element data type and size) and make the changes accordingly.

Thanks,

Jay.

[abhimanyu_sharma]

Goto key figure->additional properties->Decimal places -> This is not working as it is related to view the data in BEx.

Data type is DEC as in screenshot. And standard length is 17 and decimal places is 3. We cant change it as it is standard data element.