Symptom
- 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 - 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:
- Create/reuse existing Database Analysis User
- Open Datasphere's HANA Cloud via "Open Database Explorer"
- Under Database Diagnostic Files → instance_UUID → indexserver, check logs
- After reproducing the issue in SAC, search by most recent "Hierarchy error"
- 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
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