Page 1 of 1

How to change cube view for user?

Posted: Wed Mar 16, 2016 4:52 pm
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!

Re: How to change cube view for user?

Posted: Wed Mar 16, 2016 5:40 pm
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.

Re: How to change cube view for user?

Posted: Thu Mar 17, 2016 12:29 am
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.

Re: How to change cube view for user?

Posted: Thu Mar 17, 2016 9:44 am
by JLL
Actually the users have selected the public views(not the private one).

Re: How to change cube view for user?

Posted: Mon Mar 21, 2016 12:42 pm
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!

Re: How to change cube view for user?

Posted: Mon Mar 21, 2016 2:08 pm
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

Re: How to change cube view for user?

Posted: Tue Mar 22, 2016 2:06 pm
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.