Planning Analytics, pick list cube and feeders

Post Reply
sn@rav.no
Posts: 2
Joined: Tue Nov 06, 2018 3:47 pm
OLAP Product: IBM Planning Analytics
Version: 2.0
Excel Version: MS Office 365

Planning Analytics, pick list cube and feeders

Post by sn@rav.no » Wed Nov 07, 2018 7:31 am

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

User avatar
Steve Rowe
Site Admin
Posts: 1818
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: Planning Analytics, pick list cube and feeders

Post by Steve Rowe » Wed Nov 07, 2018 11:47 am

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.

sn@rav.no
Posts: 2
Joined: Tue Nov 06, 2018 3:47 pm
OLAP Product: IBM Planning Analytics
Version: 2.0
Excel Version: MS Office 365

Re: Planning Analytics, pick list cube and feeders

Post by sn@rav.no » Thu Nov 08, 2018 8:53 am

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'?

User avatar
Steve Rowe
Site Admin
Posts: 1818
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: Planning Analytics, pick list cube and feeders

Post by Steve Rowe » Thu Nov 08, 2018 11:39 am

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

Post Reply