E
Erdal Akbulut
Hi,
I use SQL Server 2000 Analysis Services and OWC 11
I have three dimensions in my cube.
Company,
Customer
and Item.
Customer Dimension has three level
Country
Region
Customer
Item Dimension has three levels
Family
Category
Item
When I add only Item or Customer dimension in a pivot table I can drilldown
to the level without any problem, but when I add two dimensions together,
It jumps to second dimension without after first level of first dimension.
For example
If I add First Customer and then Item to the row area. I can see the Country
level of Customer when I expand the selection then It shows familiy from
Item without showing Region of the Coustomer Dimension.
Any Idea? is this a bug or something that I can control.
Thanks in advance.
erdal
I use SQL Server 2000 Analysis Services and OWC 11
I have three dimensions in my cube.
Company,
Customer
and Item.
Customer Dimension has three level
Country
Region
Customer
Item Dimension has three levels
Family
Category
Item
When I add only Item or Customer dimension in a pivot table I can drilldown
to the level without any problem, but when I add two dimensions together,
It jumps to second dimension without after first level of first dimension.
For example
If I add First Customer and then Item to the row area. I can see the Country
level of Customer when I expand the selection then It shows familiy from
Item without showing Region of the Coustomer Dimension.
Any Idea? is this a bug or something that I can control.
Thanks in advance.
erdal