Recently Added
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 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 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 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 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 MoreFeatured Resources
SQL Server Integration Services is a platform for building enterprise-level data integration and data transformations solutions. You can use Integration Services to perform a variety of tasks such as maintaining data hubs that serve Planning Analytics or other enterprise applications. The following outlines the process of creating and deploying a working SSIS package that takes…
Read MoreOfficeConnect has many helpful features that enable detailed report creation tailored to customer needs. Below are a handful of advanced features worth pointing out. Absolute vs Relative Time Most often you will want to open a report and view it as of a certain date without manually updating the report. By properly building your report…
Read MoreIf you are more of a code-junkie at heart like me, or perhaps have come from a relational database background, you may want to think about the following concept. By now, you most likely understand how to build cubes using Planning Analytics Workspace (PAW). If not, you can have a look here. Similar to TM1…
Read MoreReducing Calculations with Text in Anaplan Reducing Calculations in Anaplan improves performance, and I am not referring to reducing line items. I am talking about the pieces of each formula in the line items. Anaplan’s engine is designed primarily to complete tasks that are Boolean, followed by numerical, like most computers. When you leverage text,…
Read More