IBM
How Do I Use a TurboIntegrator Process to Build a Dimension Hierarchy in IBM Planning Analytics?
In this article we look into the sources and functions necessary to build a dimension’s hierarchy using an IBM Planning Analytics Turbo Integrator [TI] process. Read on to learn how to set it up, some best practices, and some troubleshooting tips. What TI functions are used to create hierarchy in a dimension? DIMENSIONELEMENTINSERT() and DIMENSIONELEMENTCOMPONENTADD()…
Read MoreHow Do I Use the ELISANC Function in TurboIntegrator for IBM Planning Analytics and What Does It Do?
ELISANC is one of the more versatile functions in Planning Analytics. The function determines whether the first element is an ancestor of the second element. This function returns 1 if the relationship is true, and it returns 0 if the relationship is not true. Although ELISANC can be used in rules and TurboIntegrator (TI), we…
Read MoreHow Do I Use the ASCIIOutput Function in IBM Planning Analytics and What Are Common Use Cases?
The ASCIIOutput function creates a comma-delimited record in an ASCII output file. This function is a TurboIntegrator function and it can be used to export data, debug a TurboIntegrator process, or generate an ASCII file for many purposes. This article will show the syntax of this function and some examples of its arguments. In addition,…
Read MoreWhat Is the Difference Between ELPAR and ELCOMP in IBM Planning Analytics and How Are They Related?
The short answer is Yes! These are invaluable elemental information functions within Planning Analytics. These functions can be used in Rules, Worksheets, and TI Processes. ELPAR and ELCOMP are very similar to one another and have other related functions which can return information about how elements reside within dimensions. In this post, I will discuss…
Read MoreWhat Changed in MDX Subset Evaluation in IBM Planning Analytics 2.0.9 and How Does It Affect My Queries?
Planning Analytics Changes to MDX Subset Evaluation in 2.0.9 July 2020 UPDATE: IBM has reverted the change described in this article in release 2.0.9.2 of Planning Analytics (PA), which is now available to Local and IBM Cloud customers. Additional background and information about this issue, and the fix by IBM, can be found in this…
Read MoreHow Do I Use IBM SPSS Modeler Advanced Stream Automation to Automate Analytic Workflows?
If you’re just starting scripting in modeler, please read the Basic Stream Automation article before this one! In this article, we’ll talk through three more advanced topics including: Setting properties of nodes Looping through nodes to set connection properties on multiple nodes at once These are extremely common use cases that can be combined to…
Read MoreHow Do I Manage IBM SPSS Modeler Streams Using Collaboration and Deployment Services (C&DS)?
IBM SPSS Collaboration and Deployment services, or C&DS, is a tool for managing SPSS content. This includes version control and job creation/stream automation. In this article, we’ll go through the SPSS Modeler interface for interacting with C&DS – storing streams, retrieving streams, and managing version control. Connecting to the C&DS Repository To connect to the…
Read MoreHow Do I Automate SPSS Modeler Streams Using Basic Jython Scripting?
Scripting in Modeler is an extremely powerful way to automate processes and execution of streams. Just about any action that you can perform manually can be automated using the Jython scripting API. This is convenient if you’re running the stream from within Modeler client, and extremely important if you’re running the stream outside of Modeler…
Read MoreCreating Level-Based Row Indentation for Planning Analytics for Excel (PAfE) Reports
Level-based row indentation is a great way to add quick readability to your Planning Analytics for Excel (PAfE) reports. Instead of having a list of elements all left-aligned, we can add indentation based upon each member’s level to help report readers understand hierarchies within the dimension. Exploration Views, Quick Reports and Dynamic Reports all have…
Read MoreHow Do I Move Files to IBM Planning Analytics in the Cloud (PA Cloud) for Processing and Analysis?
You can use the IBM Secure Gateway to establish a secure connection between your on-cloud Planning Analytics environment and your on-premises data sources and easily move and manage data files in your on-cloud shared folder either remotely or directly within a desktop session on the IBM cloud. If you have multiple cloud environments, you can…
Read More