SAP Knowledge Base Article - Public

3350645 - Story can't consume Datasphere model due Hierarchy error

Symptom

  1. Create a new story in SAP Analytics Cloud (SAC) based on SAP Datasphere model (for example an Analytical Dataset) causes error:
    "Please contact your administrator. Model: DATASPHERE_MODEL"

    In Dev Tools -> Network there is a more comprehensive error:
    [42208] Can't read the view : DATASPHERE_SPACE:/DATASPHERE_MODEL::[INAMODEL], reason: Hierarchy error

  2. When previewing data for Analytic Model, error occurs:
    The query executed with errors. The hierarchy doesn't exist : HIERARCHY_NAME

Environment

SAP Analytics Cloud 

SAP Datasphere

Cause

The issue is caused by non supported hierarchy scenario as mentioned in SAP Help Add a Hierarchy to a Dimension:

"The following hierarchy features are not supported:

  • Multiple parents
  • Unassigned members
  • Cycle handling"

Resolution

In order to identify the problematic node:

  1. Create/reuse existing Database Analysis User
  2. Open Datasphere's HANA Cloud via "Open Database Explorer"
  3. Under Database Diagnostic Files instance_UUID  indexserver, check logs
  4. After reproducing the issue in SAC, search by most recent "Hierarchy error"
  5. Get a most comprehensive error, such as:
    PreparedQueryExecutor.cpp(00090) : Caught SQL exception: Hierarchy error: The hierarchy source data contains node &PROBLEMATIC_NODE& having multiple parents but the hierarchy is specified to reject such nodes.

This problematic child node has multiple parents.

Another alternative is using Validating View Data. This performs a check in data to validate if there are errors and/or inconsistencies.

The solution is to correct the hierarchy data or remodel the hierarchy for proper fix.

See Also

Getting Started With the SAP HANA Database Explorer

Keywords

"The hierarchy doesn't exist", [42208] Can't read the view, Hierarchy error, Datasphere model , KBA , DS-MD-VIW , Views , LOD-ANA-DES , Story Design & Visualizations , Known Error

Product

SAP Analytics Cloud all versions ; SAP Datasphere all versions