IBM Apptio

IBM Apptio

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

 View Only

  • 1.  Extension of Pre calculate Period

    Posted Mon October 31, 2022 01:51 AM
    Hello All,

    Does anyone have any idea how the Apptio system will behave if we extend the precalculated period by 2 or 3 years ? 

    For example, currently our precalculated period is from Jan FY2022 to Dec FY2022. Our use case is such that we  mainly need to do reporting for for the 4-5 years period .Lets suppose if we change the precalculated period from  Jan FY2021 to Dec FY2025. How it impact the apptio system ? Whether it increase the calculation time, make the system slow, decrease the report loading time etc. ? Does anyone have any Idea ?


    Thank you !!



    #CostingStandard(CT-Foundation)


  • 2.  RE: Extension of Pre calculate Period

    Posted Mon October 31, 2022 08:57 AM

    Yes, it will increase calculation times. If you have multi-year reports, those will also take longer. 
    I believe Apptio performance experts recommend keeping about 2 years' worth of data online. @Sheridan Coulter knows a lot more than me on this topic.

     
    Every year, we extract the most significant data and store it in tables that our users can access via what we call the Historical Data report. I wrote a blog post on this topic a few weeks ago (link).

    ​

    ------------------------------
    Regards, Guillermo
    ------------------------------

    Original Message


  • 3.  RE: Extension of Pre calculate Period

    Posted Mon October 31, 2022 12:46 PM
    Yes as Guillermo says it will have an impact. We had a session with Sheridan (font of all Apptio calc knowledge!) on this exact issue.

    One trick that he pointed out was that you can leave only December open in previous or future years in the report settings, which will give you you year to date values (what most people are interested in when looking back) and close off the report periods Jan-Nov which will improve calc times dramatically. 

    In future years you may not even need to keep reports open anyway unless you intend to browse to them, Apptio will still be able to calculate future year figures for example inside a report by using the relevant time filter into your model panel.

    Project extension though will always have an impact from what i've seen as the underlying data does still need to calculate.
    Original Message


  • 4.  RE: Extension of Pre calculate Period

    Posted Tue November 01, 2022 10:34 AM
    Thank you. Just a additional question, When you close the time period Jan to Nov, whether you are manipulating the Dec month data? Means are you pulling the YTD value from Jan to Nov in Dec month in table ?

    Original Message


  • 5.  RE: Extension of Pre calculate Period

    Posted Wed November 02, 2022 06:14 AM
    Yes it will still calc year to date :)
    Original Message


  • 6.  RE: Extension of Pre calculate Period

    Posted Tue November 01, 2022 10:39 AM
    Thank you Guillermo  !! What I understand is first you create an extract of data including required metric for the previous years with the help of report and then upload the data in the table and then do the reporting on the table. I guess the report will also load quite fast since you are doing reporting on the table where you already have metrics vale.

    Really helpful !!

    Thank you !!


    Original Message


  • 7.  RE: Extension of Pre calculate Period

    Posted Wed November 02, 2022 05:57 AM
    Exactly, but it has its limits: we don't download every allocation path, just the ones we find more in demand.

    ------------------------------
    Regards, Guillermo
    ------------------------------

    Original Message


  • 8.  RE: Extension of Pre calculate Period

    Posted Thu November 03, 2022 01:45 AM
    The way the Apptio calculation engine works, you will definitely see an increase in build times. Reports typically make up the bulk of that time and more periods open = more time as the engine precalculates all active reports.
    However you could consider spinning up another project to do this work. You could implement reports such as @Guillermo Cuadrado has recommended and datalink these across to the new project. You could ask Apptio to do a copy of the existing project, turn off all but the reports you are interested in, and do your analysis this way. Being a separate project does mean you can control check ins and calculations, but does obviously mean additional maintenance, especially you need to keep pushing data over into it.
    The key is to make sure you turn on only reports you need in this new project​. Datalink as much as you can into it to reduce duplication of effort.
    Original Message


Related Content