Symptom
Hierarchy text from SAP Datasphere is not displayed in Analysis for Office and SAC story.
Environment
SAP Datasphere
Reproducing the Issue
Take Analysis for Office side as an example:
- Open view in Analysis for Office
- Expand "XXX" --> "Hierarchy"
- Drag "XXX Hierarchy" and drop to Rows area
- Error
InA result set Parsing Exception: Error\: JsonException, when trying get JObject at index 0 (com.sap.ip.bi.bics.dataaccess.resource.impl.ina.exceptions.INARuntimeException-RESULTSET_PARSING)
Cause
The issue is happening because of duplicate entries for member in the text view for single language. This leads to hierarchy having multiple parents for single node. Note, hierarchies having multiple parents for single node is not allowed.
Resolution
Please correct the involved text view to have single member per language i.e. (Legal Entity, LANG) pair must be unique.
See Also
Keywords
KBA , DS-MD-VIW , Views , Problem