Copy Hierarchical Dimension

Post Reply
lav4you
Posts: 52
Joined: Fri Jan 02, 2009 1:20 pm

Copy Hierarchical Dimension

Post by lav4you »

Hi All,

I have a requirement where I have to copy entire one hierarchical dimesion to another dimension in same order using TI.
I went through the forum and there were many post with codes to copy diemension but all were creating messy dimensions.
I want something clean and proper.
I do understand that TM1 is missing a function which can tell parent for the given element.

Following is a dimension example

All
----Country 1
---------------City1
---------------------Center1
---------------------Center2
---------------City2
---------------------Center3
---------------------Center4
----Country 2
---------------City3
---------------------Center5
---------------------Center6
----Country 3
---------------Center7
---------------Center8

I am trying to developing code for this but It would be a great help if any of you can share a TI code for above requirement if has done earlier.

Regards,
Lav
declanr
MVP
Posts: 1831
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Copy Hierarchical Dimension

Post by declanr »

lav4you wrote:I do understand that TM1 is missing a function which can tell parent for the given element.
... ELPAR


Have you tried searching the forums for this as it is quite a common query and I am certain I saw pretty much the same post not too long ago.
In addition to this I believe the bedrock site has a TI to replicate a dimension so you could take that TI and strip out the relevant parts.
Declan Rodger
User avatar
qml
MVP
Posts: 1098
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Copy Hierarchical Dimension

Post by qml »

You can go to the Bedrock webpage and download that code base. You'll find a Bedrock.Dim.Clone process there which does exactly what you need. This is of course if you'd rather just get the job done instead of learning something useful.

And TM1 might be missing a few things, but a function to get the parent of an element is not one of those things. This function is called ELPAR.
Kamil Arendt
declanr
MVP
Posts: 1831
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Copy Hierarchical Dimension

Post by declanr »

http://www.tm1forum.com/viewtopic.php?f=3&t=6556

^ Said recent post... most queries you have can be solved by quickly searching the forum.
Declan Rodger
Post Reply