SAP Knowledge Base Article - Public

2879693 - Changing Data Access Control by manipulating hierarchy has no effect when multiple hierarchies are maintained for a dimension in SAP Analytics Cloud

Symptom

When Data Access Control is maintained for a dimension with multiple hierarchies, only the first hierarchy's parent-child relationship applied is in effect for Data Access Control.

Environment

SAP Analytics Cloud

Reproducing the Issue

  1. Go to the dimension screen by selecting from public dimensions or inside a model of interest.
  2. Add multiple parent-child hierarchies in a dimension with Data Access Control.
  3. Maintain different parent-child relationships on different hierarchies.
  4. Only the first set of relationships is in effect.

Cause

This is currently by design of the system due to technical limitations.

Resolution

User can build a hierarchy only for Data Access Control purpose, and then add different hierarchies based on business requirements.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

 SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working , KBA , LOD-ANA-PL , Planning , Problem

Product

SAP Analytics Cloud all versions