This is the story of how successfully I was able to reduce the calculation time and ameliorate the model performance. Please find below a detailed description of the business problem and initiative goals, as well as the steps I took to accomplish these objectives and the lessons learned from it.

Business Problem:

The need to make changes in Apptio came in when Finance Team came up with a request to close their month-end process in a day advance and ask to eliminate the model inefficiencies.

Initiative Objective:

I started exploring below different options to increase the model efficiency and reduce calculation time.

• High object granularity with low relationship granularity
• Unused tables
• Inefficient lookups and nested formulas
• Break formulas down into different transform steps

Implementation/Procedures:

I removed all unused tables from the project and updated the object identifier in the model to reduce the calculation time. I have revisited the tables which has more formulas in one step and break down into several steps.

With the successful implementation of the changes, we were able to meet the Finance team's requirement for quicker month-end close process and improved a lot in model efficiency.

 Lesson Learned:

• Prior to configuring intricate transform steps in Apptio, ensure the model performance.
• Learned how to break a complicated formula down into simpler parts. How to define the object identifier in a model without performing extensive calculation.
• It is always advisable to go back and tidy up any unused model tables.
• Consider the month-end close process when you write or construct the model. The month-end timing and user experience will be impacted by the calculation time.

 Thank you.

Link to the PPT

#ApptioOne
@Debbie Hagen
@Clifford Bird
@Mouniga Jayavelu