Cognos Analytics 11.0.6 adds support for Planning Analytics Local. Here are the new integration highlights in version 11.0.6.
Dashboard support for packages with TM1 and Planning Analytics cubes
As of version 11.0.6, you can make Cognos Analytics dashboards using packages from TM1 or Planning Analytics cubes. As always you create the packages in the Cognos Administration console or with Framework Manager. See Dashboard Enhancements in Cognos Analytics 11.0.6 for information on the OLAP support now available in dashboards.
REST connectivity to Planning Analytics
Cognos Analytics connects to TM1 data sources using TM1 client software which needs to be installed on the Cognos Analytics server. Cognos Analytics connects to Planning Analytics using the TM1 REST API which doesn’t require any additional software to be installed. You create a connection to Planning Analytics from the Cognos Administration console by selecting the IBM Planning Analytics data source connection type.
If you are upgrading from TM1 to Planning Analytics, within the Cognos Administration data source you can replace the TM1 connection with a Planning Analytics connection. Subsequently you need to re-publish any packages that refer to that data source, but no need to make any changes to the associated reports.
Support for Planning Analytics hierarchies
Sometimes referred to as “attribute hierarchies” and “named alternate hierarchies”, they are commonly known as simply “PA hierarchies” and are arguably the most important new TM1 server feature in Planning Analytics Local. Here’s a 3 min video on them.
Planning Analytics hierarchies appear and behave no differently than any other OLAP hierarchy in Cognos Analytics, but now you can have a TM1 dimension that has multiple hierarchies.
You need to use a Planning Analytics data source connection to see multiple TM1 hierarchies within a dimension; if you try to use a TM1 data source connection only the first or default hierarchy will appear within each dimension.
Support for localized Planning Analytics cubes
TM1 10.2.2 introduced the ability to localize objects in a cube without needing alias tables as documented here. This is supported in Cognos Analytics via a Planning Analytics REST connection only.
Cognos Analytics users can see a localized Planning Analytics cube in their language by either setting the Content Language in their user preferences or by setting the report language in the report properties. Note that you do not need to use the language settings that appear when creating a package for Planning Analytics cubes as those are for the legacy alias table localization functionality only.