Merge two dimensions into one dimension

[yingchai]

Hi,

I am a newbie in TM1. Currently, I am trying to understand on what function to use to merge dimensions from BEDROCK TI VERSION 3.0 guide. But still I don't know how to start as the TI editor got few tabs (prolog, metadata, data, epilog...)

I was hoping that I can fully utilize the TI functions (Eg; Bedrock.Dim.Clone) from Bedrock in this exercise.

Let's say I have 2 separate dimensions as per listed in attachment.
(note: this sample is taken from sunitha's thread)

My ultimate aim is to create a new Dim C and merge the 2 dimensions into something like this:

Code: Select all

[code]
Total CC  //Total CC is the top most consolidated level for Dim C
---FIN
---ICT

[/code]

Appreciate if someone can assist / guide me.

[BariAbdul]

This might help,there is an excellent reply by TM1 guru Alan Kirk:
http://stackoverflow.com/questions/1920 ... -a-new-one

Hope it helps.Thanks

[David Usherwood]

If it's a one-off, do the following:

a Open the first dimension in the dimension editor and Save As the new dimension
b Open the second dimension in the subset editor, select the structures you want, copy and paste as in the new dimension
c Adjust the top structures to taste

Not that tough really.