Posts by Ben Fabiny
How Do I Use Event Thresholds and Alerts in IBM Planning Analytics Workspace?
Observability and Monitorability Key components of modern-day enterprise software are observability (visibility into the activities occurring within the software) and monitorability (defining threshold limits for critical system metrics). IBM Planning Analytics provides both when using Planning Analytics Workspace (or PAW). Monitoring Activity You can view a detailed report of all current activities (known as “threads”)…
Read MoreHow Do I Enable Performance Monitoring in IBM Planning Analytics Workspace?
Enabling Performance Monitoring in IBM Planning Analytics Workspace PA/TM1 Performance Monitor is a collection of tools that monitor the performance of IBM PA/TM1 servers in real-time. It can track and store performance data in control cubes, such as StatsByClient, StatsByCube, StatsByCubeByClient, and StatsForServer. These cubes track various statistics, such as message count, average message size, memory use, and…
Read MoreHow Do I Use the Planning Analytics for Excel API to Automate Tasks with Macros?
Planning Analytics for Microsoft Excel API for Macro Automation It’s not uncommon to move an MS Excel workbook from Perspectives to Planning Analytics for Excel (PAfE) and find that there are buttons within the workbook that run macro(s) to perform automation tasks. If there are, you may encounter the following (or similar) error: “Cannot run…
Read MoreWhat Are the Common Administration Tasks in IBM Planning Analytics Workspace (PAW) and How Do I Perform Them?
Common PAW Administrator Tasks Administering IBM Planning Analytics Workspace includes managing users, administering the database, migrating assets, as well as other “administrative type ”actions. You access the Administration page from the Administration tile on the Planning Analytics Workspace home page (shown below). If you are not an administrator, you cannot see the Administration tile on the Planning Analytics Workspace home page. Administration tile on the Planning Analytics…
Read MoreWhat Should I Know About Memory Usage in IBM Planning Analytics?
Memory Usage and IBM Planning Analytics IBM Planning Analytics (PA) is an advanced analytics solution that uses an in-memory database architecture to produce real-time results. But what is an in-memory database? An in-memory database (or IMBD) is on that stores data in the computer’s main memory, instead of a hard disk drive, allowing faster response…
Read MoreHow 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 More