IBM CDM User group

Check out the IBM CDM User Group and the useful videos they have:

https://ibm.biz/CDMUserGroup

TM1/CDM Best Practices from IBM Supportlink

Check out some new TM1 and CDM best practices on IBM Supportlink:

https://www-304.ibm.com/connections/blogs/basupportlink/entry/new_documents_of_interest_for_ibm_cognos_tm1_and_fpm_users?lang=en_us

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

[Scenario].[Budget{YYYY}]

This should resolve to:

Budget2014

CDM and TM1 Aliases

I have been doing quite a bit with CDM (Cognos Disclosure Management) and integrating TM1 as a datasource.
A key thing for people to be aware of is CDM requires an Alias set in TM1 called MEMBER_CAPTION.
The easiest thing to do is create the alias and then use a rule to dynamically populate the value from an existing Alias