on 06-08-2007 3:03 PM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.