企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 4008|回复: 18

Feed C level rules

[复制链接]

71

主题

366

帖子

519

积分

高级会员

Rank: 4

积分
519
QQ
发表于 2014-6-28 10:15:14 | 显示全部楼层 |阅读模式
Hi,

I have a problem of an instance RAM growing too much because of feeders.

In a few words:
-My main cube has 14 dimensions.
-Most of data are stored, a few calculation rules getting data from another cube.
-About 10 ratios and indexes calculations. Those calculations are the source of my problem. They are ratios so my rules do not have neither N: nor C:
The calculation works perfectly well, but my users want to be able to use suppress zero functionality. So I had to feed those rules. This makes the RAM grow from about 4 Go (without feeding the ratios) to 21 Go (feeding the 10 ratios).

Here is an exemple of one ratio and its feeders:
['U_WBrand']=['U_TOT']['U_TOT','B1G']*100;
['U_TOT']=>['U_WBrand'];

Any idea why the RAM grows so much?

Thank you
回复

使用道具 举报

76

主题

396

帖子

582

积分

高级会员

Rank: 4

积分
582
QQ
发表于 2014-6-28 11:26:45 | 显示全部楼层
Is U_TOT a consolidation?
回复 支持 反对

使用道具 举报

90

主题

419

帖子

614

积分

高级会员

Rank: 4

积分
614
QQ
发表于 2014-6-28 11:56:18 | 显示全部楼层
jim wood wrote:Is U_TOT a consolidation?

Yes, it is. But it only has two children.
回复 支持 反对

使用道具 举报

70

主题

353

帖子

524

积分

高级会员

Rank: 4

积分
524
QQ
发表于 2014-6-28 12:01:03 | 显示全部楼层
What about U_WBRand? Also are any of the chikdren calculated? How big is your cube dimension wise? Do you have any large dimensions?
回复 支持 反对

使用道具 举报

79

主题

383

帖子

562

积分

高级会员

Rank: 4

积分
562
QQ
发表于 2014-6-28 12:04:25 | 显示全部楼层
You can't feed a consolidation. Referencing a consolidated node in the feeder rule has the effect of feeding all the children underneath the consolidation. So, if you write your rule to calculate the ratio based on all nodes (bascially leaving out the N: or C: before) then the ratio will calculate correctly, but it won't be fed and a zero suppress will hide the ratio, if shown by itself. The only way I know around this is to structure your view so that the row or column that the ratio is in won't be suppressed because there are other values on the same row and/or column that have values and the ratio just comes along for the ride.
回复 支持 反对

使用道具 举报

82

主题

391

帖子

572

积分

高级会员

Rank: 4

积分
572
QQ
发表于 2014-6-28 12:07:09 | 显示全部楼层
tomok wrote:The only way I know around this is to structure your view so that the row or column that the ratio is in won't be suppressed because there are other values on the same row and/or column that have values and the ratio just comes along for the ride.

There are better ways to do this.
For example, turn the ratio into a consolidation by adding a child that is fed correctly or contains base level data.
This will make sure the ratio is fed.
Basically, a component of the ratio could be a valid candidate to be the child. It could be a consolidated element in itself just as well.
Consumes no extra memory at all.
回复 支持 反对

使用道具 举报

87

主题

428

帖子

615

积分

高级会员

Rank: 4

积分
615
QQ
发表于 2014-6-28 12:20:56 | 显示全部楼层
Wim Gielis wrote:For example, turn the ratio into a consolidation by adding a child that is fed correctly or contains base level data.
This will make sure the ratio is fed.
If you make the ratio a consolidation and have other children underneath it that contain anything other than zero then your ratio won't be correct. A ratio of 20% plus another child that has a 1 is now equal to a consolidated ratio of 120%. Not the right answer. You would have to add a child with a zero balance and feed that child. Sorry, I just wouldn't do this.
回复 支持 反对

使用道具 举报

76

主题

377

帖子

549

积分

高级会员

Rank: 4

积分
549
QQ
发表于 2014-6-28 12:20:59 | 显示全部楼层
Hello Tomok

Maybe I did not understand, or maybe I expressed myself in a not so clear way
The ratio will change from N to C level but it will contain the exact same rule (this is, no qualifier for N as this is useless now).
The children of the ratio will just be denominator or numerator of the ratio, depends.

Wim

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?立即注册

x
回复 支持 反对

使用道具 举报

76

主题

403

帖子

586

积分

高级会员

Rank: 4

积分
586
QQ
发表于 2014-6-28 12:44:55 | 显示全部楼层
tomok wrote:[quote]Wim Gielis wrote:For example, turn the ratio into a consolidation by adding a child that is fed correctly or contains base level data.
This will make sure the ratio is fed.
If you make the ratio a consolidation and have other children underneath it that contain anything other than zero then your ratio won't be correct. A ratio of 20% plus another child that has a 1 is now equal to a consolidated ratio of 120%. Not the right answer. You would have to add a child with a zero balance and feed that child. Sorry, I just wouldn't do this.
[/quote]
I don't think Wim was suggesting to replace the rule with a consolidation but rather to keep the rule for U_WBrand and do away with the feeder as this would now be unnecessary.  Provided the rule is written as generically as it is then there isn't any risk as such of the calculated value not being correct as the rule overrides the consolidation.  I find this is frequently a very good approach, but in this instance with this kind of ratio calculation I don't really see a need to feed the calculation at all.
回复 支持 反对

使用道具 举报

86

主题

397

帖子

596

积分

高级会员

Rank: 4

积分
596
QQ
发表于 2014-6-28 12:51:31 | 显示全部楼层
Wim Gielis wrote:There are better ways to do this.
For example, turn the ratio into a consolidation by adding a child that is fed correctly or contains base level data.
This will make sure the ratio is fed.
Basically, a component of the ratio could be a valid candidate to be the child. It could be a consolidated element in itself just as well.
Consumes no extra memory at all.

Hi Wim,

You conclusion sounds very well but I did not understand the way of doing it   
Could you detail it taking into account my context?

Let me just give some additional explanation on my context/rule.

My rule is the following:
['U_WBrand']=['U_TOT']['U_TOT','B1G']*100;
U_TOT is a consolidation of two elements but I think it has nothing to do with my problematic. It could be as well a leaf element.
U_WBrand is a leaf level element, and is part of the same dimension as U_TOT.
B1G is a consolidation of all elements on my Brand dimension.
So in functional terms, U_WBrand is an element on which I can read the weight of a brand relatively to all brands, on all contexts of the cube (for a specific customer or for all, for a specific country or a group of countries, etc.).

As we have big numbers of elements on all dimensions, we need to be able to suppress zeros when looking at that ratio.

Thanks in advance

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?立即注册

x
回复 支持 反对

使用道具 举报

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

本版积分规则

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

GMT+8, 2023-2-8 02:01 , Processed in 0.077220 second(s), 11 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

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