SAP Knowledge Base Article - Public

2356511 - SAP Analytics Cloud Hierarchy in Dimension Not Appearing Correctly When Maintaining dimensions with more than 1000 rows

Symptom

  • Create a dimension with a large amount of dimensions members.
  • After adding more than 1000 (1 thousand) members to a parent child hierarchy (PCH), the HIERARCHY (tree / parent-child relationships) preview does not appear properly.
  • Only the selected (high-lighted) child (leaf) member and its parent (member / node) appears in the HIERARCHY preview.

Environment

  • SAP Analytics Cloud

Reproducing the Issue

  1. Go to the  Modeler > Dimension tab.
  2. Create a dimension (the dimension type does not matter - Generic / Organization / Account).
  3. Copy more than 1000 rows into the dimension and define at least 1 new parent dimension member.
  4. Assign the new parent member to the 1000 dimension members (defined in step 3) in the Hierarchy column.
  5. Observe that the hierarchy preview only appears for the currently selected member.

Cause

There is a paging feature for performance reasons that limits the HIERARCHY preview to 1000 rows in a dimension.

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

dimension, boc, c4a, cloud, planning, generic, hierarchy, tree, parent, expand, child, nodes, hierarchies, node, EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, SAC, SAP BusinessObjects Cloud, Business Objects , KBA , p-c-h node top level hierachy , hierarchy , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem

Product

SAP Analytics Cloud 1.0