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 » Fri Aug 17, 2012 6:50 am

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: 2173
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: Private views question

Post by Steve Rowe » Fri Aug 17, 2012 7:58 am

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: 1709
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 » Fri Aug 17, 2012 8:00 am

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 » Fri Aug 17, 2012 10:53 am

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: 343
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 » Sun Aug 19, 2012 3:36 am

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: 241
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 » Mon Aug 20, 2012 4:21 pm

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 » Tue Aug 21, 2012 3:22 am

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: 3492
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 » Tue Aug 21, 2012 7:13 am

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 » 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.

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 » Tue Aug 21, 2012 8:54 am

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 » Mon Nov 23, 2015 4:06 pm

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: 6364
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.6 Classic(PAW-free zone)
Excel Version: 2010 and Office 365
Location: Sydney, Australia
Contact:

Re: Private views question

Post by Alan Kirk » Mon Nov 23, 2015 9:12 pm

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 » Wed Dec 02, 2015 10:18 pm

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

lotsaram
MVP
Posts: 3492
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 » 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.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

Wim Gielis
MVP
Posts: 2689
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.8
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Private views question

Post by Wim Gielis » Wed Apr 28, 2021 10:17 am

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

Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 117 TM1 articles and a lot of custom code
Newest blog article: Avoid circular references https://github.com/wimgielis

User avatar
macsir
MVP
Posts: 757
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 » Wed Apr 28, 2021 8:33 pm

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