dbTalk Databases Forums  

Re-evaluate named sets at reference time?

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


Discuss Re-evaluate named sets at reference time? in the microsoft.public.sqlserver.olap forum.



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

Default Re-evaluate named sets at reference time? - 06-04-2004 , 08:05 PM






Named sets can simplify calculations greatly. But it is only evaluated
at time it is parsed. Is there a way to have named set evaluated at
time of reference?

If not, is there another mechanism for that? Can alias be saved in
cube and referenced in calculations?

Any improvements made for named sets in Yukon?

Reply With Quote
  #2  
Old   
Brian Altmann
 
Posts: n/a

Default RE: Re-evaluate named sets at reference time? - 06-07-2004 , 09:56 AM






You can use the StrToSet function to force evaluation at calculation time
Be aware of performance impact, though
HTH
Bria
www.geocities.com/brianaltmann/olap.htm


Reply With Quote
  #3  
Old   
Bo Dong
 
Posts: n/a

Default RE: Re-evaluate named sets at reference time? - 06-07-2004 , 04:48 PM



Brian,

Did you mean SetToStr? If not, how would you use StrToSet? In named sets
or in calculated members referencing named sets?

Would you provide a simple MDX sample code? I am new to MDX syntax...

Thanks,

Bo



*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Reply With Quote
  #4  
Old   
Brian Altmann
 
Posts: n/a

Default RE: Re-evaluate named sets at reference time? - 06-09-2004 , 07:31 AM



After digging a little more, I found I've used this technique for sets defined within MDX queries (With set), not named sets
Sorry, my mistake
Regards
Brian

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.