feeder fire sequence

Post Reply
wang_chris
Posts: 122
Joined: Thu Jan 31, 2013 1:03 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2007

feeder fire sequence

Post by wang_chris »

I have a dimension in Cube1, which has below elements { A1, A2, A3, B, C, D, E, F, ...}.

To A1,A2,A3, they will result calculation 1 in cube2; and rest elements in the dimension of cube1 will cause calculation 2(different to calculation 1) in cube2.

Now, in the feeder, which statement should I put first to have both take effect?

[{'A1','A2','A3'}] => DB(Cube2, ...)
[ ] => DB(Cube2, ...) <--- here I use [] instead of ['B','C','D','E','F',...], since such elements are long to list one by one.


In addition, I remember in rule, the first statement will take effect, so that below statements will both work. is it correct?
[{'A1','A2','A3'}] =N: Calculation1;
[ ]=N: calculation 2;

Regards,
Chris
Wim Gielis
MVP
Posts: 3241
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: feeder fire sequence

Post by Wim Gielis »

Hello

The order of rules is important, for feeders it is not important.

Question 1:

You can this:

[{'A1','A2','A3'}] => DB(Cube2, ...)
[ ] => DB(Cube2, ...)

but remember that A1, A2, A3 (for all intersections in the cube with a non-0 value) will also feed the second area. Might be overfeeding.
You can either hardcode the long list of elements, or make them children of a consolidation and feed from there, ... and a few other possibilities.

Question 2:

Correct.
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply