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
feeder fire sequence
-
- Posts: 122
- Joined: Thu Jan 31, 2013 1:03 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2007
-
- 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
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.
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
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