IBM Apptio

Apptio

A place for Apptio product users to learn, connect, share and grow together.


#Aspera
#Apptio
#Automation
#FinOps
#Apptio
#ITAutomation
 View Only
  • 1.  Creating a Forecast

    Posted 07/17/18 01:58 PM

    Newbie here ...

     

    I've been playing around with creating forecasts, but haven't yet seen the functionality I want ...

     

    I want to create a new forecast that will be updated by cost center owners.

     

    If we're in July, reviewing June actuals and forecasting for the balance of the year, the forecast should have:

    • Actuals through June
    • Prior month's forecast for July - Dec

     

    It looks like when you create a forecast, you can start with only one thing ... actuals, or another forecast. Not a combination of the two.

     

    Is there no way to do what I want without going outside the tool?





    #ApptioPlanning(ITP/ITFMF)


  • 2.  Re: Creating a Forecast

    Posted 07/24/18 04:09 PM

    We were able to show the actuals on a separate line only because our source is laid out that way.


    #ApptioPlanning(ITP/ITFMF)


  • 3.  Re: Creating a Forecast

    Posted 07/31/18 06:08 AM

    Are you saying that you created your forecast, baselined off the previous forecast? If so, I would expect that your June forecast would have contained Actuals from Jan-May and you make changes for the downhill months (Jun-Dec). When you create your July forecast, baselined off June, you should have Actuals from Jan-Jun and Jul-Dec should contain the changes you made in the June forecast for those months. 

     

    Is that not the case? 

     

    I will test this out to make sure it is not a bug but your forecast changes should carry forward month over month, assuming you baseline them that way.


    #ApptioPlanning(ITP/ITFMF)


  • 4.  Re: Creating a Forecast

    Posted 07/31/18 12:54 PM

    What Bill describes above is what we see when we go through this process each month.  You do have to watch your sequence of events though.  Make sure your new set of actuals are loaded before you create the new forecast using the prior month's forecast as the baseline.  If you don't, it will leave a hole in your forecast for the missing month of actuals and loading actuals after the fact won't fill it.  


    #ApptioPlanning(ITP/ITFMF)


  • 5.  Re: Creating a Forecast

    Posted 07/31/18 01:10 PM

    Sounds promising ... haven't had a chance to try it out yet. I had created a forecast from actuals, but have not yet created a forecast from a forecast. What you describe makes sense and is the behavior I'm looking for.


    #ApptioPlanning(ITP/ITFMF)


  • 6.  Re: Creating a Forecast

    Posted 07/31/18 01:42 PM

    There are a few other things to be aware of when you start combining actuals and forecast.  They make sense when you think about it but being aware of them ahead of time can help head off some user questions:

     

    • Actuals create detailed rows in the expense view so the Other tab in expenses becomes a combination of separate rows with the actuals and separate rows with the forecast.  
    • For example, if your forecast now has actuals through June you'll see rows that look like this for 2018

     

     JANFEBMARAPRMAYJUNJULAUGSEPOCTNOVDEC
    Forecast Rows------100100100100100100
    Actuals Rows756590808590------

     

    • When you create your forecast, take time to think about the level at which you really need your actuals grouped by.   The more grouping criteria you add, the more actuals rows it's going to generate.   They can grow faster than Tribbles.  
    • The view of Actuals vs. Forecast in the Column Chart on the Summary screen throws people at first because for actuals months, they're equal.  The previously forecasted amounts for those prior months still lives in the forecasts for those months.  

     

    • Your group by selection on the Summary Screen will affect whether you see all of your actuals in this view or just a subset of them.  If you're grouping by a dimension that is in your forecast, but not in your actuals, then there wouldn't be anything in Jan-June above.  Highly recommended that you test different views when you move into actuals so that you fully understand the behavior and can explain it.  

    #ApptioPlanning(ITP/ITFMF)


  • 7.  Re: Creating a Forecast

    Posted 08/01/18 01:19 PM

    Good stuff George! Good stuff!


    #ApptioPlanning(ITP/ITFMF)


  • 8.  RE: Re: Creating a Forecast

    Posted 02/15/21 09:53 AM
    Hello George.  I saw your note and wanted to ask if you have encountered this need

    - we want to be able to see the previous years actuals as we move forward through 2021.
    - i created a 2 yr forecast last month that contained 12 months of actuals for 2020, and 12 months of forecast for Jan - Dec 2021.  
    - there was a special selection at the bottom of the Create Plan, ...Forecast start period that allowed the forecast to start on "January (Year 2)".

    we now have January actuals, and I want to create a forecast that has Jan - Dec 2020, plus Jan 2021 actuals, and then add Feb - Dec 2021 forecast.

    Trouble is, there is no special start month called "February (Year 2)" to start the forecast.  

    Seems very limiting.  I can't believe that we can do January into the new year, but not any of the other months of 2021.

    Thoughts?  Keith