Symptom
Hierarchy Management showing "#" for restricted members in SAP Analytics Cloud.
Environment
Reproducing the Issue
- Login to SAC.
- Open a model with a hierarchy management and Data Access Control enabled.
- Go to Hierarchy Management workspace.
>> Notice that the hierarchy is showing "#" for restricted members.
Cause
This is a by design behavior and works as expected.
Resolution
The hierarchy management requires full access to all dimension members (at least full read access). Otherwise the hierarchy cannot be displayed correctly if there are intermediate nodes missing due to missing privileges.
Keywords
Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, Issue, sapanalyticscloud, sap analytical cloud, sap analytical cloud, not found, missing, role. , KBA , LOD-ANA-ML-MDM , Master Data Management , Problem