IBM
How Do I Use Custom Themes in IBM Planning Analytics Workspace (PAW)?
Did you know that you can override the standard Planning Analytics Workspace (PAW) theme with your own “custom theme” that reflects your corporate branding or culture? You can use a custom theme to: Modify the colors of the application bar Modify the colors of the navigation bar Set the corporate title that is shown on the home…
Read MoreHow Do I Use MDX to Create a Dynamic Cube View in IBM Planning Analytics?
IBM Planning Analytics (PA) subsets can be made dynamic by using multi-dimensional expressions (MDX). Doing so allows for automation and will ensure that subsets update if the dimension changes. MDX allows for many different use cases such as filtering by attributes, levels or using a wildcard search to display all elements that meet a specific…
Read MoreHow Do I Manage Multiple ODBC Credentials in IBM Planning Analytics Workspace?
TurboIntegrator (TI) processes in IBM Planning Analytics (PA) allow connections to various data. One option is an ODBC connection, which stands for Open Database Connectivity. This is an extremely reliable method that directly connects to an external relational database and allows you to extract data through a query. This article explains how ODBC username and…
Read MoreHow Do I Maintain Hierarchies in Planning Analytics Workspace (PAW)?
Planning Analytics Workspace (PAW) comes with the feature to create multiple hierarchies in one dimension. These hierarchies are generally created by the attributes of the dimension. Once a hierarchy is created, it is detached from the attribute values. Therefore, a developer should create a TI (TurboIntegrator) process to maintain the hierarchies which are built based…
Read MoreHow Do I Collect Data for Earnings Reports in IBM Planning Analytics?
An earnings call is one of the most important meetings between the management team of a public company and its external stakeholders. The company prepares internal and external reports like an annual business disclosure report (10-K) every quarter. The typical timeframe for collecting data and producing the earnings-related documents is less than 60 days. That…
Read MoreHow Do I Integrate Snowflake Data with IBM Planning Analytics Using ODBC and TurboIntegrator?
In another post I explored how easy it is to access cloud-based Snowflake, create a database, define and then load a table with data from a local file. In this post, I investigate the steps required to integrate some Snowflake data with IBM Planning Analytics (TM1). The steps will include: Configure an ODBC Data source…
Read MoreHow Do I Troubleshoot Common Planning Analytics Workspace (PAW) Security Issues?
PAW (Planning Analytics Workspace) has four types of security: User Role, User Group, Folder Security, and Book Security. These security types are separated from the database security, such as cube security, element security and process security. A PAW administrator usually helps a user fix security issue in PAW. This article covers the common security issues…
Read MoreHow Do I Diagnose and Resolve Performance Issues in Planning Analytics for Excel (PAfE)?
IBM Planning Analytics for Microsoft Excel – or PAfE (previously referred to as PAX) – is a Microsoft Excel-based tool that report authors use to build sophisticated, multiple-sheet, multiple-query reports against multiple databases, including Planning Analytics models. If you are a PAfE user, or support a group of PAfE users, you may eventually need to…
Read MoreHow Do I Upload Data Files to IBM Planning Analytics Cloud for Use in My Models and Reports?
Planning Analytics (PA) is a great platform for building models, such as workforce planning, revenue planning, and capital expenditure. These models require data from other systems. The cloud version of PA provides many data integration methods. However, a flat file is still useful when other data integration methods are not possible. To upload a file…
Read MoreHow Do I Use the RunProcess Command to Shorten Data Processing Time in IBM Planning Analytics?
We process more and more data every day. Some processing tasks take a few minutes while others take more than a few hours. The length of processing time depends on the amount of data, the speed of hardware, and how we process data. The first two factors are usually fixed for a given scenario so…
Read More