dbTalk Databases Forums  

Calculated Members via Linked Cubes

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


Discuss Calculated Members via Linked Cubes in the microsoft.public.sqlserver.olap forum.



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

Default Calculated Members via Linked Cubes - 07-02-2004 , 05:06 PM






Hi,

I am using DSO to create a virtual cube using 2 or more linked cubes.
All of the source cubes for my linked cubes have the same calculated
members (MDX queries). So I want to utilize the Commands collection
of the first linked cube to obtain the name and statement for each
distinct calculated member. However, the Commands collection of the
linked cube appears to be empty when I access it thru DSO. When I
browse the linked cube, I can see the calculated members are included.

Are the calculated members of a source cube available in the Commands
collection of a linked cube? Is there another way to retrieve these
statements without using DSO to connect to the source server.

Any comments would be greatly appreciated.

Thanks,
Burotn

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.