New Features & Performance Improvements with TM1 Planning Analytics

Start Here

Get in touch with a
TriCore Solutions specialist

Blog | Sep 21, 2017

New Features & Performance Improvements with TM1 Planning Analytics

Planning Analytics Local uses hierarchies for deeper analysis of TM1 data. Essentially it turns attributes into virtual dimensions, saving RAM, increasing query performance and adding flexibility. Which in turn enables users to have smaller, faster cubes, to introduce hierarchies to queries as needed, and to do dimension versioning.

Planning Analytics Local is the latest release and rebranding for IBM Cognos TM1. Planning Analytics Local has brought in substantial changes and updates to the TM1 product adding new functionalities leading to performance enhancement.

Introduction:

IBM Planning Analytics Local, the convergence of TM1 on premise with Planning Analytics on the cloud is released by IBM as part of rebranding existing TM1. This new release provides great enhancements and performance improvements.

One highlight of the new feature is Planning Analytics Workspace, which is a completely transformed user experience. This new “face” of TM1 provides a rich, interactive workspace which is visual, intuitive, insightful, social and mobile.

Planning Analytics Local uses hierarchies for deeper analysis of TM1 data. Essentially it turns attributes into virtual dimensions, saving RAM, increasing query performance and adding flexibility. Which in turn enables users to have smaller, faster cubes, to introduce hierarchies to queries as needed, and to do dimension versioning. 

Below are the Interfaces and new features with Planning Analytics Local:

1: Planning Analytics Workspace (PAW)

Workspace is the new foundation for PA Local. Workspace is a web-based tool that was originally developed on the cloud and provides a rich, user interface ideal for exploring and visualizing your TM1 data. Workspace includes support for all of the new features included in PA Local, including new hierarchies support.

planning analytics workspace

Image Source: IBM Portal

2: Planning Analytics for Excel (PAx)

PAx is the new excel interface for Planning Analytics, and takes the place of CAFÉ. PAx has a totally new look and supports many features Perspectives users have come to love. PAx even incorporates a new cube browser and a set editor: the exact same one is used in Workspace. While PAx is the future of TM1 data access from Microsoft Excel, it does not yet include all of the Perspectives reporting features and, thus, TM1 Perspectives is still available in PA Local. Each release of PAx will incorporate more Perspectives features.

excel planning analyticsImage Source: IBM Portal

3: TM1 Web

TM1 Web has also been updated and also matches the look and feel of the other PA Local applications. TM1 Websheets can access relational data directly when published from PAx, which will expand existing drill through and comparison capabilities. In addition, TM1 Web now supports the new hierarchy features when publishing Quick Reports from PAx (formerly known as Flex Views in CAFÉ.)

TM1 web interface
Image Source: IBM Portal

4: New feature for Modeling and Analysis: Hierarchies

PA Local brings the long-awaited hierarchies feature to the TM1 product line. Hierarchies will change the way you model your business in TM1 because it is a fundamental shift in standard TM1 architecture.

TMI hierarchiesImage Source: IBM Portal

In the new architecture, a dimension is a collection of hierarchies, and not elements. This will allow users to turn attributes or other information into virtual dimensions to better filter and consolidate data. Hierarchies will also make it easier to clearly separate and use alternate hierarchies in a dimension. Indeed, hierarchies also enables adding a dimension to a cube view multiple times, for example allowing you to browse products by color, category, and size all at the same time. Most importantly, hierarchies will result in simpler cubes with fewer dimensions, lower RAM footprint, and increased query performance.

5: Improved Server Performance and Features

Planning Aanalytics Local also improves the performance of the underlying TM1 Server. New features include:

  • Encryption at Rest: TM1 Data folders can be encrypted to meet FIPS Certification.
  • TI Debugger: Track variables, set breakpoints, view locks!
  • Multithreaded Feeder Propagation: The MTQ Framework has been applied to feeder generation, greatly speeding up TM1 Rule saves and server startup.
  • Reduced locking contention: Allows for more frequent metadata updates and reduced locking typically caused by logins and other updates. 

Conclusion: Among many other features, migrating to planning, Analytics Local helps improveTM1 performance, reduces RAM consumption and provides end users with self-service interactive dashboards and visualizations from a variety of data sources. For any further info click below:

Ask Raghavendra