Symptom
Currency Conversion or Unit Conversion is not working, if the view is shared from another space.
For example,
Space A: contains Currency Conversion tables (TCUR* tables) and the FACT views which contains currency conversions.
Space B: only contains the Analytical Models. FACT views from Space A are shared to Space B, then an Analytical Model is build on it.
Below error occurred when preview the Analytical Model based on the view:
Caught exception : exception 70000719: currency/unit conversion error: could not read currency precisions from table "MSE_DATASPHERE_TEAM"."SAP.CURRENCY.VIEW.TCURX" - insufficient privilege: Detailed info for this error can be found with guid 'xxx' at Authorization/insuffPriv/impl/InsufficientPrivilegeThrow.cpp:365
Environment
SAP Datasphere
Reproducing the Issue
- Open Analytic Model which
- Click Preview button.
Cause
Program Error in Hana Cloud.
Resolution
The issue has been fixed with a new SAP HANA Cloud patch - 2024.40.13. Current default release version of SAP HANA Cloud in Datasphere is 2024.40.11 (QRC4/2024), which was upgrade done on January 11/12, next upgrade plan is upgrading with Datasphere QRC1/2025 in April 2025. Before that, manually upgrade SAP HANA database with SAP Datasphere administrator as below: Apply a Patch Upgrade to Your SAP HANA Database.
See Also
- Apply a Patch Upgrade to Your SAP HANA Database
- SAP Note 3220622 - HANA Cloud Release for SAP Datasphere
Keywords
currencyconversion, Insufficientprivilege, authorizations, , KBA , DS-MD-AM , Analytic Model , Problem