Planning Analytics (PA) sets and views can be created using multi-dimensional expression (MDX) language to make them dynamic and help to automate PA applications. One simple way to harness the power of MDX in your PA application is to create a “Current Time Period” set that can be used to make any view dynamically show…

TM1 is great at consolidating data, but what if you want to prevent that from happening? Consider the following example, where we have FTE data for an employee at the Month level that is being incorrectly consolidated at the Quarter level.   We can use business rules to pull the last month in the quarter…

How to create MDX expressions According to the dimension and your business need, dimensions may be large. You may want to limit the data shown in the report or input schedule. You can create customized categories or subsets of dimensions for your report or input schedule.  Customized subsets are utilized to speed the selection of…

QueBIT Webinar – Advanced Topics – Write TM1 Rules like a Pro! If you’re a TM1 user, you know rules are how you work business logic into your model. You probably calculate things like salaries and sales, and you may even have more complex calculations in your model such as exchange rates and allocations. Since…

QueBIT Webinar – New ETL Debugging Tool 091417 – quebit IBM has released a new tool to help you debug your Turbo Integrator code. This recording will walk you through utilizing this new tool to help you with your TI code.

IBM Planning Analytics’ Calculation Types IBM Planning Analytics is well known for the speed with which it performs on-the-fly, on-demand aggregations, consolidations and other calculations. The calculation of a specific number in a Planning Analytics cube is not performed until it is requested, for example by a DBR() formula in a spreadsheet, and when it…