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........
subset to dimension using t1 process
-
- 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
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.
-
- 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
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.
-
- 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
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