Planning

Get Involved. Join the Conversation.

Topic

    Joe Steinbrenner
    Trend-Based Expense Forecasting - Global/Default...
    Topic posted May 13, 2019 by Joe SteinbrennerBronze Medal: 1,250+ Points, tagged EPBCS, Financial Planning, Planning, Smart View 
    45 Views, 3 Comments
    Title:
    Trend-Based Expense Forecasting - Global/Default Assumptions?
    Summary:
    Trend-Based Expense Forecasting - Global/Default Assumptions?
    Content:

    We are in the process of setting up Trend-based Forecasting for Expenses. 

    Is there a way to copy the same trends (i.e. Prior year Actual Average, Monthly Growth, etc.) to all Busarea/CostCenter intersections? Or maybe set up default values, where for example  "Prior Year Actual Average" will be the default value for "Travel Expenses" for any possible Busarea/CostCenter intersection. One option is to create a spreadsheet and submit via Smartview, but that spreadsheet gets pretty big when you have 500 BusAreas and 300 CostCenters...

     

     

     

     

    Image:

    Comment

     

    • Joanne Fiorito

      I have had to write a business rule to handle that.

    • Peter Nitschke

      Definitely a business rule. 

      Even something as simple as:

      FIX("USD","FY19")
      FIX(@RELATIVE("All_BusArea",0),@Relative("All_Cost_Center,0),@RELATIVE("NPAT",0)) /* Fix statement excluding the NA members */
      Assumptions(
      IF(Trend == #missing)
      Trend = Trend->"BusArea_NA"->"CostCentre_NA";
      ENDIF
      );
      ENDFIX
      ENDFIX
      

      It's scratch code, but it should be pretty good starting point - check if it already has a flag set and if not, go and grab it from the NA members. It will only run where there is data, so you shouldn't end up with flags everywhere, but you might have to deal with block creation in the outer years depending on what you're trying to do. 

      Cheers

      Pete