Feeder apparently not firing

Post Reply
iansdigby
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

Post by iansdigby »

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.
"the earth is but one country, and mankind its citizens" - Baha'u'llah
User avatar
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

Post by qml »

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.
Kamil Arendt
iansdigby
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

Post by iansdigby »

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
"the earth is but one country, and mankind its citizens" - Baha'u'llah
Post Reply