Data Loading between two cubes

[Krish]

Folks,

I have 2 cubes which are having same dimensions and one cube having another extra dimension. All measures are same in both measure dimensions.

Cube 1:

Dim: A,B,C,D,E

Cube 2:

Dim: A,B,C,D,E and F (extra dim)

Requirement : I should first load the data into Cube 2 and once it done, Cube 1 should take the data from Cube 2 and update it. So that i can avoid the data loading into Cube 1 separately.

Please let me know if any script available for this to achieve, and let me know the process steps to follow. Thanks

[tomok]

Requirement : I should first load the data into Cube 2 and once it done, Cube 1 should take the data from Cube 2 and update it. So that i can avoid the data loading into Cube 1 separately.

Why would you want to "avoid the data loading into Cube 1"? Is the source of the load into Cube 2 a relational source? if so, then it would be much easier to modify the SQL query to "get rid of" the breakdown of the extra dimension in Cube 2 (by using GROUP BY) and then having a separate TI process to load into Cube 1. Loading relational into Cube 2, and then loading into Cube 1, from Cube 2, is a lot more work. However, if you are hell bent on doing it then read the documentation about Ti processes. There are plenty of examples in there. No need for anyone to spoon feed you.

[asutcliffe]

Requirement : I should first load the data into Cube 2 and once it done, Cube 1 should take the data from Cube 2 and update it. So that i can avoid the data loading into Cube 1 separately.

Do you really need the data in two cubes that are so similar? It sounds a bit redundant to me.

In any case, If you already have a TI process that loads the data to cube 2, you could quite easily add another line on the data tab to write the data to cube 1 also. You'll want to increment the values as you load them though.

Of course you could also write a simple rule in cube 1 to do the same and feed it from cube 2.

Please let me know if any script available for this to achieve, and let me know the process steps to follow. Thanks

I'd suggest that either of approaches I've outlined should be pretty straightforward to implement. I'm happy to help if you get stuck.