Can't create feeder

[asvlad]

Could anybody help me to create feeders for the following rule?:

[]=N:IF(SUBST(!Dim_El,1,1)@='}',
IF(SUBST(!Dim_El,2,1)@='1',
IF(DB('Cube_el',!Months,SUBST(!Dim_El,3, LONG(!Dim_El)-2))<>0,1,0),
DB('Cube_el',!Months,SUBST(!Dim_El,3, LONG(!Dim_El)-2))),
continue);
C:IF(DIMIX('Dim_El','}1'|!Dim_El)>0,
DB('Cube_el',!Months, '}2'|!Dim_El)\DB('Cube_el',!Months, '}1'|!Dim_El),
continue);

[lotsaram]

How about you start by explaining exactly what the rule is supposed to be doing and what you need this rule for, as I think you might be able to get some alternate design suggestions from folks here that might be more efficient and serve you better.

1/ From what I can see you are doing a pure lookup type calculation from some time period logic in a 2D cube. Since this would always be queried directly it doesn't need to be fed (and in a 2D cube there is generally no performance impact of not feeding since data is dense.)

2/ For such a case where the result of the lookup calculation looks to be a once off as opposed to constantly changing then from an efficiency and performance point of view you would be better off doing the calculation in TI or Excel and loading the leaf cells as values and having only the C rule in the cube.

[asvlad]

lotsaram, thank you for your reply!

The goal which is solving by this rule is universal calculation of averages.
If in the dimension exists element which has two the same elements starting with '}1' and '}2' this element must be consolidated as avarage. And it doesn't matter how many such elements exist in this dimension. All of them must be calculated by this single rule.

Real cube has more then 2 dimensions. And thete are a lot of such cubes and such dimensions in which needed to calculate avarages. Therefore I have had such idea to create universal rule to calculate consolidated avarages.