Combining dimensions

[rcoppa]

Hi there,

I currently have two account dimensions, PL and BS, in 2 separate cubes, also PL and BS.

I am currently consolidating them into one Master cube. Is there an easy way to create a new dimension which is a merged copy of these two dimensions?

Thanks in advance.

[David Usherwood]

Sure.
Open a new dimension editor window
Open a subset editor window for P&L, reset to all, sort by hierarchy, select all, copy and past to the dim window.
Repeat for BS and save.
You won't get your attributes and aliases. You can copy and paste them in the hidden attribute cubes, or write a rule to link them across.
HTH

[Steve Rowe]

Probably the easiest way is to us dimension worksheets

1. Right click on each dimension and select export as ASCII
2. Open the .cma files, you will see that the information is in dimension worksheet format.
3. Create the new dimension (TM1, Dimension worksheet, new)
4. Copy and paste both sets of information into the new worksheet
5. Save the worksheet (Dimension worksheet,save).

The only thing to watch out for is duplicates that are different things in the two dimensions.

You could also do what you want with TI but it be much more long winded.
You can also copy and past in the dimension and subset editors.

1. Create the new dimension (In SE right click on dimension and select New
2. Open the subset editor for P and L and hit All and expand all
3. Copy and paste into the new dim editor.
4. Repeat for BS dim.

HTH

[rcoppa]

thanks guys.