Planning Analytics

 View Only

Conditional Feeders / Planning Analytics

  • 1.  Conditional Feeders / Planning Analytics

    Posted Fri January 24, 2020 07:58 AM
    Here is information on conditional feeders

    What are conditional feeders?

    Conditional feeders can be used to minimize the storage impact of rule feeders. The typical situation occurs when rule values are calculated by multiplying factors, any of which may be zero. This means that the value should be fed only when all the factors are non-zero.

     

    Source - https://exploringtm1.com/conditional-feeders/

     

    MTfeeders configuration with conditional feeders

    MTFeeders is a new parameter from Planning Analytics (TM1 server v11). By turning on this new parameter in tm1s.cfg, MTQ will be then triggered when recalculating feeders:

    • CubeProcessFeeders() is triggered from a TM1 process.
    • A feeder statement is updated in the rules.
    • Construction of feeders at startup.

    MTFeeders will provide you significant improvement but you need to be aware that it does not support conditional feeders. If you are using conditional feeders where the condition clause contains a fed value, you must turn it off.

    To turn on MTFeeders during server start-up you will need to add MTFeeders.AtStartup=T.

    Source - https://code.cubewise.com/blog/optimizing-your-tm1-and-planning-analytics-server-for-performance

     

    *** It is very important when building any model that rules and feeders are carefully designed.  It is always best to reach out to a qualified BP and/or IBM Lab Services when it comes to best practices/planning analytics model design.

    Other Sources:

    1. Best Practices / Feeders - https://www.ibm.com/developerworks/data/library/cognos/financial_management/analytics/page620.html
    2. Revelwood Tips and Tricks - IBM Planning Analytics Tips & Tricks: Conditional Feeders
      Revelwood remove preview
      IBM Planning Analytics Tips & Tricks: Conditional Feeders
      Did you know IBM Planning Analytics can minimize the amount of feeder data via an approach called a "conditional feeder?" A conditional feeder is exactly what it sounds like - it only feeds when a certain condition is met.
      View this on Revelwood >
    3. https://revelwood.com/ibm-planning-analytics-tips-tricks-conditional-feeders/Cubewise tips and tricks -  Optimizing your TM1 and Planning Analytics server for Performance - Cubewise CODEOptimizing your TM1 and Planning Analytics server for Performance - Cubewise CODE


    Many thanks to Cubewise, Revelwood and other Business Partners for their contribution to Feeders tips and tricks

    I also welcome input from consultants on their recommendations when it comes to feeders.

    ------------------------------
    paul YOUNG
    ------------------------------

    #PlanningAnalyticswithWatson