Page 1 of 1
Data Refresh issue in a cube which is rule driven !
Posted: Wed Sep 18, 2013 6:11 am
by 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.
Re: Data Refresh issue in a cube which is rule driven !
Posted: Wed Sep 18, 2013 6:18 am
by 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
Re: Data Refresh issue in a cube which is rule driven !
Posted: Wed Sep 18, 2013 6:28 am
by 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.
Re: Data Refresh issue in a cube which is rule driven !
Posted: Wed Sep 18, 2013 7:51 am
by declanr
ram123 wrote: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.
Re: Data Refresh issue in a cube which is rule driven !
Posted: Wed Sep 18, 2013 9:34 pm
by 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.
Re: Data Refresh issue in a cube which is rule driven !
Posted: Wed Sep 18, 2013 11:41 pm
by EvgenyT
Think Steve is refering to ForceReevaluationOfFeedersForFedCellsOnDataChange in .cfg file
Re: Data Refresh issue in a cube which is rule driven !
Posted: Tue Oct 08, 2013 9:09 am
by 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