TM1 Forum

Hi all,

I'd like to build the following calculation using in-cube calculation :
['calc amount']=N: [ 'amount1' ] +[ 'Total_Year', 'amount2' ] * [ 'rate1' ];

I cannot find how to do the [ 'Total_Year', 'amount2' ] ?

I'm afraid I'll have to use an import link for this.

Thank you for your help !

Hi

The syntax is fine with [ ] and ' '

[ ] is shorthand notation for the DB( ) function.

Sorry I was not clear enough. I'm trying to convert an existing rule into an in-cube calculation, the new feature of Perf Modeler.
In this editor the syntax is like : [dimName]:[elName] and I can't find a way to tell something like : [ [dimName1]:[elName], [dimName2]:[elName] ]

jeromeM wrote:Sorry I was not clear enough. I'm trying to convert an existing rule into an in-cube calculation, the new feature of Perf Modeler.
In this editor the syntax is like : [dimName]:[elName] and I can't find a way to tell something like : [ [dimName1]:[elName], [dimName2]:[elName] ]

Syntax is ['dimName':'elementName']. You can also use ['dimName':{'elementName1','elementName2','elementNameN'}] on the LHS if you have multiple targets.

Matt

I have a vague memory that the new "In cube calculation" feature of Performance Modeler has a slightly different syntax, but that it generates normal rule statements under the cover. Perhaps there is an IBMer or IBM Partner out there who is familiar with demonstrating it and can confirm or deny this.

I confirm the syntax is different in Perf Modeler in-cube calculation editor.
If it's not possible I find this really limiting.