TM1 Performance Modeler expression syntax

[RonLat]

Hello everybody,

I’m trying to implement a consolidated-level expression on a dimension using the performance modeler 10.2.2. It works fine for simple formulas. The performance modeler creates the rules and feeders in the cube, according to the dimensional expressions. The problem is with a formula that pulls values from another cube.

The normal syntax of a rule in this case is:

Code: Select all

['ElementName']=C:DB('CubeName', !Dim1, !Dim2, !Dim3, 'ElementName');

The TM1-Funktion in the performance modeler suggests at the beginning the syntax:

Code: Select all

DB('<CubeName>')

although the correct syntax would be:

Code: Select all

DB(CubeName, e1, e2, [...e256])

I’m getting the error message “Wrong number of arguments” from the performance modeler, when I’m trying to write the expression in the column Consolidated-level Expression:

Code: Select all

DB(CubeName, Dim1, Dim2, Dim3, 'ElementName')

What syntax does the performance modeler expect in this case?

[Trevor MacPherson]

In Performance Modeler, links are the "wizard" approach to DB statements - but these can't be created in a dimension calc (N/Leaf or C/Consolidated).
You'd be able to create links if you use a Cube Calc (which I would recommend over dimension calcs almost always anyway, as they have scope), but if you already know how to write a DB though, you might want to do just that - the rule editor will parse it correctly - just create the manual rule - no harm in that.

For more info, can check out a link example here, or cube calc's here