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.