dbTalk Databases Forums  

Ancestor - parent function

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


Discuss Ancestor - parent function in the microsoft.public.sqlserver.olap forum.



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

Default Ancestor - parent function - 07-09-2003 , 01:22 PM






I have a dimension with levels from 1 to 3.
I have defined a set as {level3a, level3b, level3c}. This
set has members from level3 under different hierarchy.
With this, how do i get a set which has all the parents of
the above set.

Ancestor function takes only members and not set. Is there
any function which gets the set of parents for a set of
members?

Thanks
GS

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.