Posts by Ben Fabiny
How Do I Use Files for TurboIntegrator Process Communication?
Inter-process communication has limited support within IBM Planning Analytics, and often needs a custom solution when supporting complex process executions. A common one of these situations is when multiprocessing TI Processes. Multiprocessing can be very useful to improve TI process performance, but the master process used to multi-process will complete after it has initiated all…
Read MoreIBM Planning Analytics Process Synchronization
IBM Planning Analytics Process Synchronization Synchronization in Planning Analytics counter-intuitively does not ensure that TI processes run at the same time, in synchronization. Instead, it ensures that only one process with a given synchronized flag is allowed to run at a time. The main use cases for “synchronizing” processes in Planning Analytics by using the…
Read MoreHow Do I Improve Performance in Intra-Cube TI Processes?
Process run times are often ignored if they remain within acceptable timeframes which are generally constraints set by the business but can sometimes be measured by user patience. Many times, it is not until they exceed these limits that they are addressed. Tackling performance of processes, especially in large models, is no simple task and…
Read MoreWhat Are the Key Characteristics of a Good Data Model in IBM Planning Analytics?
IBM Planning Analytics – Characteristics of a “Good” data model Modeling Many “strategies” exist today for modelling (building a database) in IBM Planning Analytics. If you are a member of the IBM Community, you’ll find no shortage of opinions and recommendations – from informal blogs and discussions to more formalized courses and mentoring. In fact,…
Read MoreHow Do I Edit Consolidated Cells in IBM Planning Analytics?
IBM Planning Analytics – Editing Consolidated Cells TM1/Planning Analytics users should not be able to write to consolidated cells, with two exceptions: If the element in the last dimension is a String (that is, text) type; or If you are doing a Data Spreading Clear function. If you’re trying to prevent input into consolidated string…
Read MoreHow Do Selecting, Copying, and Loading Operations Impact Performance in IBM Planning Analytics?
IBM Planning Analytics – Selecting, Copying and Loading Performance Selecting, Copying and Loading Moving data into, around, and “out of” a Planning Analytics model are examples of common operations and constitute essential practices. Loading usually involves executing database commands to select information from external data sources, perhaps from a transactional general ledger system or from…
Read MoreWhat Helpful Tips and Best Practices Should I Know for Building Reports with Planning Analytics for Excel (PAfE)?
IBM Planning Analytics for Microsoft Excel (or “PAfE”) is a Microsoft Excel-based tool that can be used to build complex, multiple-worksheet, multiple-query reports against multiple databases. You can use the information here as a quick start guide (and then a reference) providing helpful suggestions on using PAfE. If you haven’t yet installed PAfE and need help…
Read MoreHow Do I Insert Spacer Rows and Columns in an Exploration View in PAW?
Inserting Spacer Rows and Columns in an Exploration View With the release of Planning Analytics Workspace version 2.0.90 the ability to add spacer rows and columns has been added. This feature is useful for customizing the presentation of views within books by separating data presentation and improving readability. As of writing, spacer rows and columns…
Read MoreHow Do Custom Synchronization Groups Work in Planning Analytics Workspace (PAW)?
Custom Synchronization Groups With the release of Planning Analytics Workspace version 2.0.88 an additional option for synchronizing widgets within PAW has been added. In addition to Sheet and Book level synchronization, custom synchronization groups can be created and used to fine tune widget synchronization within PAW books. Custom synchronization groups can span an entire PAW…
Read MoreHow Do I Select a Member or Set by Typing in an Exploration View in PAW?
Selecting a Member or Set in an Exploration View by Typing With the release of Planning Analytics Workspace version 2.0.90 an additional method has been added to change the selected member or set in an exploration view. This will allow users familiar with dimension members and sets to quickly type in the specific member or…
Read More