KNOWLEDGE BASE

Unusual Values Appearing When Attempting to Use a Dimension Hierarchy With SAP BW


Published: 14 Oct 2016
Last Modified Date: 14 Oct 2016

Issue

In some of your analyses, you may notice that certain dimension hierarchies have a value called “Not Assigned” on Level 0 of a hierarchy, with the other values not appearing until the bottom level.

Environment

  • Tableau Desktop
  • SAP NetWeaver Business Warehouse

Resolution

Work with your SAP BW administrator to resolve this data modeling issue. By default, a "Not Assigned" node is added to the hierarchy.

For example: suppose there are 1000 characteristic values for the characteristic “Material”. A hierarchy with material groups from a total of 100 materials is defined for it. The remaining 900 (1000-100) characteristic values, are positioned under node Not Assigned.

Cause

This issue occurs when there are characteristic values that do not appear in a hierarchy.
Did this article resolve the issue?