TM1 Forum

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

dharav9 wrote: ↑Tue Oct 15, 2019 9:28 pmSave 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, ...)