Recently Added

Characteristics of a “Good” Data Model in IBM Planning Analytics

IBM Planning Analytics – Characteristics of a “Good” data model Modeling Many “strategies” exist today for modelling (building a database) in IBM Planning Analytics. If you are a member of the IBM Community, you’ll find no shortage of opinions and recommendations – from informal blogs and discussions to more formalized courses and mentoring. In fact,…

Read More

Editing 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 More

Selecting, Copying and Loading 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 More

PAfE Reporting Hints

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 More

Inserting 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 More

Featured Resources

A SQL Server Integrated Services SSIS Exercise

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 More

Advanced Features in OfficeConnect – Workday Adaptive Planning

OfficeConnect 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 More

A Database Administrator Approach to Building Cubes in IBM Planning Analytics Workspace

If 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 More

Reducing Calculations with Text – Anaplan

Reducing 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

Can't find what you're looking for?