How to change cube view for user?

Post Reply
JLL
Posts: 3
Joined: Tue Sep 22, 2015 9:36 am
OLAP Product: TM1
Version: 10_2_2
Excel Version: 2010

How to change cube view for user?

Post by JLL »

I have changed the cube public view to adjust the default year into the current year. However it works only for administrators, not for the users if the users select the public views from the cube dropdown list. In the meantime, After I changed the public views from the server explorer, the user could see the new default year as the current year from the changed views if he opens the public view from the server explorer tree.

Do you have any idea why it doesn't work for view if the user select the public view from the dropdown list in the application cube? :roll:

Thanks in advance!
User avatar
qml
MVP
Posts: 1097
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: How to change cube view for user?

Post by qml »

The users probably have private subsets on the year dimension that have the same name as the public subset you are using in your view. In such cases private subsets take precedence over public ones.
Kamil Arendt
lotsaram
MVP
Posts: 3704
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: How to change cube view for user?

Post by lotsaram »

qml wrote:The users probably have private subsets on the year dimension that have the same name as the public subset you are using in your view. In such cases private subsets take precedence over public ones.
With the caveat that for Contributor/Application Web (and by extension I believe TM1 Web also) that public views and subsets take precedence.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
JLL
Posts: 3
Joined: Tue Sep 22, 2015 9:36 am
OLAP Product: TM1
Version: 10_2_2
Excel Version: 2010

Re: How to change cube view for user?

Post by JLL »

Actually the users have selected the public views(not the private one).
JLL
Posts: 3
Joined: Tue Sep 22, 2015 9:36 am
OLAP Product: TM1
Version: 10_2_2
Excel Version: 2010

Re: How to change cube view for user?

Post by JLL »

Thanks for your reply. However the users have no private subsets. It is very strange in this matter: I made a test on one user. If he gets Admin authentication, he could see the changed public view with the default year as current year("2016"). After I take his Admin authentication away, he sees "All Year" as default year for the same public view. These happens when he open the public view from the cube view dropdown list. If he opens the public view from the server explorer tree, he will see the changed public view with the default year as 2016.

Could anybody tell me why?

Thanks in advance!
User avatar
Steve Rowe
Site Admin
Posts: 2464
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: How to change cube view for user?

Post by Steve Rowe »

I think this could be the way the subset is saved, although I had thought this behaviour had changed.

When you save the public subset, in the background it will say something like "show the 5th element the user can see". As the admin and seeing the whole subset you see 2016.
When a user opens the subset and because of the security their "show the 5th element the user can see", is showing "All Years", since they can not see all the elements of the year dimension.

Try defining the default subset with MDX and see if the problem continues.

HTH
Technical Director
www.infocat.co.uk
dharav
Regular Participant
Posts: 193
Joined: Wed Apr 02, 2014 6:43 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2010

Re: How to change cube view for user?

Post by dharav »

IF you have changed the public view to current year after saving in to public subset than user should able to see the change in TM1 web. If you are
operating through contributor applications than you should re-deploy the application and check whether user able to see current year in the public view
or not.
Post Reply