Hello All
Does any know of where security can be set to allow a certain group, access to the Control Cubes, similar to using the menu command "View\Display Control Objects" ?
I am trying to accomplish this via TI and I had - rather optimistically - thought the }Capabilities cube might contain something I could grant to, but alas no.
In essence the scenario I have is that I have created a pseudo admin role with limited functions, but need to grant access to a very small number of control cubes, which will be present only via the "Applications" folders.
Any help, or alternate thoughts welcome.
Cheers
Ajay
Setting Display Control Objects security
- 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: Setting Display Control Objects security
Control cubes are listed in the }Cubes dimension, therefore you can control access to them via cube security, just like you would for any other cube. The }CubeSecurity cube will get created once you make the first manual Group/Cube assignment (Cubes > Security Assignments in Architect). Alternatively, you can create it in TI if you like. Once it's there you can write directly to it and give every group one of the standard levels of access (NONE, READ, WRITE, RESERVE, LOCK, ADMIN) to each cube.
Of course, if users are to see in Server Explorer any objects whose names are prefixed with the '}' character, they will still have to have the 'Display Control Objects' option checked.
Of course, if users are to see in Server Explorer any objects whose names are prefixed with the '}' character, they will still have to have the 'Display Control Objects' option checked.
Kamil Arendt
- Ajay
- Regular Participant
- Posts: 183
- Joined: Wed May 14, 2008 8:27 am
- OLAP Product: TM1
- Version: 10.2.0, PA 2.0.9
- Excel Version: 2016
- Location: London
Re: Setting Display Control Objects security
Thanks Kamil
re: first paragraph.....yep, did all that
re: second paragraph.....bummer !!!! I was hoping there'd be a way of not having to use the option checked.
Cheers anyway
Ajay
re: first paragraph.....yep, did all that
re: second paragraph.....bummer !!!! I was hoping there'd be a way of not having to use the option checked.
Cheers anyway
Ajay
-
- Site Admin
- Posts: 1458
- Joined: Wed May 28, 2008 9:09 am
Re: Setting Display Control Objects security
Kind of....I was hoping there'd be a way of not having to use the option checked.
I have placed views of control cubes (Performance Monitor cubes in particular) into application folders, and they remain available with View Control Objects unticked.
HTH
-
- 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: Setting Display Control Objects security
This is also what I do and transport the application folder shortcuts to each new project). Its a handy way of being able to always reference the commonly needed control objects without needing view control objects option checked. Unfortunately the trick works only with views, if you drag a shortcut to a control cube into an application folder it won't be visible without the view control objects option ticked, even if the shortcut is renamed.David Usherwood wrote:I have placed views of control cubes (Performance Monitor cubes in particular) into application folders, and they remain available with View Control Objects unticked.
HTH
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- 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: Setting Display Control Objects security
Another option is to create a simple Active Form report off the control cubes in question. If you have writeback enabled they can use the report to make changes.