Category: Code
-
Drive a rowset with a dynamic MDX statement
The introduction of Active Forms with TM1 v9.5 was a big step forward in the TM1 world. It allowed for the first time TM1 users to build reports with dynamic rows without having to write a single lines of VBA.
-
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.
-
Update the Pulse Application Server JVM maximum memory
The Java application server (pulseas.exe) which runs in the background has a default memory of 1024 MB.
-
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.