Skip to Content
Former Member
Jun 08, 2007 at 02:03 PM

All characteristic values come back as Not Assigned for higher level nodes


I have created an InfoCube with a Product hierarchy (Category, Subcategory, Item). The InfoCube contains all three characteristics, and the hierarchy is on the Item characteristic. The data was loaded at the Item level. When I run a query using the hierarchy, I see data at all of the levels. Also, when I run a query using the Item characteristic on its own, I see data correctly at the Item level. However, when I run a query using Category or Subcategory characteristics explicitly, the data comes back as 'Not Assigned'. Why does the data come back for the Category/Subcategory levels in the hierarchy, but not for the explicit characteristics?