How to create a dimension exported from another dimension

[plkkw]

Hi,

I want copy a dimension from another dimension. I use Turbo Integrator. I export a dimension months (with hierarchy: year -> quarter -> months), and then use TI to load the cma into a new dimension. However, i found the result is wrong.

How can I copy a dimension in TM1?

[rmackenzie]

The format of the .cma file isn't parent/ child pairs which it seems that you expect given the configuration of your TI process and the resulting dimension structure.

Where the first field contains an 'N', it indicates that the element in the second field is a leaf-level element and where the first field contains a 'C' it indicates that the element in the second field is a consolidation. Where the first field is blank, you are looking at an item in a list of children of some consolidation. In fact, the output is useful if you are trying to make an .xdi template (Excel worksheet for a dimension).

There are a number of threads that deal with export of dimensions - here is a recent one that has some sample code to export a dimension to child/ parent pairs.

[plkkw]

Hi rmackenzie,

Do you mean that I should 1) export dimension (month), 2) use the program you given to export month hieriacrhy?

And then use TI to 3) load "cma" file generated in step 1, and 4) use TI to load month hierarchy generated in step 2?

[rmackenzie]

The script that Kavee posted in the other thread will export the dimension in a way that it will be easier for you to re-import it.

If you use the .cma file with that format, I don't think you can easily re-import it with TI, but you could create an .xdi template.

Actually, what I wrote was more in the way of advice rather than a step-by-step solution...

[mikko]

Hi plkkw,

check BEDROCK TI VERSION 1.0 ZIP from http://bedrocktm1.org/. There is a bunch of great TI scripts, including, for example, a script to clone/copy dimension.

-Mikko