Private views question

Post Reply
ravi
Posts: 138
Joined: Mon Apr 26, 2010 12:39 pm
OLAP Product: cognos
Version: tm1 9.5
Excel Version: 2007

Private views question

Post by ravi »

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
User avatar
Steve Rowe
Site Admin
Posts: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Private views question

Post by Steve Rowe »

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
Technical Director
www.infocat.co.uk
declanr
MVP
Posts: 1815
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Private views question

Post by declanr »

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.
Declan Rodger
User avatar
jameswebber
Community Contributor
Posts: 188
Joined: Sun Nov 21, 2010 8:00 pm
OLAP Product: Cognos Express 10
Version: CE 10.1.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Private views question

Post by jameswebber »

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.
PlanningDev
Community Contributor
Posts: 349
Joined: Tue Aug 17, 2010 6:31 am
OLAP Product: Planning Analytics
Version: 2.0.5
Excel Version: 2016

Re: Private views question

Post by PlanningDev »

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.
Edward Stuart
Community Contributor
Posts: 247
Joined: Tue Nov 01, 2011 10:31 am
OLAP Product: TM1
Version: All
Excel Version: All
Location: Manchester
Contact:

Re: Private views question

Post by Edward Stuart »

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.
amin
Posts: 10
Joined: Tue Oct 04, 2011 12:06 pm
OLAP Product: tm1
Version: 9.5.1
Excel Version: 2007

Re: Private views question

Post by amin »

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.
lotsaram
MVP
Posts: 3651
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Private views question

Post by lotsaram »

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.
amin
Posts: 10
Joined: Tue Oct 04, 2011 12:06 pm
OLAP Product: tm1
Version: 9.5.1
Excel Version: 2007

Re: Private views question

Post by amin »

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.
User avatar
jameswebber
Community Contributor
Posts: 188
Joined: Sun Nov 21, 2010 8:00 pm
OLAP Product: Cognos Express 10
Version: CE 10.1.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Private views question

Post by jameswebber »

I agree with lotsaram, in my experience you don't need to unload the cube
LutherPaul
Posts: 80
Joined: Tue Jun 04, 2013 3:35 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: Private views question

Post by LutherPaul »

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.
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Private views question

Post by Alan Kirk »

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.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
LutherPaul
Posts: 80
Joined: Tue Jun 04, 2013 3:35 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: Private views question

Post by LutherPaul »

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.
User avatar
macsir
MVP
Posts: 782
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: Private views question

Post by macsir »

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.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
lotsaram
MVP
Posts: 3651
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Private views question

Post by lotsaram »

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.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
Wim Gielis
MVP
Posts: 3103
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Private views question

Post by Wim Gielis »

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.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
User avatar
macsir
MVP
Posts: 782
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: Private views question

Post by macsir »

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.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
Post Reply