cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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
0 Kudos

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.

Answers (2)

Answers (2)

Former Member
0 Kudos

In first case you must setup the hierarchy you want to use....it works fine ...whe you want to use the characteristic you must deactivate the Show as hierarchy option....maybe it could the problem....

Regards

Former Member
0 Kudos

The problem is not in BEx. The problem is in the InfoCube itself. The data simply does not get rolled up to the Category and Subcategory levels if those characteristics are used explicitly. This is what I am seeing

If I use the Item Hieararchy:

Category1 30

Subcategory1 10

Item1 7

Item2 3

Subcategory2 20

Item3 12

Item4 8

So basically, the higher level nodes represent the aggregation from the Item Level.

However, if I design a query with just Category (or Subcategory), I get the following:

Not Assigned 30

But if I design a query with just Item, I will get

Item1 7

Item2 3

Item3 12

Item4 8

Any ideas?

Former Member
0 Kudos

Not Assigned appears when the record that you see dint have any value for the filter you have selected....are you sure that you are using the correct characteristic for the filter...Material have many characteristics for catgorization...

Regards

Former Member
0 Kudos

There is no filter. I am trying to get back all elements of Category and all I get is Not Assigned.