Posts Tagged ‘Planning Analytics How To’s’
How Do I Edit Consolidated Cells in IBM Planning Analytics?
IBM Planning Analytics – Editing Consolidated Cells TM1/Planning Analytics users should not be able to write to consolidated cells, with two exceptions: If the element in the last dimension is a String (that is, text) type; or If you are doing a Data Spreading Clear function. If you’re trying to prevent input into consolidated string…
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 MoreHow Do I Remove Element-Level Security in IBM Planning Analytics?
Planning Analytics Security You can create and implement a security scheme in TM1\Planning Analytics to secure objects and data in your server by defining security groups and clients (users), assigning access permissions to those groups and then assigning users to one or more of the groups. A good security schema will typically consider controlling access…
Read MoreHow Do I Perform Step-By-Step Consolidations in IBM Planning Analytics?
Planning Analytics – Step by Step Consolidations What is Consolidation? In Planning Analytics/TM1, dimensional elements that represent aggregations are called “consolidated elements” or consolidations (business users may also refer to them as “groupings”). The following image shows three levels of consolidation for elements of a Period dimension. The months (200801) provide the lowest level of detail (or…
Read More