Posts by agoddard
When 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 MoreHow Do I Build IBM Planning Analytics Cubes Using a Database Administrator Approach in Planning Analytics Workspace?
If you are more of a code-junkie at heart like me, or perhaps have come from a relational database background, you may want to think about the following concept. By now, you most likely understand how to build cubes using Planning Analytics Workspace (PAW). If not, you can have a look here. Similar to TM1…
Read MoreHow do I upgrade PAW on Linux using MobaXterm and QueBIT script files?
Upgrading PAW on Linux with MobaXterm and QueBIT Script Files Environment Setup: Obtain a Linux user ID user that has “sudo” rights Confirm with IT team that Linux install has all basic components including: i. yum-utils 11. unzip Note that Word may change a short hyphen to a long hyphen so be careful copying and…
Read MoreHow do I interpret the version history for IBM Planning Analytics?
When IBM rebranded TM1 to Planning Analytics, the versioning also changed. On the surface and on IBM’s Software Access Catalog and Fix Central, the IBM PA version downloads are listed as 2.X, but behind the scenes the server versions are listed as 11.X. The chart below will help with translating what PA version 2.X is…
Read MoreHow do I import a file for an IBM Planning Analytics Workspace (PAW) TI process?
With the latest IBM Planning Analytics PAW user interface, Modelers and Admins can import a CSV file as the Turbo Integrator (TI) Process data source, just like in the past using Architect. Within PAW’s left-hand Data Pane, right-click on Processes, then opt to “Create New Process.” Within the TI user interface, IBM instructs the Modeler…
Read MoreHow Do I Build an Open Source, Multitiered Application?
In software engineering, multitier architecture (or multilayered architecture) is an architecture in which presentation, application processing and data management are physically separated. Often you will see architectural diagrams depicting the three “tiers” as: The Data Tier (where information is stored in a database or file system) The Logical Tier (where processing commands are executed, logical decisions are made, and calculations may be…
Read More