TM1 has been so successful over the years, not just thanks to its powerful calculation engine but also thanks to its very mature Excel add-in, Perspectives. With Perspectives, you can slice your data from a cube into Excel and then you have the freedom to customize your report by adding formulas or conditional formatting. Perspective…

The TM1 REST API is not enabled by default, you need to update your tm1s.cfg on your TM1 server with the following parameter:

It is very simple to test out the functionality of the REST API using your browser. In the previous article I discussed how you both enable and connect to the REST API. Here I am are going to describe how you query the REST API to retrieve information about your TM1 model.

The TM1 REST API is a way of accessing data and everything else in TM1. Since its first introduction with TM1 10.2, a number of fix packs have been released with additional improvements and extensions. All new products released by IBM such as CAFE (PAX) and Planning Analytics Workspace (PAW) are using it. It is the THE…

Here’s an example of how your TM1 application would like if you replaced TM1 Web with Canvas. For this example the TM1 Web and Canvas user interface have been built on top of the same TM1 cubes:

TM1 has by far the most powerful calculation engine on the market, but it is also well known that it is missing a modern user interface. Lots of companies using TM1 for planning and reporting also use an extra Business Intelligence tool for management reporting.

In the previous article we went through some simple GET requests to retrieve a list of cubes and a single cube. We are now going to expand on those examples by using two OData query options: $expand and $select. 

Building reports in Excel is a great way to build TM1 applications but you can easily reach the limits of Excel. Canvas will help you to extend the reach of your TM1 applications as you will now be able to easily build a modern and intuitive web front-end for your planning and reporting TM1 applications.

One of the best features of TM1 is its ability to drill through a third-party database (e.g. Oracle Financials, SQL and MS Dynamics) from TM1 cubes, TM1 web sheets or MS Excel workbooks. With TM1, you do not to need to know SQL to access data from these databases. From TM1 you can simply on a cell…

One of the main reason why TM1 is so successful is its Excel interface. If you’re familiar with Excel, you will quickly be able to build advanced TM1 reports. Over the years many great TM1 applications have been implemented using Excel. Although Excel is great to build TM1 applications, it has its own limitations…