Page 1 of 1

subset to dimension using t1 process

Posted: Thu Apr 09, 2020 5:33 pm
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........

Re: subset to dimension using t1 process

Posted: Thu Apr 09, 2020 5:50 pm
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.

Re: subset to dimension using t1 process

Posted: Thu Apr 09, 2020 7:35 pm
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.

Re: subset to dimension using t1 process

Posted: Thu Apr 09, 2020 7:43 pm
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