SAP Knowledge Base Article - Public

3328635 - Hierarchy text from SAP Datasphere is not displayed in Analysis for Office and SAC story

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:

  1. Open view in Analysis for Office
  2. Expand "XXX" --> "Hierarchy"
  3. Drag "XXX Hierarchy" and drop to Rows area
  4. 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

Add a Hierarchy to a Dimension | SAP Help Portal

Keywords

KBA , DS-MD-VIW , Views , Problem

Product

SAP Datasphere all versions