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]) |