Feeders

[bhurtado22]

Hi community, Im relative new in TM1 and I need to know if in the real life exist one feeder for rule or exist N feeder's options for rule that works in the right way.

Specificaly I need to write a feeder for the next rule:

['Moneda de Origen','Presupuesto','Saldo']= N:IF(ATTRS('Dim_CuentasBalance', !Dim_CuentasBalance, 'Cartera(Y/N)')@='CT',
DB('Cbw_Cartera',!Dim_CuentasBalance,!Dim_Entidad,!Dim_Moneda,!Dim_BCorporativoResto,IF((!Dim_Mes)@='Jan',STR((Numbr(!Dim_Año)-1),4,0),!Dim_Año), ATTRS('Dim_Mes',!Dim_Mes,'Mes_anterior'),!Dim_Conversion,'Presupuesto','Saldo')
+
['Nueva Colocacion','Presupuesto']
-
['Recuperaciones Proyectadas','Presupuesto']
-
['Recuperación Nuevas Colocaciones','Presupuesto'],CONTINUE);

I have tried many ways but they haven't work.

I will apreciate your help.

Thank you so much...

[Christopher Kernahan]

Hi bhurtado22,

There are many possible feeders for most rules, with varying degrees of performance impacts. I think you could benefit from looking more closely into the guide and other posts around here.

Your aim is to place a feeder flag on these cells

['Moneda de Origen','Presupuesto','Saldo']

when they are non-zero.So if any of the inputs are always non-zero, you can just feed those into the selected area

['Nueva Colocacion','Presupuesto'] => ['Moneda de Origen','Presupuesto','Saldo']

Otherwise you may need to write a more general feeder.

[bhurtado22]

My big problem is with the first part of the rule:

['Moneda de Origen','Presupuesto','Saldo']= N:
IF(ATTRS('Dim_CuentasBalance', !Dim_CuentasBalance, 'Cartera(Y/N)')@='CT',
DB('Cbw_Cartera',!Dim_CuentasBalance,!Dim_Entidad,!Dim_Moneda,!Dim_BCorporativoResto,
IF((!Dim_Mes)@='Jan',STR((Numbr(!Dim_Año)-1),4,0),!Dim_Año), ATTRS('Dim_Mes',!Dim_Mes,'Mes_anterior'),!Dim_Conversion,'Presupuesto','Saldo'),)...

I have spent a lot time trying differents options but any has worked.

Could someone tell me how to do it...

Regards

[Gregor Koch]

Hi

It would be helpful to know in which cube this rule sits and what the dimensionality of all the cubes that are involved. Also post what you have tried so far, if anything.

A general pointer though:
If you are using something like this ATTRS('Dim_Mes',!Dim_Mes,'Mes_anterior') in your rule you always need something like that ATTRS('Dim_Mes',!Dim_Mes,'Mes_proximo') for your feeder, same applies for years, given google translated this correctly.