Software

IBM Cognos TM1 10.2 – What’s New

IBM Cognos TM1 10.2 has just been released bringing a number of enhancements and new features.  It is the most significant release of TM1 since IBM bought Cognos and will dramatically change the way TM1 is used.

Here is a summary of what’s new in TM1 10.2

Integrated Scorecards

Scorecard Cognos Insight display

Scorecard Cognos Insight display

In this new version of IBM Cognos TM1 10.2, a scorecard cubes feature has been added, which allows users to display the business’ strategies and the relationship of different key performance indicators (KPIs).

The scorecard enables a broader range of users in the business to have better understanding of its strategies, and how it can be translated into actions and planning.  The TM1 10.2 scorecard cubes provide users graphical displays of the performance and linkages of KPIs.

The new scorecard cubes can be displayed on TM1 Applications Web and Cognos Insight. 

Performance/Architecture Enhancements

Performance enhancements, as expected, that makes the new TM1 10.2 perform faster and is more stable with enhancements like improved Dynamic Query Mode and multithreaded queries.

New Mobile TM1 Contribution Client

Now you can use your iPad to view a TM1 application and contribute to it.

Migration From Cognos Enterprise Planning

The import option uses an .XML application definition file that is generated from your Cognos Planning model. This file is used to get you started with the dimensions, cubes, and links needed to build the model in Cognos TM1 10.2 Performance Modeler.

New Excel interface that brings Together BI and TM1 Data

Cognos TM1 10.2 Excel Interface

Cognos TM1 10.2 Excel Interface

CAFÉ (Cognos Analysis For Excel – which has been aroudn for many years) has been overhauled to connect to TM1 servers. You can use the interactive drag-and-drop environment to explore and analyse data to find answers to business questions or even write back to TM1 and contribute to a plan. You can use excel charts and formulas to create calculations and more effective reports. CAFE can work as a TM1 10.2 Perpectives replacement.

Significantly Enhanced Performance Modeller 

Performance Modeler has received many enhancements in 10.2. Below is a list with the new features:

Enhanced Performance Modeller in TM1 10.2

Enhanced Performance Modeller

 

New In-Cube Calculations
You can now create cube calculations in Performance Modeller directly from a cube view with a drag and drop interface.  There are a lot more of the original TM1 rule functions are included into this rules editor.

You can now define the scope of your cube calculation to across multiple dimensions, and no longer restricted to singular dimension element calculations or links.

Referencing to element attributes has never been easier, as you can simply drag and drop them into the calculations.  There is a new method of importing values from other cubes, making referencing to other cube sources much easier, and imported values are reusable.

New Cognos TM1 Scorecarding
Use Performance Modeller in TM1 10.2 to create cubes for score-carding and KPIs.

New Feeder Optimization
TM1 Performance Modeller can now automatically generate a proposed set of feeders for the cubes in the model. The set is generated whether the modeler defines the rules manually or if the rule is generated automatically from Calculations and Links. In this version PM does a good job to avoid overfeeding, which was a major concern in the previous release, however some care is needed to keep the feeders in the correct order.

Improved handling of Cell Security Cubes

Model security can now be applied and amended on an application using Performance Modeler, this includes security for cells, cubes, dimensions, processes and chores. 

Security of each type is grouped under the relevant grouping, which makes it easier to understand what security has been applied to a model at a glance.

Model security can be now removed without requiring security refresh or shutting down the server, changes takes effect immediately following the security rule is saved.

Cell security on a cube can be applied to a selection of dimensions, instead of all dimensions in a cube as in the previous release.

Full picklist capability
Performance Modeler includes a new Picklist editor, which enables users to define static or dimensional picklists, as well as the ability to set a picklist on a numeric cell.

Link editing improvements
In Cognos TM1 10.2 you can select the source and target members of links separately then paste the source/target member pairs.

Drill-through
You can choose to have a link that is exposed as a drill-through relationship. You can also configure the orientation of the view that results from the drill.

Reuse of Approval Hierarchies
In TM1 10.2, there is an enhancement to allow the same approval hierarchy to be used in multiple applications.  This enhancement can bring significant benefits to the business and efficiency to how TM1 models are designed.  No doubt, this change most of you had been waited for.

This enhancement is very useful when a business operates different budget cycle to forecast cycle, or different budget deadlines for different regions or geographical locations. The flexibility is here to meet those business requirements.  It will also be very useful where the approval hierarchy is to be reused in another cube outside of the Contributor model.

Restrict views to reviewers or contributors
You can now specify different views to be consumed by reviewers or contributors.  This is useful as you can identify what a reviewer or contributor should focus on rather than everyone has similar views.

TurboIntegrator processes triggered from workflow actions
In this new version of TM1, TM1 10.2, a new feature has been added to enable a change of workflow state of a node to trigger Turbo Integrator (TI) processes.  A preset TI process can be triggered immediate before and immediate after the workflow action.

This feature can be quite useful in a number of ways. For example if you have a separate BI reporting cube that is loaded via a TI process rather than rule, when a node is submitted the TI process can be triggered to update the BI reporting cube without extra actions.  And once all the nodes are locked, then you can be sure that BI reporting cube is ready for reporting, without running extra processes.

New TM1 Applications Maintenance utility
In TM1 10.2, a new feature is added to allow some of the TM1 commands to be run from command line, or in a batch file.  

The main purpose of this utility is to automate some of the application maintenance, using a combination of standard TI processes and TI processes that execute commands available in this utility.  And of course, chores can be setup to execute these periodically, such as overnight application maintenance.

Show Data Flow Model Diagramming

In Performance Modeller in TM1 10.2 now you can create a graphical flow diagram that maps the flow of data from cube-to-cube in a model. What’s more the flow charts can understand not only links but also manual written rules that link the cubes.

TM1 10.2 Data Flow Diagrams

TM1 10.2 Data Flow Diagrams

Improved Transfer of Model Objects and Applications

The new Transfer Specification Editor in TM1 10.2 allows modelers to better manage which objects are copied from a source system to a target system. You can transfer an entire application or specific parts like an updated dimension.

This will be especiallly useful for multi stage deployments, such as Dev/Prod or Dev/Test/Prod.

New import of Cognos Enterprise Planning models into Cognos TM1
The new Import functionality helps developers to migrate an Enterprise Planning application in TM1 Performance Modeler.

Performance Modeler Can start as a Normal Application

In this version you have the option to start PM also as a normal application through your start programs and not only through the TM1 applications environment.

Improved Cognos insight Client 10.2.1

Cognos Insight Client

Cognos Insight Client

Work with Attributes
With the new IBM Cognos Insight, you can now filter by, create, and display attributes, thus enhancing your reporting capabilities.

Spreading
You can use several new data spreading types in IBM Cognos Insight to distribute data across a range of cells. The data spreading types include relative proportional spread, equal leaves, equal spread, repeat, straight line, and growth percentage. Many of these existed in TM1 Contributor but not in Cognos Insight, now they are on par on this respect.

Distributed Model Improvements
In the TM1 Applications portal, you can now start IBM Cognos Insight in distributed mode from a parent element. You can also now open a Central application type in distributed mode. Another important feature is that you can get a snapshot of the application and work offline. When your are you can reconnect and submit your changes.

All these changes lead also an Improved WAN performance experience.

Scorecards
When you connect to a TM1 server you can view and use scorecards that you created in Performance Modeler

Combination Charts
IBM Cognos Insight now includes combination charts, which combine a column chart and a line chart to display data for two measures on the same chart.

Import External Data
When you are contributing to an IBM Cognos TM1 plan in IBM Cognos Insight, you can now import data from an ASCII file on your computer into your part of the plan.

Drill Through to View Details
If the administrator created drill through links in Performance Modeler, users can now right-click crosstab cells to view related data in another cube.

Print and Export Workspaces
In an IBM Cognos Insight workspace, you can now print the contents of the current tab. You can also export a workspace tab as a new PDF file or append it to an existing PDF file as a new page.

Support for Digit Shaping
IBM Cognos Insight supports the digit shaping options that you set in your operating system.

Support for Bidirectional Languages
You can now enable bidirectional language support in IBM Cognos Insight to change the text direction in your workspaces. 

Enhanced TM1 Web

TM1 10.2 did not just receive new features but it was rather re-written from scratch using SOA (Service Oriented Architecture) technology

Enhanced TM1 10.2 Web

Enhanced TM1 10.2 Web

Cognos TM1 Web now uses a Java-based web Application Server
TM1 10.2 Web has been completely rewritten with Java and there is no need for IIS anymore. It can you use the same application server with TM1. 

Supports Client Side Rendering

Uses AJAX technology and all the formatting rendering is done on the client. Can do incremental updates and refreshes thus leading to improved WAN performance.

Cognos TM1 Web now includes Scorecarding
TM1 10.2 integrates scorecarding cubes and diagrams into Cognos TM1 Web.

Other Improvements

Features better web sheet support and better export support. TM1 10.2 also now includes the Rave charting engine. 

Posted in:

John Vaughan

John Vaughan is a highly experienced Accountant and Consultant. He has experience in the pharmaceutical, FMCG, distribution, professional services, manufacturing and financial service industries. With over 25 years of commercial experience and 20 years working with the Cognos products, he...

Leave a Comment





Need help with TM1?
We're here for you

Categories

Tags

Popular Articles