IBM
IBM Planning Analytics – Setting up Basic DRILL THROUGH Functionality
Did you know you can use Planning Analytics’ drill-through feature to access detailed data in another Planning Analytics cube or a configured relational table? This feature can allow for a user to quickly find detailed information underlying a data point which is either in the model in a more detailed cube, or not in Planning…
Read MoreBest Practices for configuring CHORES
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…
Read MoreHow to use the WHILE Loop in a Turbo Integrator Process
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…
Read MoreIBM Planning Analytics: Control Objects – what are they and how to view them
Control objects are system-generated objects in Planning Analytics that can help perform tasks such as administer security, record attributes, and record performance statistics (if performance monitor is on). These will include cubes, processes, and dimensions that are all prefixed with the symbol }. Types of Control Objects Security Control Cubes There are several security control…
Read MoreIBM Planning Analytics: DIMIX Function – When and how to use it
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…
Read MoreEXECUTEPROCESS Function, when and how to use
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…
Read MoreUsing Conditional Formatting & Calculations with IBM Planning Analytics Workspace
IBM Planning Analytics Workspace (PAW) is a web-based interface for IBM Planning Analytics. It delivers an interface to the data in planning analytics (TM1), providing ways to plan, create, and analyze your content by providing features such as conditional formatting and calculations. Conditional formatting is a feature in many spreadsheet applications that allows you to apply specific formatting to cells that…
Read MoreLoading Data into a Cube using IBM Planning Analytics Workspace
IBM Planning Analytics stores data that you need for your planning, analysis, and other reporting in multidimensional cubes. Each cube typically has a specific purpose. A cube must have at least two dimensions. The number of dimensions that there are in a cube depends on the purpose of the cube. Loading a Cube Once you…
Read MoreIBM Planning Analytics and PGP
Pretty Good Privacy (PGP) is an encryption program that provides cryptographic privacy and authentication for data communications. PGP is used for signing, encrypting, and decrypting texts, e-mails, files, directories, and whole disk partitions and to increase the security of e-mail communications. When you send a message using PGP, the message is converted into unreadable ciphertext on your device before it passes over the Internet. Only the recipient…
Read MoreVisualizing Data in Minutes using IBM PAW
Perhaps you work for a residential home builder startup that wants to start using analytics to determine what sort of home they should be building and where. That is, what might be the optimal number of bedrooms, bathrooms and/or square footage for a residential home in each state in the US? Let’s see how IBM…
Read More