There are some questions about display/security settings in Perspective:
1 How to hide a Cube - not to display to a user group (besides Security Assignment - setting NONE to that group is possible)?
2 How to hide a Cube - not to display to a user group but allow them to run TIs and those TIs will retrieve data from the Cube?
Hidding a Cube in Perspective
-
- Community Contributor
- Posts: 324
- Joined: Mon Jul 02, 2012 9:39 pm
- OLAP Product: TM1
- Version: PAL 2.0.8
- Excel Version: 2016
- Location: Sydney, Australia
Re: Hidding a Cube in Perspective
I believe its the only way to hide it (correct me if I am wrong please). Security Assignment is pretty straightforward, so not sure why you wouldn't use it?There are some questions about display/security settings in Perspective:
1 How to hide a Cube - not to display to a user group (besides Security Assignment - setting NONE to that group is possible)?
TI always runs with admin rights, so by giving users read access to that TI they will be able to get data from cubes with NONE security assignment2 How to hide a Cube - not to display to a user group but allow them to run TIs and those TIs will retrieve data from the Cube?
-
- Posts: 34
- Joined: Fri Feb 28, 2014 2:21 am
- OLAP Product: TM1
- Version: 10.1.0
- Excel Version: 2010
Re: Hidding a Cube in Perspective
Thank you for your reply!EvgenyT wrote:I believe its the only way to hide it (correct me if I am wrong please). Security Assignment is pretty straightforward, so not sure why you wouldn't use it?There are some questions about display/security settings in Perspective:
1 How to hide a Cube - not to display to a user group (besides Security Assignment - setting NONE to that group is possible)?
TI always runs with admin rights, so by giving users read access to that TI they will be able to get data from cubes with NONE security assignment2 How to hide a Cube - not to display to a user group but allow them to run TIs and those TIs will retrieve data from the Cube?
So, set NONE in Cube Security Assignment and then set READ in TI Security Assignment should fulfill my needs (Cubes should not be shown in Perspective but user could execute TI Process (CELLGET & CELLPUT) via Active Form).
Addition Information - Reference:
http://www-01.ibm.com/support/docview.w ... wg21459638
-
- MVP
- Posts: 3702
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Hidding a Cube in Perspective
Well "yes" as long as you are doing something in that TI like pulling data OUT of the cube users can't see with a CellGetN and pushing data INTO a cube that users can read with CellPutN.wilsonmax wrote:So, set NONE in Cube Security Assignment and then set READ in TI Security Assignment should fulfill my needs (Cubes should not be shown in Perspective but user could execute TI Process (CELLGET & CELLPUT) via Active Form).
However quite why you would want to do this as opposed to giving users read access to the cube you want to hide in the first place is a mystery to me. If there is sensitive data in the cube that users shoudln't be able to see you would normally solve that with element or cell security. Can you elaborate on your use case as to why you would want a "data shuffling" kind of solution?
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- Posts: 34
- Joined: Fri Feb 28, 2014 2:21 am
- OLAP Product: TM1
- Version: 10.1.0
- Excel Version: 2010
Re: Hidding a Cube in Perspective
My purpose is to:lotsaram wrote:Well "yes" as long as you are doing something in that TI like pulling data OUT of the cube users can't see with a CellGetN and pushing data INTO a cube that users can read with CellPutN.wilsonmax wrote:So, set NONE in Cube Security Assignment and then set READ in TI Security Assignment should fulfill my needs (Cubes should not be shown in Perspective but user could execute TI Process (CELLGET & CELLPUT) via Active Form).
However quite why you would want to do this as opposed to giving users read access to the cube you want to hide in the first place is a mystery to me. If there is sensitive data in the cube that users shoudln't be able to see you would normally solve that with element or cell security. Can you elaborate on your use case as to why you would want a "data shuffling" kind of solution?
1) Hide the selected Cubes (stored system parameter, e.g.: export file path) from user so that he/she could not change the value in the Cube (only IT admin could change it)
2) However, user will trigger a TI to execute calculations logic and then export some reports referring to the path parameter in the above Cube
So, that's why I want to set NONE for the Cube Security Assignment, but READ for the TI Security Assignment.