dbTalk Databases Forums  

Cube Structure

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Cube Structure in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Sanka
 
Posts: n/a

Default Cube Structure - 09-11-2003 , 09:53 PM






Hi All,

I have a .CAB file and I don't have the relaional database
which is used as the data source for the Cubes present in
the .CAB file.

After restoring the .CAB File in the Analysis Manager, as
I don't have the relational Database I am not able to edit
the structure of the Cube.

I want to know the Cube Structure.
What tables are being referred by the Dimensions.
How many Hidden calculated members are there. What are the
solve order for the calculated members.
etc..

Any ideas...

Cheers,
Sanka

Reply With Quote
  #2  
Old   
Thomas
 
Posts: n/a

Default Re: Cube Structure - 09-12-2003 , 04:33 AM






You should be able to get the cubes meta data via ADO MD.

Try the Cube Documentation Tool from Tom Chesters webpage http://www.tomchester.net/

It might document all you need, but is a good start and easy to adjust.

Thomas

"Sanka" <loonysan (AT) mailcity (DOT) com> wrote

Quote:
Hi All,

I have a .CAB file and I don't have the relaional database
which is used as the data source for the Cubes present in
the .CAB file.

After restoring the .CAB File in the Analysis Manager, as
I don't have the relational Database I am not able to edit
the structure of the Cube.

I want to know the Cube Structure.
What tables are being referred by the Dimensions.
How many Hidden calculated members are there. What are the
solve order for the calculated members.
etc..

Any ideas...

Cheers,
Sanka

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.