Posts by Ben Fabiny
Event Thresholds and Alerts – 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 MoreEnabling 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 MorePlanning Analytics for Microsoft Excel API for Macro Automation
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 MoreCommon PAW Administrator Tasks
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 MoreMemory Usage and 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 MoreUsing 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 More