Category: Canvas
-
Create SUBNMs that are dependent on each other
We’re starting a series of articles about Excel-like functions in Canvas. These articles will show you that if you have ever authored a TM1 reporting or planning application in Excel, you will quickly and easily be able to build these assets in Canvas.
-
What is the TM1 REST API?
The TM1 REST API is a new way of accessing data and everything else in TM1. Rather than being a proprietary API like old TM1 interfaces it is based on web standards making it accessible to a wide range of developers.
-
Concatenate a selection, i.e Month and Month YTD
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…
-
Enabling the TM1 REST API
The TM1 REST API is not enabled by default, you need to update your tm1s.cfg on your TM1 server with the following parameter:
-
Retrieving Information from the REST API (The GET Request)
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.
-
A journey through the TM1 REST API
The TM1 REST API is a way of accessing data and everything else in TM1.
-
TM1 Web vs Canvas – Timesheet application
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:
-
Is Canvas the best reporting tool for TM1?
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.
-
Using $expand and $select with the TM1 REST API
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.
-
Sophisticated planning application with Canvas
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.