TM1 Forum

I am trying to replicate this calculation (syntax is from Architect rule) using the Performance Modeler interface.

Cube with the calc and dimensions:
EarnedPremium
Version
LOB
Time => Standard e.g. Jan 2013 has a text attribute for EpPatternYear (2013) that is used in the DB to get the pattern
Acct

Cube with the EpPattern (factor) and dimensions:
EpPattern
LOB
Period
Year => member is 2013

Architect rule syntax:
#Calculate forecasted New Earned Premium for Outer Periods (New Written Premium * EpPattern )
#Period1 Calc - Uses Current Month Premium times the pattern
[Acct:'New Written Premium'] *
DB ('EpPattern',!LOB, 'Period1', Attrs('Time',!Time,'EpPatternYear')); =>gets the pattern/factor needed for the calc
#End Period1 Calc

This is as far as I can get the code in PM:
=if [Time].InnerPeriod = 0 then
([Acct]:[New Written Premium] * [<operand 2>])
else
CONTINUE()

Question:
How do I get [<operand 2>] to pull back the period1 factor from the EpPatten cube using the PM interface?


Thanks,
Bruce

I can't think of many insurance models for which Performance Modeler would be the right tool. You need the real deal.