IBM
Using File Explorer in Planning Analytics Workspace
Using File Explorer in Planning Analytics Workspace A shared drive on a MS Windows machine is a folder or “drive” that can be shared across computers and with other users allowing individuals to store, search, and access files from other devices. Shared drives are a common way to store, search and grant file access to individuals. As…
Read MoreData Modeler or Data Analyst
Data Modeler or Data Analyst The act of data modeling can be challenging for a variety of reasons. Rapidly Evolving Business Needs – it is an uncommon thing today for a business to have a firm grasp on all its needs and if it does, rapid growth (or contraction) of the business can quickly change…
Read MoreIBM Planning Analytics for Excel – Quick Start
IBM Planning Analytics for Excel – Quick Start If you are an IBM Excel Perspectives user and your organization is moving to Planning Analytics for Excel (PAfE), the following information should be useful. What is Planning Analytics for Excel (PAfE)? So… what exactly is Planning Analytics for Excel (PAfE)? Technically speaking, PAfE is special software…
Read MoreMultiprocessing to Improve TI Process Performance
Multiprocessing to Improve TI Process Performance When processing large data sets, splitting a process into smaller parts, and running them simultaneously to leverage multiprocessing, can be a great way to reduce total process run time. This improvement is limited by the processing power and available threads of the Planning Analytics server. This technique is especially…
Read MoreAdvanced Synchronized – Queueing Process Groups
Advanced Synchronized – Queueing Process Groups This article focuses on a specific situation where the Synchronized function can help ensure groups of processes running multi-processed by RunProcess execute serially. This becomes necessary when one group of processes depend on the changes made by another to be fully committed before executing, and it is desired that…
Read MoreUsing Files for TI Process Communication
Using Files for TI 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…
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 MoreImproving Performance in Intra-Cube TI Processes
Improving 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…
Read MoreCharacteristics 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 MoreEditing 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 More