SQL Server Performance Forum – Threads Archive

OlapObjects Table [Need Help]

Hi All, I try to get some information over the cubes i created (Analysis Manager 2000). I saw that a lot of very usefull information are in the Analysis Services data warehouse repository.
Someone else in my department told me he moved the "msmdrep.mdb" to SQL server. So i only have 2 tables, OlapObjects and Server. Is that Normal ?
Anyway, the bigest problem is that i can’t find any information typeclass=10 (measures!)!
I only have classtype=2,3,6,7,9,19,33 ! Anyidea Why ?
Also on some cube, i do not have all information information that should be in this table ? Some Dimensions are missing. I also do not really understand the way this table work. A lot of cube have the same parentID, any chance by an SQL request to get only information from a cube ? If someone knows anyhting about this table (OlapObjectÃ or has a link i would be very glad to have it. Regards and sorry for my english …

http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=2805 Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Thank you satya, I checked this link yesterday and did not find what i wanted. I might have not looked correctly.

]]>