The lightweight gateway bridging TM1 & Business Intelligence Tools

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.

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.

Real Time

Fast

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.

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.