TM1 Forum

Hi,
I'm trying to transfer data from Cube A to Cube B.
If I do from cell to cell it works fine (for that cell):

Cube B Cube A
['Actual','P02380','37103','MTD']=DB('CubeA','P02380','Total Consolidated','37103', 'Actual','MTD');

but as soon as I do :

['Actual','P02380','MTD']=DB('CubeA','P02380','Total Consolidated',!Period, 'Actual','MTD');

I get a syntax error (Invalid string Expression)
In Cube B the period dimension is called Period SR and in Cube A it's just Period. Dates are stored as text values eg '37103' in both.

Any insight as too how to troubleshoot this will be greatly appreciated.

Regards

You need to use the Period dimension thats in the cube that the rule exists in 'Period SR'. If there is no difference between dimensions then there shouldnt be a problem.
Invalid string Expression is comming up because TM1 doesnt recognise "!Period" as it doesnt exist within this cube.

Also just checking do you know about feeding between cubes?

Thanks Kyro...That did it

Cube B is really small, should I still be concerned with feeders?

If both cubes are 2 dimensional I probably wouldnt bother but otherwise yes I would. In most cases its best to use skipcheck and feeders. Please let me know if you need help with this.

Will do,

again thanks a million !