Tuesday, January 28, 2014

CDM - Advanced Scripting with Query Variables

When setting up data queries within CDM you have the full power of MDX available to you.
You can then create the right syntax to return any element within TM1.
As an example lets assume we have a Scenario dimension in TM1 and we take a static snapshot of the Budget every year e.g. Budget2014. We now in CDM want our queries to be dynamic and we have setup a query variable YYYY which is currently set to 2014.
When creating my queries i can use the Advanced Scripting option and then use the following syntax


This should resolve to:


Monday, January 27, 2014

No Servers displaying in TM1Web in TM1 10.2 FP1

If you are applying 10.2 FP1 then make sure you read the following article:


Especially these bits:

a. Delete the config.ini file which can be found <TM1 install>\tomcat\work\Catalina\localhost\pmhub\eclipse\configuration.
This is required when using TM1 Operations Console, Cognos Analysis for Microsoft Excel® or Cognos TM1 Mobile Contributor.
b. Open Cognos Configuration.
c. When you first open Cognos Configuration after applying FP1 a message displays that the configuration files have been upgraded. Click OK to continue.

Otherwise you will end up with tm1web displaying no servers

Thursday, January 09, 2014

Deprecated and discontinued functionality in IBM Cognos TM1

Its worth being aware of this link
The two bigs ones that people should be aware of as they plan there upgrade are:

  • The Advanced Rule Editor no longer being supported in 10.2. This is a trend you will continue to see of a movement towards performance modeller for creation and maintenance. 
  • 10.2 being the last release to support CQM. If your BI reports on TM1 are not using DQM then you need to start converting them

TM1 10.2 FP1

As an early christmas present there was a release of TM1 10.2 FP1 on Dec 24th.
For more information see this link

Wednesday, January 08, 2014

TM1Web 10.2 url api

Worth noting that if you are looking to upgrade to TM1 10.2 and you use the tm1web url api then the syntax has chnaged. See here: