Data Refresh issue in a cube which is rule driven !

[ram123]

Hi All,

We are facing a problem in Data Refresh in the cube which is rule driven. The feeders are written appropriately and everything is working fine. But there is some issue which pops up intermittently and data is not getting reflected and when we cut and paste the respective feeders and save the rules editor, the data is getting refreshed.
The version we are using is 10.1

Help us in this issue.

[EvgenyT]

I suggest you refer to "Request for assistance guidelines (PLEASE READ)" first. There is no WAY to determine the cause of the problem with what you have provided us.


ET

[ram123]

Thanks for the reply.

Am facing this issue for the first time. There is a source cube X where in the users will enter and then entered values flow to the target cube Y. So the moment data is entered in X the values are reflecting in Y and the cell shows fed.
But some times the data doesn't flow and after trying so many things , we just have cut and pasted the feeders again. And this worked .
This issue turns up intermittently and we need a permanent fix for this.

[declanr]

Thanks for the reply.

Am facing this issue for the first time. There is a source cube X where in the users will enter and then entered values flow to the target cube Y. So the moment data is entered in X the values are reflecting in Y and the cell shows fed.
But some times the data doesn't flow and after trying so many things , we just have cut and pasted the feeders again. And this worked .
This issue turns up intermittently and we need a permanent fix for this.

To quote EvgenyT: "We need more info"
e.g. Please provide the actual rules.

However based on what you have stated, I would take a guess at saying that the feeders are conditional/variable/whatever the hell you want to call them.

Next time it happens, instead of repasting the feeders and saving the rule. Try and use the CubeProcessFeeders() TI Function out.

[Steve Rowe]

Conditional feeders are something to watch out for, in general the condition that is applied is the one that exists when the rule is compiled. They are not dynamic so if the value you are testing against changes the feeders won't then start firing to a new location.

You can make conditional feeders dynamic, there is a cfg option for it which you can read up on (not sure what it is called), in general though its not used due the performance hit that occurs when the feeders refire.

[EvgenyT]

Think Steve is refering to ForceReevaluationOfFeedersForFedCellsOnDataChange in .cfg file

[ram123]

Hi All,

Thanks for the reply.

1. Tried Cubeprocessfeeders() but dint work out.
2.ForceReevaluationOfFeedersForFedCellsOnDataChange dint work and performance is lost.

Detailed Description of the Issue :
I have
source cube (S) which has measure dimension M(contains trade , volume , rate) and region dimension
Target cube ( T) which has measure dimension M(contains trade , volume , rate) , region dimension , trade dimension

My rule is like this : T(volume)=N:( if(DB(S,!Region,!Trade,'trade')@=!Trade,DB(S,!Region,!Trade,'volume',continue);
Feeders in the source cube : volume => DB(T,!Region,DB(S,!Region,!Trade,'trade'),'Volume');

So sometimes the data is not flowing to the target cube and the reason is few cells are "not fed" . And when we re paste the particular feeder the data gets flowed and cell is fed.

Please respond if you have any suggestions