IBM
How Do I Use 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 MoreWhat’s the Difference Between a Data Modeler and a Data Analyst, and Which Role Do I Need?
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 MoreHow Do I Get Started with IBM Planning Analytics for Excel (PAfE)?
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 MoreHow Do I Use Multiprocessing to Improve TurboIntegrator 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 MoreHow Do Advanced Synchronized Queueing Process Groups Work in IBM Planning Analytics?
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 they run in the same execution.…
Read MoreHow 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 More