Attribute as a Feeder !!!

[pmathur]

Hi all,

I have a question, can we use a Attribute,tagged with some dimension,as a feeder in cube.

The scenario is like, I have a "Ess_Entities" as a dimension and "Rate" as an Attribute. Now I have a rule statement as :

['All in Rate'] : N ATTRN('Ess_Entities',!Ess_Entities,'Rate');

which fetches the rates tagged with individual loans and store that in "All in Rate".

So now i want to feed the cell "All in rate" with this attribute. If I wont use feeder then values in "All in Rate" wont populate after zero suppression.

Can any one suggest how to feed the cell "All in Rate" just something like :

[attribute] => [measure element];

or something else ?




Regards.
Priyank

[Marcus Scherer]

you need to write the feeder in your attribute cube: '}ElementAttributes_Ess_Entities'

the feeder would then look like - depending on the order of your dimensions in the target cube:
['Rate'] => DB(targetcube,dim1, dim2,..., !Ess_Entities);

[pmathur]

Hi Marcus Scherer,

Thanks for reply. Since I tried the way which you suggested, but in this case, when I tries to save the rule statement in source cube i.e }ElementAttribute_Ess_Entities then the Rule window crashes and memory goes on increasing.

Regards.
Priyank

[lotsaram]

Assuming the cube you are feeding has significantly more than 2 dimensions and assuming that for the missing dimensions you are feeding to the top consolidated element. Then feeding from an attribute cube is a VERY BAD idea and something that should never be done. This topic has been discussed on this forum dozens of times if not more so I won't go into detail as you should be able to find it elsewhere if you do a search. But to summarize your feeder does not have to be the inverse of the rule! The feeder is just an arbitrary flag to consolidate the cell, you should feed the measure from another leaf cell containing data and not from the attribute that the value comes from. Feeding from the attribute to the top level of all missing dimensions as you have now discovered will blow memory and cause poor performance by making the cube dense (hence it is a bad idea.)

[tomok]

Why would you want to feed rate anyway? The only reason I could think of would be to have it in a zero suppressed view. It doesn't have to be fed in order for your rate times loan balance to result in interest. If you absolutely do have to feed it, I would feed it with the loan balance element. After all, if there is no loan balance then there is no interest.