Hello all.
I have searched the forum for an answer to this and am generally familiar with the concepts of feeder precedence etc. However, I have a rule which restricts a calculation in one specific area then applies a more general one, viz.:
Line 1: ['Gross Margin %','Cut1vsCut2']=N:STET;
Line 2: ['Gross Margin %']=['Gross Margin']\['CC100 : Sales'];
These lines are the very first in the rule. Yet when I save this rule, the cube calculates all cells, including those defined in Line1, as per Line 2.
I thought that the rule would be turned off for 'Cut1vsCut2' in Line 1.
I have tried unloading the cube, no joy. Persistent Feeders are on.
If anyone could shed a light on this it would be most kind.
Feeder apparently not firing
-
- Community Contributor
- Posts: 109
- Joined: Thu Feb 26, 2009 8:44 am
- OLAP Product: TM1
- Version: 9 + 10 + Plan An
- Excel Version: All
- Location: Isle of Wight, UK
Feeder apparently not firing
"the earth is but one country, and mankind its citizens" - Baha'u'llah
- qml
- MVP
- Posts: 1098
- Joined: Mon Feb 01, 2010 1:01 pm
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0.9 and all previous
- Excel Version: 2007 - 2016
- Location: London, UK, Europe
Re: Feeder apparently not firing
Your first line is only applied to N level, your second one to N and C levels. This means that if you look at any consolidations then your second rule will be the one at work, not your first one. You're effectively overriding consolidations with that second rule.
The title of the thread is misleading, BTW, it has nothing to do with feeders.
The title of the thread is misleading, BTW, it has nothing to do with feeders.
Kamil Arendt
-
- Community Contributor
- Posts: 109
- Joined: Thu Feb 26, 2009 8:44 am
- OLAP Product: TM1
- Version: 9 + 10 + Plan An
- Excel Version: All
- Location: Isle of Wight, UK
Re: Feeder apparently not firing
qml, many thanks for resolving the problem for me.
You are of course quite right: it has nothing to do with feeders! Muddled Monday thinking.
Thanks again, Ian
You are of course quite right: it has nothing to do with feeders! Muddled Monday thinking.
Thanks again, Ian
"the earth is but one country, and mankind its citizens" - Baha'u'llah