Copy Personal subset of users to a clone dimension

[dharav9]

Hi, All

I would like to copy the personal subset of users for company dimension to clone_company dimension.
We have 500 users. I know we can do it manually by following steps as below:
Data Directory => AD=> User Profile=> company}sub => copy this folder and paste it with clone_company}sub =>Copy subset from company}sub and paste in to clone_company}sub => open each subset file and replace "company" with clone_company => in line change the character length of MDX => Save it => Restart the server.

Is it possible to manage this process through TI? Anyone tried it.

FYI : I am using bed rock process to clone the dimension but it does not bring the personal subset from source dimension.

Please feel free if you require further information.

Thank You
Dharav

[Wim Gielis]

Save it => Restart the server.

Restarting the server is not needed. The user just needs to log out and log in again. Or log in if he/she is not logged in when the process runs.

I have never done this myself but I would go for a TI process that executes a PowerShell script, which contains logic for copying / adjusting subset files. Instead of PowerShell, other scripts could be possible too (Perl, VB, ...)