dbTalk Databases Forums  

Calculated Members Runtime Clarificiation

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


Discuss Calculated Members Runtime Clarificiation in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Marcel K, MCDBA
 
Posts: n/a

Default Calculated Members Runtime Clarificiation - 06-03-2005 , 03:11 PM






In effort to optimize response - I seek clarification regarding Calculated
Members using .currentmember for level evaluation. Anticipating that they
may cause overhead in query performance - do the use resources to refresh
only when included in a query (dragged onto pivot) or do they refresh
whenever query has reference to parent dimension (i.e. measures). The cube
currently contains 43 calculated members. Your input is most appreciated.

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 - 2013, Jelsoft Enterprises Ltd.