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. |