Simple Transaction Log Analysis: A GSheet Application Using the TM1 Rest API

I've always been intrigued by the possibilities the TM1 Rest API offers. While I am fully aware that existing solutions already query the transaction log files, I felt a personal call to navigate this challenge independently, driven by curiosity and the desire to expand my own understanding. So, I embarked on a project to employ the TM1 Rest API's capabilities and construct my own GSheet application. My ambition was not just to recreate what has been done, but to explore how I might further learn and potentially make this task into something perhaps more approachable and user-friendly.

I attempted to make this application simple. Users are given the ability to select a specific cube, identify an individual user, specify a date range, and choose an element from each of the cube's dimensions. This multifaceted filter ensures detailed and precise retrieval of transaction logs, custom-tailored to the user's analysis.

Let's consider this scenario. Suppose we're interested in understanding what modifications Tom has made in the Expense Forecast cube for Department 532 since July 10th. Using the GSheet application, users simply select the following:

1. Cube: Expense Forecast
2. User: Tom
3. Date Range: Starting July 10th, onwards
4. Dimension Element: Department 532

The application then retrieves and presents the corresponding data.

Observe how the GSheet application dynamically incorporates filters, further enhancing its functionality and user experience.

When the user opts for a different cube, the application purges prior results and updates to reflect the dimensions of the newly selected cube. Take, for instance, the selection of the Asset Forecast cube. The application refreshes the Dimension dropdown lists using the TM1 Rest API.

The application offers a way for users to pull custom transaction logs. It's equipped with basic yet helpful features like dynamic filters and auto-refreshing dropdown lists, thanks to the TM1 Rest API. Thank you for reading!