SQL Server Performance

OlapObjects Table [Need Help]

Discussion in 'Analysis Services/Data Warehousing' started by NicolasMaz, Apr 17, 2007.

  1. NicolasMaz New Member

    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 ...
  2. satya Moderator

    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.
  3. NicolasMaz New Member

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

Share This Page