Cubewise

Category: Code

  • Is Canvas the best reporting tool for TM1?

    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.

  • What can you do if TM1 slows down

    What can you do if TM1 slows down

    In a previous article, I explained how Pulse can help you when Excel is hanging. Now we’re going to see how Pulse can help you when a user complains that TM1 slow down.

  • What can you do if Excel is hanging

    What can you do if Excel is hanging

    What can you do when your users are complaining that Excel or TM1 Web is hanging. How do you deal with this situation. Hopefully it does not happen often in the TM1 world but it can happen if:

  • Using $expand and $select with the TM1 REST API

    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. 

  • Documentation a necessary evil

    Documentation a necessary evil

    Documentation is a long and costly task that is often ignored for more “interesting” tasks by developers and administrators alike. Pulse for TM1 automates much of this process by doing all of the tedious tasks for you. 

  • How to troubleshoot network issues

    When using the Pulse Web client, if you have the feeling that Pulse is running slow, it is likely that you have network issues. 

  • Sophisticated planning application with Canvas

    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.

  • Drill-Through is now available in the TM1 REST API

    Drill-Through is now available in the TM1 REST API

    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…

  • How to create the license optimisation report

    How to create the license optimisation report

    Pulse has specially designed report that gives you a summary of how the system is used by different types of users. This report gives you a full picture over any time-frame of how well utilized your licenses are. Users are categorized into Admin, Write and Read-Only roles and their usage mapped according to the amount…

  • What’s inside the dump file

    What’s inside the dump file

    A dump file is a zip file which contains history of data of the previous 10 min of your TM1 instance or TM1 server. You’ll find details of everything that happened in the previous 10 min before the dump file was created such as who was logged in, which processes or chores ran during the…