IBM
How Do I Set Up Basic Drill-Through Functionality in IBM Planning Analytics to Navigate From a Cube to a Detail Report?
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 MoreWhat Are Best Practices for Configuring and Scheduling Chores in IBM Planning Analytics?
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 Do I Use the WHILE Loop in a TurboIntegrator (TI) Process to Control Iterations in IBM Planning Analytics?
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 MoreWhat Are IBM Planning Analytics Control Objects and How Do I 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 MoreWhen and How Do I Use the DIMIX Function in IBM Planning Analytics to Mix Dimension Members?
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 MoreWhen and How Do I Use the ExecuteProcess Function in IBM Planning Analytics to Run TurboIntegrator Processes?
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 MoreHow Do I Apply Conditional Formatting Calculations in IBM Planning Analytics Workspace to Highlight Data Based on Logic?
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 MoreHow Do I Load Data into a Cube Using IBM Planning Analytics Workspace (PAW)?
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 MoreHow Do I Use PGP Encryption with IBM Planning Analytics for Secure Data Transfers?
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 MoreHow do I visualize 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