Feeder

亚伯拉汉

Hi All

I need your help getting this feeder.
['Moneda de Origen','Presupuesto','Saldo'] = N: IF(ATTRS('Dim_CuentasBalance', !Dim_CuentasBalance, 'Cartera(Y/N)')@='YVI',
(1-DB('Cbw_Cartera',ATTRS('Dim_CuentasBalance',!Dim_CuentasBalance, 'Cartera'),!Dim_Entidad,!Dim_Moneda,!Dim_BCorporativoResto,!Dim_A帽o,!Dim_Mes,!Dim_Conversion,!Dim_Versiones,'% de Mora'))
*
DB('Cbw_Cartera',ATTRS('Dim_CuentasBalance',!Dim_CuentasBalance, 'Cartera'),!Dim_Entidad,!Dim_Moneda,!Dim_BCorporativoResto,!Dim_A帽o,!Dim_Mes,!Dim_Conversion,!Dim_Versiones,'Saldo'),CONTINUE);

I have tried several ways but I do not consolidate the information.

Kings Regards

JC

龙创天下

No hablo.

All I can see is that you are multiplying the 'Saldo' with a percentage which would lead me to suggest to feed from 'Saldo'.

Could you post whether this rule is in the 'Cbw_Cartera' cube? What's the order of dimensions of the cube where the rule sits?
In which dimension are 'Moneda de Origen' and 'Persupuesto'?
Is the 'Dim_CuentasBalance' a period dimension?
Does the rule actually work on N: level?

Generally I would say that the elements in the 'Dim_CuentasBalance' dimension that are returned by the ATTRS in turn need to have an attribute that you can use to figure out where to feed to.

sysease

Hi Gregor

The rules is the Cbw_Cartera,
the order of the dimensions is following
Dim_CuentasBalance (accounts)
Dim_Entidad
Dim_Moneda
Dim_BCorporativoResto
Dim_A帽o
Dim_Mes
Dim_Conversion (Moneda Origen)
Dim_Versiones (Presupuesto)
Dim_MedidasCartera
Yes actually work on N: Level

Thanks and regards

JC

sjgogo

Hi
Say ATTRS('Dim_CuentasBalance',!Dim_CuentasBalance, 'Cartera') returns other N Level accounts and there is a one to one relationship then all you need to do is create another attribute ( 'Cuentas para ser alimentado') that stores the account that needs to be fed for these (the ones that are referenced by the  ATTRS('Dim_CuentasBalance',!Dim_CuentasBalance, 'Cartera')) N Level accounts.

Example (Account 4321 is an N level element):
If
ATTRS('Dim_CuentasBalance','1234, 'Cartera')='4321'

then this should be the case
ATTRS('Dim_CuentasBalance','4321', 'Cuentas para ser alimentado')='1234'

And this should work:

['Moneda de Origen','Presupuesto','Saldo']=>
DB('Cbw_Cartera',ATTRS('Dim_CuentasBalance',!Dim_CuentasBalance, 'Cuentas para ser alimentado'),
!Dim_Entidad,!Dim_Moneda,!Dim_BCorporativoResto,!Dim_A帽o,!Dim_Mes,!Dim_Conversion,!Dim_Versiones,'Saldo')

If your rule picks up a consolidated value from the account in ATTRS('Dim_CuentasBalance',!Dim_CuentasBalance, 'Cartera') it is a bit more tricky as the Feeder engine will never check an attribute which sits against that consolidation, because a consolidation on the left hand side of a feeder is a 'short cut' for all it's children.
In that case you would need to fill the 'Cuentas para ser alimentado' attribute for the children of that consolidation.

Say '4321' from above is a consolidation and its children are 4321.01 and 4321.02, then the attribute for the two latter elements should be filled with '1234' and this should hold true:
ATTRS('Dim_CuentasBalance','4321.01', 'Cuentas para ser alimentado')='1234'
ATTRS('Dim_CuentasBalance','4321.02', 'Cuentas para ser alimentado')='1234'

There feeder would stay the same.

Maybe you also read some threads here on conditional feeding which could be applied here (the condition being that there is also a %) but I have left it out to hopefully simplify things.
I hope this gets you going.

BTW, when you say "tried several ways" it also helps to post the feeder statement you have tried already.