Symptom
Decimal places for key figures in the OData query result and the web browser report are not the same.
Environment
- Business By Design
- Cloud for Customer
Reproducing the Issue
- Open your report in the browser.
- Execute the same report via an OData query.
For key figures with decimals, you may notice a difference in decimals. For example: In the report, it may be 2-3 decimal places whereas in OData, it shows 6-7 decimal places.
Cause
In the OData Service, each key figure has versions: One unformatted and one formatted. The formatted one shows the decimals as set up in the browser report. The unformatted key figure shows the default number of decimals for that data type.
Resolution
If execute the metadata OData query of the report, you will notice 2 different IDs for the same key figure.
For example: In the ByDesign data source Trade Receivables Payables Register, you will have the following key figures:
FCOUTSTANDING_AMNT and KCOUTSTANDING_AMNT
On the UI, there is only 1 key figure.
Here, FCOUTSTANDING_AMNT is the formatted one and KCOUTSTANDING_AMNT is the unformatted one. Using FCOUTSTANDING_AMNT will show the same results as seen in the browser report.
Keywords
report, business analytics, key figure, wrong decimals, odata , KBA , key figure in odata , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem