One of the oldest challenges. How are people doing it, without access to MCP? I'm thinking of comparing say 50 cubes, a specified MDX would be fine where the idea would be to issue the same MDX to both environments (for each cube sequentially) and somehow comparing the results ideally without using PAfE.

------------------------------
John O'Leary
------------------------------

https://github.com/ykud/tm1cmp

------------------------------
Cheers,
Yuri
------------------------------

Hi John! 

I've done this using Reportworq where I created a report that pulled the totals from all cubes I needed to validate between had a validation check against them and if they all tied out no email was sent but if their was a variance then the report and email was sent highlighting the variance. I've also done this with a TI script that compared cubes within the same service and would do the validation checks. If cubes are among many services could do this with a python script as well using TM1py. 

------------------------------
Karen Hewitt
Head of Customer Success
Reportworq
------------------------------

If you're looking for a non-technical solution, there are a couple of options.

With TeamOne, the tm1datacompare automation task is designed specifically for this. You can compare cube views, specified MDX, or selected elements across environments, then review and filter the comparison results directly in Google Sheets.

Alternatively, SPACE AI Assistant can be used to compare data directly within IBM Planning Analytics Workspace and analyze the differences using natural language:
https://succeedium.com/space/doc/ai-assistant.html

For a technical approach, TM1Py + DataComPy works well. If you're using SPACE, you can also run that Python-based comparison directly inside IBM Planning Analytics Workspace without needing to leave PAW:
https://succeedium.com/space/doc/python.html#editing-notebooks-and-scripts

And SPACE AI Assistant can write the Python script for you.

------------------------------
Vlad Didenko
Founder at Succeedium
TeamOne Google Sheets add-on for IBM Planning Analytics / TM1
https://succeedium.com/teamone/
Succeedium Planning Analytics Cloud Extension
https://succeedium.com/space/
------------------------------

Original Message:
Sent: 08/18/26 07:40 AM
From: Karen Hewitt
Subject: Smart ways to perform data comparison between environments

Hi John! 

I've done this using Reportworq where I created a report that pulled the totals from all cubes I needed to validate between had a validation check against them and if they all tied out no email was sent but if their was a variance then the report and email was sent highlighting the variance. I've also done this with a TI script that compared cubes within the same service and would do the validation checks. If cubes are among many services could do this with a python script as well using TM1py. 

------------------------------
Karen Hewitt
Head of Customer Success
Reportworq
------------------------------

Hi John, 

Why don't you just hash the .cub files and compare the hashes?  This would show if the cubes are identical.  If it is possible that the data or schema has changed in areas you are not interested in, export the data you want to check to csv and then hash the two csv files (one from each environment).

------------------------------
Craig Sawers
------------------------------

Planning analytics as a service or v12 provides ExecuteHttpRequest which can be used to make calls to multiple environments with the same MDX and then use JSONDiff

If you are not using V12 then use another @Yuri Kudryavcev tool to recreate ExecuteHttpRequest with Powershell: https://www.ykud.com/blog/pa11-executehttprequest/

------------------------------
Edward Stuart
Solutions Director
Spitfire Analytics Limited
Manchester
------------------------------