TM1 Forum

Hi All,

I am using Cognos TM1 9.5.2 version

I have a rule as follows

{'1 Month premium Profile','3 Months premium Profile',
'6 Months premium Profile',
'9 Months premium Profile',
'12 Months premium Profile',
'18 Months premium Profile',
'24 Months premium Profile',
'30 Months premium Profile',
'36 Months premium Profile',
'48 Months premium Profile',
'60 Months premium Profile'},'UPRBudgetActuals']=N:
DB('LA_PLN_PremLoss_UPR','Budget',!Currency,'All_Business_type',ATTRS('Country',!Country,'CntryCode'),ATTRS('Operating Unit',!Operating Unit,'OperatingunitCode'),,DB('LA_PLN_PlanCycle_Lkp','Budget_Year','Current_Period'),!Month,ATTRS('PS_Accounts',!PS_Accounts,'Assumption'))\
DB('LA_PLN_PremLoss_UPR','Budget',!Currency,'All_Business_type',ATTRS('Country',!Country,'CntryCode'),ATTRS('Operating Unit',!Operating Unit,'OperatingunitCode'),DB('LA_PLN_PlanCycle_Lkp','Budget_Year','Current_Period'),!Month,'NWP.')

The ATTRS of ATTRS('PS_Accounts',!PS_Accounts,'Assumption') returns 1 Month NWP, 3 Months NWP Correspondigly

The ATTRS of Country and operating unit gives the consolidated elements (Eg., Total Argentina, Total Brazil)

I tried all possible ways to write feeders for this rule as

['NWP.']=>['1 Month Premium Profile','UPR Budget Actuals']
['NWP.','Total Contry','Total Operating Unit']=>['1 Month Premium Profile','UPR Budget Actuals']
['NWP.','Total Contry','Total Operating Unit','All_BusinessType']=>['1 Month Premium Profile','UPR Budget Actuals']

But it is not feeding

So, can anyone please suggest me how to write feeders for this rule

Thanks
Regards
Guru

Hello

In copy/pasting, you missed the [ character as the first character and the ; as the last character. I hope this wasn't intentionally.
Why does your measure end in a period (NWP.) ? While it should work fine, it looks a bit weird.

On-topic:
- does your rule calculate correctly at N-level?
- is your C-level result supposed to be a sum of the fractions you have at N-level?

Wim

Are you sure it's the feeder? The rule is the complicated part, try it without skipcheck and feeders to see if that makes a difference.

In the rule you've got two commas side by side, this will prevent the rule working

DB('LA_PLN_PremLoss_UPR','Budget',!Currency,'All_Business_type',ATTRS('Country',!Country,'CntryCode'),ATTRS('Operating Unit',!Operating Unit,'OperatingunitCode'),,DB('LA_PLN_PlanCycle_Lkp','Budget_Year','Current_Period'),!Month,ATTRS('PS_Accounts',!PS_Accounts,'Assumption'))\
DB('LA_PLN_PremLoss_UPR','Budget',!Currency,'All_Business_type',ATTRS('Country',!Country,'CntryCode'),ATTRS('Operating Unit',!Operating Unit,'OperatingunitCode'),DB('LA_PLN_PlanCycle_Lkp','Budget_Year','Current_Period'),!Month,'NWP.')