Posting Transaction Log Data as Comments in IBM Planning Analytics with GSheets and TM1 REST API
Navigating the complexities of Transaction Logs in IBM Planning Analytics can often be a daunting task. The traditional use of the TM1 Architect interface, while reliable, presents challenges, especially when it comes to efficiently filtering and retrieving specific data entries. This shared struggle motivated me to develop a more streamlined and accessible approach.
The Limitations of Traditional Access
As you're likely aware, accessing detailed Transaction Logs through TM1 Architect can be time-intensive and restrictive. The interface, while comprehensive, does not always lend itself well to quick data extraction or analysis, particularly when dealing with large datasets.
Building on a Proven Solution
To build upon these capabilities, I enhanced a Google Sheets application that interfaces with the TM1 REST API using Google Apps Script, as originally introduced in my LinkedIn article "Simple Transaction Log Analysis: A GSheet Application Using the TM1 Rest API". This refined application expands on the original by allowing us to query the Transaction Log for specific date ranges and cubes directly from a familiar and flexible platform. Initially, this tool was available only to a select group of privileged users within our company. Recognizing the broader potential, I was driven to ensure this valuable data was easily accessible and provided to all IBM Planning Analytics users.
The application requires selecting a Cube with Start and End Dates.
Enhancing Interactivity with Annotations
Once the Transaction Log data is retrieved, it’s uploaded back to the Annotations cube in IBM Planning Analytics via the TM1 REST API. This integration is particularly beneficial as it allows end-users to interact directly with the data. By simply right-clicking a cell marked with a blue flag, users can view all Transaction Log data related to that cell in a chronological format, enhancing transparency and traceability.
领英推荐
Conclusion: Streamlining Transaction Log Access
This initiative is focused on simplifying the process of data retrieval from Transaction Logs. By integrating Google Sheets with the TM1 REST API, I have developed a tool that significantly reduces the time required to access and analyze Transaction Log data. This approach not only enhances the usability of IBM Planning Analytics but also introduces new efficiencies in how data is handled.
I plan to continue pushing the boundaries of what’s possible with TM1 Rest API. Your feedback and insights will be invaluable. I am looking forward to your thoughts and collaborations!
Best regards,
Jim
TeamOne Google Integration for IBM Planning Analytics | Succeedium Planning Analytics Cloud Extension (SPACE)
10 个月Just keep in mind that running queries on transaction logs in a production environment can significantly impact TM1's performance, as it may need to scan through multiple gigabyte-sized files. Additionally, users must have ADMIN permissions to access the transaction logs through TM1 REST API. You can use additional filters to limit the REST API results: https://succeedium.com/teamone/doc/logs.html#transaction-log Or if you want to enable your regular users to access their own transaction logs without impacting TM1 performance, you can use SPACE: https://www.youtube.com/watch?v=0_f3224-osc
Managing Director at Intito | Expert in Finance & Sustainability Planning | TM1 Fanboy | Advocate for a Sustainable Future
10 个月That is a very interesting way of using the transaction log data. It gives you a lot of transparency for the end user in regards to the history of a certain cell. Over time it could slow the system down, I would guess. Did you experience anything performance wise so far? Anyway thanks for sharing with the community. :-) Love your stuff!
TM1 Academy | Business Solutions based on IBM Planning Analytics | Support in TM1-Projects
10 个月Thanks for sharing!