TM1 Forum

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:
The TM1-Funktion in the performance modeler suggests at the beginning the syntax: although the correct syntax would be: 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: What syntax does the performance modeler expect in this case?

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