IBM Planning Analytics for Microsoft Excel – or PAfE (previously referred to as PAX) – is a Microsoft Excel-based tool that report authors use to build sophisticated, multiple-sheet, multiple-query reports against multiple databases, including Planning Analytics models. If you are a PAfE user, or support a group of PAfE users, you may eventually need to…

Planning Analytics (PA) is a great platform for building models, such as workforce planning, revenue planning, and capital expenditure. These models require data from other systems. The cloud version of PA provides many data integration methods. However, a flat file is still useful when other data integration methods are not possible. To upload a file…

The OFFSET-FETCH filter is a SQL combination designed so that you can specify how many rows you want to skip before specifying how many rows you want to return in a SQL query. This can come in handy in a variety of ways such as returning results to the user one “slice” at a time…

One of IBM Planning Analytics (PA) biggest advantages over other applications is the ability to use feeders. When it comes to issues of sparsity within cubes, feeders improve performance by giving developers a way to prevent Planning Analytics from trying to look through millions of intersections to find all the data to consolidate. Essentially, feeders…

When working with IBM Planning Analytics, it is not uncommon to source data from a relational data source. Typically, you will see a Data Warehouse or Data Lake where data is transformed and loaded on a schedule using an ETL tool. ETL, which stands for Extract, Transform and Load, extracts data from a source, modifies it in some…

We process more and more data every day. Some processing tasks take a few minutes while others take more than a few hours. The length of processing time depends on the amount of data, the speed of hardware, and how we process data. The first two factors are usually fixed for a given scenario so…

The EXECUTEPROCESS function is used to call and run a TurboIntegrator (TI) processe from within another TurboIntegrator processes. This function will run the process identified within the parentheses along with any specified parameters that follow.     The first argument in the function will be the process that is going to be executed. The only…

The DIMIX function is a helpful function that can be used in TurboIntegrator (TI) processes and TM1 rules. Simply put, the function will return the index number of an element within a dimension. If the element does not exist in the dimension, the function will return with a 0.     The first argument in…

While is a Turbo Integrator (TI) function that is widely used to “loop” through data repeatedly, without wrapping multiple processes together to accomplish the same goal. Below is the syntax: Define loop iteration element WHILE ( logical expression ); Statements; loop iteration; END; Let’s illustrate it by using a simple WHILE loop example: We want…

Did you know that Planning Analytics has a build in scheduling functionality call Chores? Chores can be used in two distinct ways; you can schedule one or more TurboIntegrator processes to execute at defined intervals or you can setup a sequence of TurboIntegrator process to be execute by a user. These two concepts can be…