IBM
How Do Selecting, Copying, and Loading Operations Impact Performance in IBM Planning Analytics?
IBM Planning Analytics – Selecting, Copying and Loading Performance Selecting, Copying and Loading Moving data into, around, and “out of” a Planning Analytics model are examples of common operations and constitute essential practices. Loading usually involves executing database commands to select information from external data sources, perhaps from a transactional general ledger system or from…
Read MoreWhat Helpful Tips and Best Practices Should I Know for Building Reports with Planning Analytics for Excel (PAfE)?
IBM Planning Analytics for Microsoft Excel (or “PAfE”) is a Microsoft Excel-based tool that can be used to build complex, multiple-worksheet, multiple-query reports against multiple databases. You can use the information here as a quick start guide (and then a reference) providing helpful suggestions on using PAfE. If you haven’t yet installed PAfE and need help…
Read MoreHow Do I Insert Spacer Rows and Columns in an Exploration View in PAW?
Inserting Spacer Rows and Columns in an Exploration View With the release of Planning Analytics Workspace version 2.0.90 the ability to add spacer rows and columns has been added. This feature is useful for customizing the presentation of views within books by separating data presentation and improving readability. As of writing, spacer rows and columns…
Read MoreHow Do Custom Synchronization Groups Work in Planning Analytics Workspace (PAW)?
Custom Synchronization Groups With the release of Planning Analytics Workspace version 2.0.88 an additional option for synchronizing widgets within PAW has been added. In addition to Sheet and Book level synchronization, custom synchronization groups can be created and used to fine tune widget synchronization within PAW books. Custom synchronization groups can span an entire PAW…
Read MoreHow Do I Select a Member or Set by Typing in an Exploration View in PAW?
Selecting a Member or Set in an Exploration View by Typing With the release of Planning Analytics Workspace version 2.0.90 an additional method has been added to change the selected member or set in an exploration view. This will allow users familiar with dimension members and sets to quickly type in the specific member or…
Read MoreHow Do I View Dimension-Related Cubes in IBM Planning Analytics Workspace?
View Dimension-Related Cubes in Planning Analytics Workspace With the release of Planning Analytics Workspace version 2.0.87 the ability to view all cubes related to a dimension has been added. This allows users to easily determine which cubes a selected dimension is used in. This is useful for determining the possible impact of deleting a dimension,…
Read MoreHow Do I Disable Specific Data Spreading Options in IBM Planning Analytics?
Disable Select Data Spreading Options in Planning Analytics Workspace With the release of Planning Analytics Workspace version 2.0.86 the ability to disable certain data spreading options available to users has been added. This allows administrators to disable data spreading options that could unintentionally populate a large number of cells when spread to all cells under…
Read MoreHow Do I Create Reusable Custom Code Snippets for Planning Analytics Workspace (PAW)?
Custom Code Snippets for Planning Analytics Workspace With the release of Planning Analytics Workspace version 2.0.88, the ability to upload and use custom code snippets was added to the Workbench in Planning Analytics Workspace. In previous releases, there was only a select amount of code snippets to choose from. After creating and uploading a custom…
Read MoreHow Do I Debug a TurboIntegrator Process in IBM Planning Analytics?
Debugging a TurboIntegrator Process What is TurboIntegrator? Planning Analytics/TM1 TurboIntegrator lets you create processes that automate work such as data importation, metadata management, and other tasks. Each process is a “script object” that consists of: A Data Source description (of an ODBC source, ASCII file, OLAP multi-dimensional source TM1cube view or, TM1 dimension subset) A Set of Variables that…
Read MoreDo I Need an IBM ID to Access IBM-Related Software, Downloads, and Support Resources?
Do I Need an IBM ID? If you are responsible for supporting IBM Planning Analytics (PA), are the “newly appointed” PA or Planning Analytics Workspace (PAW) administrator for your organization or simply a Planning Analytics “consumer”, at some point you will want to “interact” with IBM in respect to potential new offerings, version availability, downloads,…
Read More