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?