There was a need for an automated reporting methodology with a standardized view of comparing actuals and forecast within our organization, I built a process and several reports within our existing Labor Use Case for end users to compare actuals and forecast.
Historically there was manual effort for end users to compare the two but there was not an agreed upon methodology for determining accuracy. Myself and with help from the TBMO team, we worked with our workforce team and the appropriate groups to create an automated version in Apptio, taking in new data and implementing new reporting to be used for this process.
A second requirement was a need to be able to view historic snapshots of previous forecast reporting using the time selector tool. Learning and understanding the way the function GetTimeOffset works, allowed for this functionality to display forecast numbers while going backwards in time (Even though the actuals number may exist).
Please see attached for more details!
#ApptioforAll#ACE