IBM
How 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 MoreHow do you use one title dimension selection to control another dimension’s subset in a PAW cube view?
A useful feature of building a cube view in Planning Analytics Workspace is the availability of using MDX to control dimension element selections. This functionality can be leveraged to use the selection made in one title element drive what element a separate dimension uses. In this article I have two examples. The first is using…
Read MoreHow Do I Use Hash Values in Planning Analytics to Detect Changes and Improve Data Processing?
When working with IBM Planning Analytics, it is not uncommon to source data from a relational data source. Typically, you will see a Data Warehouse or Data Lake where data is transformed and loaded on a schedule using an ETL tool. ETL, which stands for Extract, Transform and Load, extracts data from a source, modifies it in some…
Read More