dbTalk Databases Forums  

KPI resolution/solve order???

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


Discuss KPI resolution/solve order??? in the microsoft.public.sqlserver.olap forum.



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

Default KPI resolution/solve order??? - 07-18-2005 , 06:17 AM






I have a Calculated Member based on two other Calculated Members.

Each of the "base" Calculated Members changes acording to the current member
of the period dimension. However when they are used within the "Master"
Calculated Member, it was as if the result of the base Calculated Members was
static across periods. Is there a way to force the base Calculated Members to
resolve fully before the Master Calculated Members executes?

base Calculated Member 1: (CurrentCalcYear: solve order 1)

CLng([Period].CurrentMember.Properties("Rel Calc Year"))

base Calculated Member 2: (CurrentRelPeriod: solve order 2)

CLng([Period].CurrentMember.Properties("Rel Period"))

Master KPI: ( solve order 3)

(FILTER([Period].[Level 02].Members,
CLng([Period].CurrentMember.Properties("Rel Year")) =
[DimCalc].[CurrentCalcYear] And CLng([Period].CurrentMember.Properties("Rel
Period")) = [DimCalc].[CurrentRelPeriod] ).item(0),[DimCalc].&[1])




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.