Posts by agoddard
EXECUTEPROCESS 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 MoreA Database Administrator Approach to Building Cubes in IBM 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 MoreUpgrading PAW on Linux with 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 MoreIBM Planning Analytics Version History
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 to 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 MoreBuilding 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