Transfer Data between Cubes (newbie to rules)

[Tiger]

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

[Kyro]

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?

[Tiger]

Thanks Kyro...That did it

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

[Kyro]

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.

[Tiger]

Will do,

again thanks a million !