Current Situation

Many Planning Analytics/TM1 users currently use Excel spreadsheets for reporting and financial analysis. However, companies worldwide are transitioning to business intelligence tools such as PowerBI, Tableau and Qlik.


Planning Analytics/TM1 users have to find ways of loading data stored in Planning Analytics/TM1 into these business intelligence tools. This is presently done inefficiently by ‘manually’ exporting data from Planning Analytics/TM1 and importing them into these tools. The process can be tedious, time-consuming and resource-intensive.

Our Solution

TMVGate is a high performance Planning Analytics/TM1 gateway which transforms both Public and Private Cube Views into real time HTTP/HTTPS data feed. It is lightweight, easy-to-implement and has a strong support team to address any queries and concerns.

Key Benefits of TMVGate

Works with TM1 Local & on Cloud

Supports all Security Modes 1 to 5

Efficiently supports large Cube Views (>500mb)

No need for ODBC/Additional Data Warehouse Layer

Real Time

  • Provides Real-Time connectivity


  • Lightweight implementation using HTTP/HTTPS protocol

Open Architecture

  • Adopt Open Architecture supported by many BI or Visualization tools.

Offline Mode

  • Supports offline mode in BI Visualization tools. Data can be refreshed as and when required.

Hear what our customers have to say

TMVGate is a quick, efficient & relatively easy solution that helped us to pull quality, structured data from Planning Analytics(powered by TM1) into Power BI. I would highly recommend it.

Jay and the team were there to help throughout the whole process and dealt with queries in a quick and professional manner, no matter how big or small the task.
- Cormac Roddy, Finance Systems Manager at Brewin Dolphin

Some of our TMVGate clients

Supports multi-format data

TMVGate lets users extract Planning Analytics/TM1 Cube View data easily via a simple HTTP request with selectable output formats such as TEXT, JSON and XML. These formats are well supported with Tableau ®, Qlik ®, Microsoft Power BI, Microsoft Power Query and Power View and other visualization tools that support Web API.

Remote users who rely on remote desktop solution now have an option to access Cube data, offline and with real time refresh, from their own desktop. Meanwhile, existing Planning Analytics/TM1 data security is preserved based on user’s credentials provided in the HTTP request.

Connect directly

Supports commonly used business intelligence tools such as:

Discover what TMVGate can do.
Contact us today to get a free trial.

Try it Free