企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 372|回复: 3

Feeder

[复制链接]

77

主题

397

帖子

565

积分

中级会员

Rank: 3Rank: 3

积分
565
QQ
发表于 2014-3-20 20:45:18 | 显示全部楼层 |阅读模式
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
回复

使用道具 举报

77

主题

412

帖子

585

积分

注册会员

Rank: 2

积分
585
QQ
发表于 2014-3-20 22:17:12 | 显示全部楼层
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.
回复 支持 反对

使用道具 举报

87

主题

428

帖子

608

积分

中级会员

Rank: 3Rank: 3

积分
608
QQ
发表于 2014-3-20 22:20:14 | 显示全部楼层
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
回复 支持 反对

使用道具 举报

77

主题

412

帖子

581

积分

中级会员

Rank: 3Rank: 3

积分
581
QQ
发表于 2014-3-21 01:15:00 | 显示全部楼层
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.
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|小黑屋|企业绩效管理网 ( 京ICP备14007298号   

GMT+8, 2018-5-25 17:03 , Processed in 0.109514 second(s), 12 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表