TM1 Forum

Hi ,
I have read the IBM proven practices on feeders on recommendation of a forum member and half way through and they explain the basics clearly .

I have an issue now with my feeder not being fed and disappears on zero suppression .

I have a measure which gives the turn around time and other measure which count the cases , so I will need a variable which will calculate the total turnaround time taken for that month and divide by total number of cases for that month .

so simple rule :

SkipCheck;
['Average TurnAround Time' ] = DB('Dispute Data', !Customers SoldTo Only, !Currencies, !Months, !Dispute Case ID, !Dispute Case Status, !Dispute Person Responsible, !Dispute Processor, !Dispute Reason, !Dispute Root Cause Code, 'TurnAround Time') \ DB('Di
spute Data', !Customers SoldTo Only, !Currencies, !Months, !Dispute Case ID, !Dispute Case Status, !Dispute Person Responsible, !Dispute Processor, !Dispute Reason, !Dispute Root Cause Code, 'Cases with TurnAround');


And I have a feeder :

['TurnAround Time'] =>['Average TurnAround Time' ] ;

I just used one element in the division to feed my Average TurnAroundTime.


Now I have attached the results saying not fed , but when I click on check feeders at lowest level

Its showing up

the calculation taking the value of DB('Dispute', All dimension , 'AverageTurnArounTime');
It should take the turnaroundtime/caseswith turnaround right?

Attached both the check feeder and cube data screenshot .


I also tried to change my feeder to below as well :

['TurnAround Time'] =>DB('Dispute Data', !Customers SoldTo Only, !Currencies, !Months, !Dispute Case ID, !Dispute Case Status, !Dispute Person Responsible, !Dispute Processor, !Dispute Reason, !Dispute Root Cause Code, 'Average TurnAround Time');

But same results not fed.

Appreciating any help !!


Thanks,

hi,

i would say the feeder "['TurnAround Time'] =>['Average TurnAround Time' ] ;" looks good.
What do you see, wenn you "Trace Feeder" from the elment "TurnAround Time".

What happens when you restart the database?

Another idea:

"Average TurnAround Time" as a consolidated element with childs "TurnAround Time" and "Cases with TurnAround". then you do not need the feeders because the hierarchy feeders itself.

Just came across very good article on Feeders, please go through it:
https://code.cubewise.com/blog/how-to-f ... and-fix-it Thanks