Aside from the reading and writing back numbers and strings into TM1, Canvas further extends TM1 functionality by allowing you to save URL paths that you can then use to display images for example, or embed link and control access to these links – the TM1 way.

In Canvas, when you click on a cell which contains a tm1-ui-dbr, the context button will appear. Once you click on this button you’ll see a dropdown list with the following options.

Similar to TM1 and Excel, Canvas has adopted a cell based approach to application design.  This means each cell in Canvas has its own DBR formula to retrieve and to update TM1. 

Since TM1 10.2.2 FP6, the drill through has been added to the TM1 REST API. You don’t need to do anything on the Canvas side to enable the drill. If the drill is set up in TM1, it will appear as an option in the context button. An example of drill through is available in…

When you have lots of HTML components, your HTML page can easily contain hundreds of lines of codes. The more HTML components you add in your HTML page, the harder it will be to find information or to understand how it has been built.

With Canvas you can customize the chart behavior, for example you can trigger an action when clicking on a bar chart.An example has been setup in the Visualisations sample page showcasing how you can modify the options, and, for this example, be able to grab the data attached to the bar element that was clicked…

The objective is to create the following table, one column with the departments and the second will be Actual values:

The objective is to create a table with rows and columns driven by a subset. By having your table driven by subsets, you will  be able to manage your report from TM1, any changes made on the subsets in TM1 will be reflected automatically into the Canvas report.

ng-repeat is an Angular JS directives, it loop over a template for each item in a collection. For more general information about ng-repeat, you can check the Angular Help section.

The objective is to create and then to show in your Canvas a list of elements from TM1 that you can use for your reports. Below is a simple table that you will be able to create after going through this tutorial: