AI-Powered Chatbot for IBM TM1/Planning Analytics: Instant Insights Using TM1 REST API and ChatGPT API

#TM1RestAPI #ChatGPT #ibmplanninganalytics

I recently developed a prototype chatbot that integrates the TM1 REST API with the ChatGPT API, enabling users to ask questions about TM1 data, processes, dimensions, and performance—while receiving easy-to-understand answers.

Instead of manually sifting through logs or calculations, you can now interact conversationally with your TM1 environment to extract insights, monitor processes, and analyze data—all in real time.

Here are eight examples of the chatbot in action:

1. What are the top 3 products in the Maintenance Revenue cube for Oct, Budget, and New Customers?

Identifying top performers is a frequent request. The chatbot extracts and analyzes cube data to return the top three products based on the specified view and filters.

Screenshot of Response:

2. What data changed for the previous 10 days in the listprices cube for Jan and the Star Gazer 6 product?

The chatbot queries the TM1 Transaction Log to identify changes in the ListPrices cube, filtering for the specified product and date range. This provides streamlined access to TM1 Transaction Log data, making analysis faster and more convenient..

Screenshot of Response:

3. When did the process import_listprices execute with errors for the previous 7 days?

Monitoring process execution and errors times are essential for ensuring data accuracy and workflow efficiency. The chatbot retrieves execution details from the message log, giving you a clear picture.

Screenshot of Response:

4. Highlight any anomalies in ListPrices:Price Trend.

The chatbot can analyze ListPrices:Price Trend cube view data identifying key changes and patterns.

Screenshot of Response:

5. Tell me what was added to the Allocation dimension for the past 7 days.

The chatbot can query audit logs and highlights newly added members over the last seven days.

Screenshot of Response:

6. Explain what the import_listprices process does.

When you need to understand a TurboIntegrator (TI) process without diving into the code, the chatbot parses the process script and explains its logic in plain language.

Screenshot of Response:

7. Explain how Allocated Amount is calculated in the Allocation cube.

Cube rules can be hard to read for non technical staff. The chatbot retrieves the Rule file and provides a step-by-step explanation of how the Allocated Amount measure is calculated.

Screenshot of Response:

8. What Threads are running right now?

Performance monitoring is critical for TM1 administrators. The chatbot queries Threads and displays the active threads, showing details like ThreadID, duration, and user.

Screenshot of Response:

How It Works

1. User Query: You ask a natural-language question about TM1 cubes, logs, processes, or dimensions. ChatGPT determines which TM1 Rest API functions to use.
2. TM1 REST API Query: The chatbot uses the TM1 REST API to fetch relevant data (e.g., transaction logs, TI processes, or cube rules).
3. ChatGPT Analysis: The retrieved data is sent to the ChatGPT API, where the query is processed, and a human-readable response is generated.
4. Results Displayed: The chatbot immediately displays the response, saving hours of manual work and providing clear insights.

Why It Matters

This integration brings the power of AI to TM1/Planning Analytics:

• Business Users get simplified, answers to complex questions.
• TM1 Administrators can quickly monitor processes, threads, and data changes.
• Finance Teams benefit from automated analyses of trends and calculations.

By streamlining these workflows, the chatbot reduces manual effort, enhances decision-making, and empowers users of all skill levels to interact with TM1 more effectively.

Looking Ahead

This chatbot prototype highlights what’s possible when combining TM1 REST API and AI tools like ChatGPT. There’s significant room for expansion:

• Visual Results: Adding charts alongside textual responses for trend analysis.
• Scheduled Insights: Automating daily or weekly TM1 analysis summaries.
• Deeper Integrations: Supporting drill-through and scenario planning queries.

If you're exploring AI-powered solutions for your TM1/Planning Analytics environment, I'd be happy to connect and share ideas. Let's collaborate and learn from each other's experiences!