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: