subset to dimension using t1 process

Post Reply
kalyan846
Posts: 18
Joined: Fri Mar 06, 2020 4:48 pm
OLAP Product: Cognos TM1
Version: 10.2
Excel Version: office 365

subset to dimension using t1 process

Post by kalyan846 »

Hi, please dont mind if it a silly Question,
In a dimension i have a dynamic subset, which i want to transfer same structure into another dimension
but that subset is having rollups.
i want the same structure into dimension,via ti process

Can any one help me please........
ascheevel
Community Contributor
Posts: 314
Joined: Fri Feb 15, 2013 5:49 pm
OLAP Product: TM1
Version: PA 2.0.9.1
Excel Version: 365
Location: Minneapolis, USA

Re: subset to dimension using t1 process

Post by ascheevel »

You can iterate through a subset using a WHILE loop and SubsetGetElementName. You can then add the returned name from SubsetGetElementName to the subset in your target dimension using SubsetElementInsert.
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: subset to dimension using t1 process

Post by tomok »

ascheevel wrote: Thu Apr 09, 2020 5:50 pm You can iterate through a subset using a WHILE loop and SubsetGetElementName. You can then add the returned name from SubsetGetElementName to the subset in your target dimension using SubsetElementInsert.
OP is wanting to create a new dimension out of the subset of an existing dimension, hierarchy and all. Take a look at Bedrock. I believe it has a process that does this.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
ascheevel
Community Contributor
Posts: 314
Joined: Fri Feb 15, 2013 5:49 pm
OLAP Product: TM1
Version: PA 2.0.9.1
Excel Version: 365
Location: Minneapolis, USA

Re: subset to dimension using t1 process

Post by ascheevel »

Thanks Tomok, looks like I misread. There is indeed a bedrock process that will clone a dim from a subset. If OP is on 10.2 as their profile suggests, I think it'd be this process: Bedrock.Dim.CloneFromSubset
Post Reply