Hierarchy text from SAP Datasphere is not displayed in Analysis for Office and SAC story.
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
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)
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.
Please correct the involved text view to have single member per language i.e. (Legal Entity, LANG) pair must be unique.
KBA , DS-MD-VIW , Views , Problem