Posts by agoddard
How 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 MoreHow Do I Get Started Monitoring IBM 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 MoreHow Do I Monitor IBM Planning Analytics Databases to Track Performance and Usage?
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 MoreHow Do I Interpret the IBM Planning Analytics Database Activity Report to Monitor Server Performance?
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 MoreHow Do I Use the Planning Analytics Database Usage Visualization to Monitor Activity and Threads?
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 MoreWhat Are the Data Spreading Shortcuts in IBM Planning Analytics Workspace and How Do I Use Them?
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