Dimension hierarchy

Post Reply
ravi
Posts: 138
Joined: Mon Apr 26, 2010 12:39 pm
OLAP Product: cognos
Version: tm1 9.5
Excel Version: 2007

Dimension hierarchy

Post by ravi »

Hi

I am trying to move existing dimension (Accounts) hierarchy from one tm1 instance-A to another tm1 instance -B
What I did - re-created the IT process to accommodate hierarchy need in instance B. used the same IT code of Instance -A- IT process executed successfully and noticed hierarchy build looks good.

I am noticed the description (Name) and format section missing for eliments when see I under subset editor (Properties window)

Please advise.
Ravi
bplaia
Posts: 23
Joined: Fri Jun 21, 2013 5:10 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2010

Re: Dimension hierarchy

Post by bplaia »

You'll need to create the attributes and populate them on instance B with the values from instance A. Create a TI process to ASCIIOUTPUT your attribute values on instance A to a flat file and a TI process to read in the file and populate the attributes on instance B.

Or alternatively you could just copy the }ElementAttributes .cub and .dim files for that dimension into your data directory and restart the TM1 server. Be sure if any of your }ElementAttributes cubes has rules that you copy the .rux file as well.
Post Reply