Bug or feature, Expanding multiple dimension with multiple level.

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
 
Top