Category: Canvas

  • Query an external database from Canvas

    Query an external database from Canvas

    With Canvas you can display data coming from your TM1 server and also from an external database. An example can be found in the samples:

  • Change the default colors of a chart

    Change the default colors of a chart

    There are 3 different ways to update charts colors in Canvas:

  • Debug a Canvas page (Controllers and Debugger)

    Debug a Canvas page (Controllers and Debugger)

    Each browser has each of its own debugging tools to help you troubleshoot your web application. And each tool gives you different views and helpful information about your HTML page. On this article, we will be using Chrome as the browser and how we can debug by enabling breakpoints.

  • Create a table from a MDX statements

    Create a table from a MDX statements

    MDX is a powerful query language similar in structure of standard SQL. Where it differs is it ability to deal with multidimensional data as opposed to the flat structure of a table in a relational database.

  • Manage multiple screen sizes with matchMedia

    Manage multiple screen sizes with matchMedia

    Canvas includes the matchMedia library. This Angular library helps you to check which screen size is your page displaying and returns true if the current screen width matches what you need or false if not.

  • Upload files and images

    Upload files and images

    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.

  • Hide the context buttons

    Hide the context buttons

    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.

  • Different types of DBR

    Different types of DBR

    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. 

  • Drillthrough in Canvas

    Drillthrough in Canvas

    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…

  • Include HTML contents inside your Canvas page

    Include HTML contents inside your Canvas page

    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.