Planning Analytics

 View Only

  • 1.  Overfeeding Feeders?

    Posted Tue June 14, 2022 03:03 AM
    Hi All,

    I am feeding Forecast Summary cube from Forecast Detail cube. looking at my feeders, I just worried that I might overfeeding.
    I have 12 products which mapped to 5 major products. Is it correct to do this way or any better way to link between these 2 cubes?

    Am I overfeeding with this statement? Please advise. 

    ['channel':'Franchise', 'product':'PA - P5'] => DB('Forecast Summary FY2022', 'AGENCY', !entity, !month, 'PA', !year, !version, !currency, !input);
    ['channel':'Franchise', 'product':'PA - P6'] => DB('Forecast Summary FY2022', 'AGENCY', !entity, !month, 'PA', !year, !version, !currency, !input);
    ['channel':'Franchise', 'product':'MISC - P7'] => DB('Forecast Summary FY2022', 'AGENCY', !entity, !month, 'MISC', !year, !version, !currency, !input);
    ['channel':'Franchise', 'product':'MISC - P8'] => DB('Forecast Summary FY2022', 'AGENCY', !entity, !month, 'MISC', !year, !version, !currency, !input);
    ['channel':'Franchise', 'product':'MISC - P9'] => DB('Forecast Summary FY2022', 'AGENCY', !entity, !month, 'MISC', !year, !version, !currency, !input);
    ['channel':'Franchise', 'product':'MISC - P10'] => DB('Forecast Summary FY2022', 'AGENCY', !entity, !month, 'MISC', !year, !version, !currency, !input);
    ['channel':'Franchise', 'product':'MISC - P11'] => DB('Forecast Summary FY2022', 'AGENCY', !entity, !month, 'MISC', !year, !version, !currency, !input);
    ['channel':'Franchise', 'product':'MISC - P12'] => DB('Forecast Summary FY2022', 'AGENCY', !entity, !month, 'MISC', !year, !version, !currency, !input);

    Thank you in advance

    regards,

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

    #PlanningAnalyticswithWatson


  • 2.  RE: Overfeeding Feeders?

    Posted Tue June 14, 2022 10:04 PM
    Edited by System Fri January 20, 2023 04:50 PM

    Hi ida,

    A feeder question is generally hard to answer, and your questions are no exception. Developers are afraid of overfeeding because it can lead to a performance issue in a cube. When the issue happens, the performance gets worse when we have more data in the cube. Therefore, a performance testing must be done with the realistic amount of data to prevent an issue in the future.

    If I have to analyze a feeder issue, I will want to see the rule, feeder, cubes, dimensions of the cubes, and the elements in the dimensions to properly evaluate the feeder issue. Based on the feeder statements you provided, I want to focus on the elements on the right side of the equal sign. If 'AGENCY', 'PA', and 'MISC" are consolidated elements, you potentially overfeed to the children of those elements.

    The way to fix an overfeeding issue is to write a feeder statement that is more specific (feeding a leaf element instead of a consolidated element). However, this approach is not always possible. You may need to change the cube design to make the feeders more efficient. An alternative approach is to use a TI process to transfer data between cubes.

     

    Thanks,

    Kong



    ------------------------------
    Kong Intrasinghathong
    Master Consultant
    QueBIT Consulting

    Analyze. Plan. Achieve.
    https://quebit.com
    ------------------------------

    Original Message