About me: This is the third management reporting solution that I have exposure to, including my time as a DBA for Hyperion Enterprise, and a power-user with SAP BPC. I have over 20 years of Accounting & Financial Analysis experience primarily in the Insurance Industry, and I also have a few years in systems & support. In my current role, I am NOT in a support or administrator position with TM1, but I intend to become a power-user if humanly possible (I now have 8 months of TM1 exposure/experience).
My Situation: I am currently responsible for the monthly production of the financial statements for our entire organization, which include a Balance Sheet and Income Statement for each company and for various consolidation reports. We currently have 3 different balance sheets, and 5 different income statements due to the complexity of our month-end reporting requirements (and those are combined with a number of different legal entity subset lists for report production). When the dust settles, and after approximately 30 minutes of my life disappearing, I have 57 reports and am done - until they decide to change actuals/budget/forecast and I have to run them all over again!
My Question: In my past experience with management reporting tools, there were ways to automate, or at least streamline, the reporting cycle. With Hyperion Enterprise, for example, they had something called Auto-Pilot which allowed you to string together various tasks (data clears, data loads, report production, etc.) and schedule them to run when needed (this was at a previous employer). With SAP BPC we had a script that we updated monthly (simply changing the reporting period) that allowed us to run these 57 reports in ~5 minutes.
Does anyone have any tips/tricks/suggestions as to how to make this process more efficient?
You will have my eternal gratitude if you have any suggestions that will help!
