Page 1 of 1

Planning Analytics, pick list cube and feeders

Posted: Wed Nov 07, 2018 7:31 am
by sn@rav.no
Hi,
I am kind of stuck and need help.
I have a cube which holds information about employees. I use pick lists for 80% of the information, where three of the elements are defined in a pick list cube and the rest are dimension subset picklists. The rules in the target cube are defined by links and virtual dimensions.

When I register a new employee with all the pick lists elements being defined, the numbers are not fed properly to the next cube.
If I then delete the content of one of the three pick list elements which is defined in the pick list cube and reenter it, all the numbers are fed properly.

Have you seen this behaviour before?

Regards,
Sven Norlund

Re: Planning Analytics, pick list cube and feeders

Posted: Wed Nov 07, 2018 11:47 am
by Steve Rowe
I can't answer your question exactly but you need to remember that a Feeder is an event that happens in the engine as opposed to a rule that defines the behaviour of a cell.

So if all the things that the feeder needs to know are not known when the event happens then the feeder will not fire (correctly).

The event is typically the feeder source cell going from empty to populated, unless you have the fire feeders on cell change set.

It sounds like you have a problem in this space.

Re: Planning Analytics, pick list cube and feeders

Posted: Thu Nov 08, 2018 8:53 am
by sn@rav.no
Thanks for you reply Steve.

The interesting thing is that the one element/cell with pick list cube is given an input, but the feed won't happen before we empty the cell and re-enter the chosen element from the pick list.

Can you please explain what you mean with 'unless you have the fire feeders on cell change set'?

Re: Planning Analytics, pick list cube and feeders

Posted: Thu Nov 08, 2018 11:39 am
by Steve Rowe
Hi,
There is a tm1 cfg ForceReevaluationOfFeedersForFedCellsOnDataChange. I don't think it applies in your situation since the initial feeder is not firing. I just mentioned it to qualify my statement that feeders fire when a cell goes from empty to populated.

Suggest you post the detail of what you are doing, i.e. rule and feeder statements and screenshots of cubes etc.

Cheers,

Steve