Posts by agoddard
SPSS Modeler: Advanced Stream Automation
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 MoreSPSS Modeler: Managing 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 MoreSPSS Modeler: Basic Stream Automation
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 MoreMoving files to IBM Planning Analytics in the Cloud
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 MoreGet Started Monitoring Planning Analytics Databases in the IBM Cloud
IBM Planning Analytics Administration includes the ability to monitor and administer your databases from the Planning Analytics Monitoring dashboard (as long as you have administrator access to use the dashboard). Note: This information applies to Planning Analytics running in the IBM Cloud Environment. First question, what exactly are we referring to when we say, “a…
Read MoreMore Monitoring Planning Analytics Databases
In an earlier post, we mentioned how IBM Planning Analytics Administration includes the ability to monitor and administer your databases, as well as your host environment, from the Planning Analytics Monitoring dashboard (as long as you have administrator access to use the dashboard). Note: This particular functionality is available in both local/on premise installations as…
Read MoreBreaking Down the IBM Planning Analytics Database Activity Report
In earlier posts, we outlined how you can use the IBM Planning Analytics Monitoring dashboard within Planning Analytics Workspace (PAW) administration to track the health of your host environment as well as individual databases. In this post we aim to breakdown the detailed database activity report which is available when you click the database name…
Read MoreExploring the IBM Planning Analytics Database Usage Visualization
In previous blog posts, we discussed the IBM Planning Analytics Monitoring dashboard within Planning Analytics Workspace (PAW) administration, which can be used to track the health of your host environment as well as individual Planning Analytics (TM1) databases. In this post we want to dig deeper into the database activity report and specifically, the usage…
Read MoreData Spreading Shortcuts in IBM Planning Analytics Workspace
What do we typically mean when we say, “data spread”? Well, perhaps the simplest way to understand this concept is by thinking of it as the act of “applying data across a range” – say a period of time. Perhaps you expect expenses to total a certain amount for the year, but you need to…
Read More