Planning Analytics

 View Only

  • 1.  Feeders

    Posted Wed February 16, 2022 12:06 PM
    Hi Everyone,

    Just trying to get my understanding correct on Feeders. Based on Planning Sample Cube, I am looking at plan_BudgetPlan rules.

    skipcheck;

     

    ['local','line input']=DB('plan_BudgetPlanLineItem',

    !plan_version,!plan_business_unit,!plan_department,

    !plan_chart_of_accounts,'local','All Lines',!plan_time);

     

    [plan_exchange_rates:'local', plan_source:'goal']=N:

    DB('plan_BudgetPlan',!plan_version,!plan_business_unit,!plan_department,!plan_chart_of_accounts,'actual',

    !plan_source,!plan_time) *

    DB('plan_ExchangeRate',ATTRS('plan_business_unit',!plan_business_unit,'currency'),'actual',!plan_time);

     

    ['actual']=N:if(!plan_source @= 'goal', stet, DB('plan_BudgetPlan',!plan_version,!plan_business_unit,

    !plan_department,!plan_chart_of_accounts,'local',!plan_source,!plan_time)/

    DB('plan_ExchangeRate',ATTRS('plan_business_unit',!plan_business_unit,'currency'),'actual',!plan_time));

     
    Feeders;

     ['local']=>DB('plan_BudgetPlan',!plan_version,!plan_business_unit,!plan_department,

    !plan_chart_of_accounts,'Actual',!plan_source,!plan_time);

    My Questions is:

    In my understanding feeders is just an input from user which later be used in a calculation to derived/accumulate/assign numbers. From sample above, [local] is user input which later calculate the 'actual' column for !plan_source = input. But why there is no [actual] feeders defined even though it is used to calculate [local] for !plan_source = goal?

    Thank you in advance!

    regards
    Ida



    ------------------------------
    ida lasim
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: Feeders

    Posted Wed February 16, 2022 02:33 PM
    Hi Ida,
    Feeders are used in sparse algorithm  and it's how TM1 to "turn on" rule calculated cells.
    It used to be a good collection on IBM Developers site but I can't find it right now, will try to locate it later.
    There are however some great videos provided by IBM Business Partners Cubewise and Spitfire that are explaining the feeders quite well.
    I could post a few for you here:
    https://www.youtube.com/watch?v=ZztNgIhWwXQ
    https://www.youtube.com/watch?v=TaA9iEyn5GM

    Hope this helps!
    Best Regards,

    ------------------------------
    Svetlana Pestsova
    IBM Planning Analytics Product Manager
    ------------------------------

    Original Message