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

[Former Member]

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?

[Former Member · Accepted solution]

Did you see Not Assigned for ALL the Categories ans Subcategories?

If this happens only for certain Categories ans Subcategories maybe there is no data for this filters....

First verify that data for this Categories ans Subcategories exist....

Regards

[Former Member · Accepted solution]

Yes, in the context of the hierarchy, there is data in all nodes. In this context, the data gets rolled up all the way to the top level.

However, if I run a query with the category or subcategory characteristics explicitly on the template, it returns one row - Not Assigned. And the data value is the sum of all of the children -- it is just not broken down by category element.