Page 1 of 1

Feeder apparently not firing

Posted: Mon Oct 08, 2012 8:57 am
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.

Re: Feeder apparently not firing

Posted: Mon Oct 08, 2012 9:06 am
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.

Re: Feeder apparently not firing

Posted: Mon Oct 08, 2012 10:25 am
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