TM1 Forum

Hi

Need your suggestions.

One of our tm1 user have created many of private views and subsets. We need to transfer these views and subsets to another user- who is taking over his roll.

I had suggested the user to recreate the views and subsets for new user or slice reports and send them to him.

But this seems be diffecult as he has create all them -is consume more time.

Please advise
Ravi

I think pretty much your only option is to copy the files on the disc, I seem to remember that this can be done without restarting the server and objects will be available when the other user logs in.

Cheers

http://www.bedrocktm1.org/resources/fil ... blish.html

This allows view to be made public but I seem to remember not really liking it for some reason...

If you just want to copy to one user or indeed if you do want to make public I would still probably go with Steve's method and copy and paste in the directorys.

I have played with TI to do this but in the end the following was simpler

1. Goto the tm1 server and look up the user logon
e.g. \\<servername>\C$\TM1\Data\<source_user>\GL}vues
2. Copy the view file you need
e.g. JW_MarginData.vue
3. Paste in in your own user directory with the same name
e.g. \\<servername>\C$\TM1\Data\<Target_user>\GL}vues
4. Log out of TM1 and log back in

This does work fine.

Steve is correct. You will have to copy the files if you want the views to stay private. You can publish private views and make them public however, if the user had any private subsets for any dimensions in the view you would also need to make those public or copy the private subsets as well.

Additional points to note:

- if the user has any custom Rollup's (}ROLLUP_000) then you will not be able to replicate the view (you cannot copy over custom rollups)
- if the new user already has saved views then these could be overwritten during this process (e.g. both have a view named "Profit and Loss")

It starts getting messy when you have multiple instances/ cubes/ views but as James has said, the easiest way is to manually copy

You could use a TI to create a batch file which copies all *.*}vues folders/ files from UserA to UserB but you run the risk of overwriting views/ subsets as mentioned above.

I have played with TI to do this but in the end the following was simpler

1. Goto the tm1 server and look up the user logon
e.g. \\<servername>\C$\TM1\Data\<source_user>\GL}vues
2. Copy the view file you need
e.g. JW_MarginData.vue
3. Paste in in your own user directory with the same name
e.g. \\<servername>\C$\TM1\Data\<Target_user>\GL}vues
4. Log out of TM1 and log back in

This does work fine.

Just to add, ensure to unload the cube to make it appear in the list.

amin wrote:Just to add, ensure to unload the cube to make it appear in the list.

No. I don't know where you get this idea. Private objects are all loaded to RAM and registered on the server from the disk copy when the user logs in and are destroyed on log out. All that is needed to see a new private subset, view or application entry created from file copy is for the user to log back in. The only time you hit an issue with the file copy approach is where
- a private view also uses a private subset and the subset isn't copied
- due to difference in security the "target user" doesn't have any access to elements selected for the view in one or more dimensions
In either of these cases unloading the cube isn't going to help either.

I can't speak for others but I always had to unload the cube in order to see it. Unless I do that I don't see it.

I agree with lotsaram, in my experience you don't need to unload the cube

Hi All,
Copying files / folders works is some cases and does not for some reason.

We are using TM1 10.2.2 with CAM security. I tried on test models and it works well but not on the main model. Where could I have gone wrong? Any help is greatly appreciated.

Thanks,
Paul.

LutherPaul wrote: Copying files / folders works is some cases and does not for some reason.

We are using TM1 10.2.2 with CAM security. I tried on test models and it works well but not on the main model. Where could I have gone wrong? Any help is greatly appreciated.

You've given no information about how you're doing this copying, much less the actual code used. No information on how the copy is initiated. No information about whether the files just aren't copying (and whether you've manually checked the target folders to determine this), or whether the copy process is generating an error and if so what that error is. No information about how you're identifying the paths that you're using to specify the source and target paths for the files, and whether you've checked that this has been correctly updated when you move between models.

I think you may be a tad optimistic in hoping for anyone to provide a solution in the circumstances.

Hi Alan.

The scenario that worked was on the sample SDATA model. Copied cube View from
‘\\<servername>\D$\TM1\Data\<source_user>\GL}vues’ to
‘\\<servername>\D$\TM1\Data\<Target_user>\GL}vues’.

When I copied views for one of our models from one user to another, views do not show up on the target users list. No errors reported either.

Thanks,
Paul.

amin wrote: ↑Tue Aug 21, 2012 7:38 am I can't speak for others but I always had to unload the cube in order to see it. Unless I do that I don't see it.

Hi, thanks for that. I can confirm unloading the cube did the trick in PAL 2.0.9.4 using CAM without rebooting the server. The private views don't have private subsets at all. I just copied view files into the target user folder.

macsir wrote: ↑Wed Apr 28, 2021 3:00 am

amin wrote: ↑Tue Aug 21, 2012 7:38 am I can't speak for others but I always had to unload the cube in order to see it. Unless I do that I don't see it.

Hi, thanks for that. I can confirm unloading the cube did the trick in PAL 2.0.9.4 using CAM without rebooting the server. The private views don't have private subsets at all. I just copied view files into the target user folder.

Interesting. This thread is years old but I always found that logging out as the user where private objects had been copied to and logging back in was always sufficient for the user to be able to access the private objects.

lotsaram wrote: ↑Wed Apr 28, 2021 8:13 am Interesting. This thread is years old but I always found that logging out as the user where private objects had been copied to and logging back in was always sufficient for the user to be able to access the private objects.

The same for me. I never did an Unload cube in this respect.

lotsaram wrote: ↑Wed Apr 28, 2021 8:13 am

macsir wrote: ↑Wed Apr 28, 2021 3:00 am

amin wrote: ↑Tue Aug 21, 2012 7:38 am I can't speak for others but I always had to unload the cube in order to see it. Unless I do that I don't see it.

Hi, thanks for that. I can confirm unloading the cube did the trick in PAL 2.0.9.4 using CAM without rebooting the server. The private views don't have private subsets at all. I just copied view files into the target user folder.

Interesting. This thread is years old but I always found that logging out as the user where private objects had been copied to and logging back in was always sufficient for the user to be able to access the private objects.

I did try to log out and log back in (including refreshing objects and admin hosts) but the private views never show up until I unloaded the cube and refresh it again.