I have a websheet that allows end users to add elements to a dimension. This process works fine but the issue is that I also have security to the elements in the dimension being dynamically set through a rule. After a user hits the action button to submit the element to the dimension they cannot see the element untill security has been refreshed. I added the SecurityRefresh command to my process but it failed stating that the end user did not have access to SecurityRefresh.
Is there a different way to go about this? Or some way to trigger the update of the security cube for the dimension?
End User Dimension Edit
-
- Community Contributor
- Posts: 349
- Joined: Tue Aug 17, 2010 6:31 am
- OLAP Product: Planning Analytics
- Version: 2.0.5
- Excel Version: 2016
-
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: End User Dimension Edit
In Server Explorer right-click on the Process and make sure Security Access is checked. That should fix your problem with SecurityRefresh.
-
- Community Contributor
- Posts: 349
- Joined: Tue Aug 17, 2010 6:31 am
- OLAP Product: Planning Analytics
- Version: 2.0.5
- Excel Version: 2016
Re: End User Dimension Edit
That worked! I forgot to recheck that item when I moved the model from DEV to PROD.
Thanks
Thanks