TM1 Forum

Hi,

I have 2 cubes:
Cube 1 with the below dimensions:
. !Currency
. !Site
. !Version
. !Month_Year
. !Conso
. !Cost Center
. 'Value'

Cube 2 with the below dimensions:
. !Currency
. !Site
. !Version
. !Month_Year
. !Simulation
. !Cost Center
. 'Value'

I have created an attribute (named Simulation) of the dimension !Conso (from Cube 1) to map the elements with the elements of the dimension !Simulation (from Cube 2).

I then wrote the below rule:
['Value'] = N: DB(Cube1, !Currency, !Site, !Version, !Month_Year, ATTRS('Conso', !Conso, 'Simulation'), !Cost Center, 'Value');

I have an error message saying there is a "syntax error on or before !Conso, 'Simulation' invalid string expression".
Has anybody an idea where the issue is coming from ?

Thanks in advance.

Presumably your rule is in cube 2; the error is telling you that the dimension "conso" doesn't exist in cube 2 so can't be used as a dynamic reference.

You need to put an attribute on the "Simulation" dimension instead that maps the other way and do an ATTRS on that.

Thanks for your answer.
I thought it could be a solution but what if I wanted to map 2 elements of the dimension !Conso to 1 element of !Simulation. I wanted them to add each other ?

Consolidation in source.

It works, thanks for your answers.