Setting Display Control Objects security

Post Reply
User avatar
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

Setting Display Control Objects security

Post by Ajay »

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
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: Setting Display Control Objects security

Post by qml »

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.
Kamil Arendt
User avatar
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

Post by Ajay »

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
David Usherwood
Site Admin
Posts: 1458
Joined: Wed May 28, 2008 9:09 am

Re: Setting Display Control Objects security

Post by David Usherwood »

I was hoping there'd be a way of not having to use the option checked.
Kind of....
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
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: Setting Display Control Objects security

Post by lotsaram »

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
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.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
tomok
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

Post by tomok »

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.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Post Reply