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
Copy Hierarchical Dimension
-
- 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
... ELPARlav4you wrote:I do understand that TM1 is missing a function which can tell parent for the given element.
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
- 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
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.
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
-
- 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
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.
^ Said recent post... most queries you have can be solved by quickly searching the forum.
Declan Rodger