Analyzing how a financial system is used provides several benefits, and IBM Planning Analytics (TM1) systems are no different.
Why it is important even for TM1
Understanding how the user base interacts with your TM1 model offers several benefits: increased user satisfaction by addressing pain points, efficient problem resolution aligned with specific challenges, optimized user training materials, data-driven decision-making for system updates and licensing, and user-centric innovation driving continuous improvement.
How to Analyse it
By extracting Pulse data from its database and integrating it into a TM1 cube, then leveraging Slice, MDX, and Excel, you can access, retrieve, report, and analyze your TM1 usage data in just a few minutes.
Step 1: Loading the data into TM1
Run the TI process so all usage data by user is updated in the Pulse Session cube from the Pulse database:
Step 2: Export the view as an MDX Form
Open the Pulse Session cube and export the default view to Excel as an MDX form:
Step 3: Break down the MDX query
Break down the query into 3 lines due to Excel's 255 character limit per formula — use the concatenate function:
Step 4: Some formatting
Make adjustments to the report format and include relevant information such as Unique Sessions by period and TM1 usage by UI:
You can do anything you want with your Pulse TM1 usage data — including creating measures on the fly with simple TM1 Rules like Average Session Time. Unlock the power of your Pulse data in TM1!