TM1 Forum

Hi together,

I've a problem with feeding cells and need help to find the correct feeder. Example:
My Cube has 2 Dimensions, Measures und WS_Time.
The Time Dimension (WS_Time) has 3 n-elements:

1. 20200100
2. 20200200
3. Sum 2020

and the rule is like:

['measure x'] = IF( SUBST( DIMNM( 'WS_Zeit', DIMIX( 'WS_Zeit', !WS_Zeit ) ), 7, 2 ) @= '00',
DB('Cube',!Measures,'Sum ' |SUBST( DIMNM( 'WS_Zeit', DIMIX( 'WS_Zeit', !WS_Zeit ) ), 1, 4 ) ),
continue;

How can I feed this rule properly?
Many thanks!

Hello,

- Why do you duplicate the same (yearly) value in the months ?
- you can remove dimnm, dimix. Rules will just take the element principal name by default.

Hi,

the value there can be a general input parameter and then should be passed to the other elements. I know, there can be other possibilities, but this way is given for me.

Thanks for the advice with dimnm & dimix.

For the feeder, you have a couple of options.

If the cube is really 2D and small, then don’t bother about feeders (and leave out the skipcheck statement near the top).

Or if you want feeders, feed to 12 elements, comma-separated areas on the right hand side of the feeder.

Or, add a consolidated element with 12 children for the months (the ones you need to feed). Then feed the consolidation to implicitly feed its 12 children.

Hi Wim,

the Cube isn't really just 2D, that was just for the example. So I really have to use feeders.

Yes, your second suggestion ist the way I wanted to prevent in some cases
I really like your third point, because I dindn't know that by feeding a consolidation the children automatically gets the feeder from their parent.
So I guess it is also possible over a hierarchy with more levels? IF I feed C1 here, do all N elements (N1C2, N1C2, N1C3) get the feeder?

-C1
--C2
--N1C2
--N2C2
---C3
---N1C3


Thanks a lot!

True. But watch out with feeding like that, since the number of fed cells can grow quickly into big numers (if you apply the technique to several dimensions for example).