SQL Server Performance

Catalog Information for Offline Cubes no longer there

Discussion in 'SQL Server 2005 Analysis Services' started by jalvzz, Jan 21, 2008.

  1. jalvzz New Member

    Hi All,I have tried to access an offline cube with a third party tool and it does not connect to it.
    I was told that the cube does not contain catalog information.
    Does anybody know if this catalog information has been removed from recent versions of MS AS 2005 or Excel when creating offline cubes???
    Thanks
  2. satya Moderator

    To solve this, use the MOLAP storage mode. To check what storage mode you have, use either SQL Management Studio or BI Development Studio. With SQL Management Studio, use the properties dialogs to check each dimension, cube and partition. With BI Development Studio, connect to the database in online mode (File -> Open -> Analysis Services Database).

Share This Page