Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 analysis services Hiearchy cube

Author  Topic 

foxjazz
Starting Member

1 Post

Posted - 2007-06-30 : 15:27:02
I setup Hiarchy in the dimentions of my cube, however when I go and look at it via proclarity, I can't see the hiearchy there.

I have one table that has:

Category
Subcategory
Partnumber

And I have the hiearchy set from Subcategory to partnumber.

Then I go into proclarity and limit the category by "my catname" and I still see the 8000 partnumbers in the list.

Any ideas?

coolerbob
Aged Yak Warrior

841 Posts

Posted - 2007-07-04 : 08:11:24
Just so I understand at what level to come in, how many OLAP databases have you designed using Analysis Services?
Go to Top of Page
   

- Advertisement -