}CellSecurity

Post Reply
AskAndAnswer
Posts: 21
Joined: Fri Jun 02, 2017 6:35 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

}CellSecurity

Post by AskAndAnswer » Fri Mar 16, 2018 2:54 am

Hello,

I was reviewing one of the clients' databases and ran into a }CellSecurity cube that contains several dimensions including }Groups and }CellSecurity. I am not mistaken, it's a cell security cube without _CubeName at the end. There is also a cube }DepartmentID that is used like a regular cube except it has "}" in the name.

How do you create these cubes?

Thank you.

BariAbdul
Regular Participant
Posts: 419
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: TM1,Cognos
Version: 9.5.2
Excel Version: 2007

Re: }CellSecurity

Post by BariAbdul » Fri Mar 16, 2018 6:30 am

Hi ,It is basically a control cube, please go through below links for further details:

https://www.ibm.com/support/knowledgece ... _cube.html

https://www.ibm.com/support/knowledgece ... 60ac2.html Thanks
"You Never Fail Until You Stop Trying......"

User avatar
Elessar
Posts: 148
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010
Location: Russia

Re: }CellSecurity

Post by Elessar » Fri Mar 16, 2018 7:06 am

Hello!

You can create cubes and dimensions with forbidden "}" using TI (CubeCreate and DimensionCreate functions)
Sorry for my English ;)

Wim Gielis
MVP
Posts: 1842
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

Re: }CellSecurity

Post by Wim Gielis » Fri Mar 16, 2018 11:29 am

Creation and manipulation of such control dimensions and control cubes is done in TI,
but in any case it's a good way to hide some parts of the model.
For example, lots of subsets on a certain dimension that are not to be accessed by users.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 105 TM1 articles and a lot of custom code
Newest blog article: Looping over input files

AskAndAnswer
Posts: 21
Joined: Fri Jun 02, 2017 6:35 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Re: }CellSecurity

Post by AskAndAnswer » Fri Mar 16, 2018 5:03 pm

BariAbdul, I know how to create cell security cubes, this cube is general, not created for any of the existing cubes.

Wim Gielis, thank you for the hint about TI. I understand the purpose, but not sure how it works. Is the functionality the same as if it was a CellSecurity cube without "}", and security from it should be ruled to the other cubes (I don't see any rules that refer to it), or it actually automatically applies security to all cubes that have the same dimensions?

declanr
MVP
Posts: 1590
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: }CellSecurity

Post by declanr » Fri Mar 16, 2018 8:30 pm

AskAndAnswer wrote:
Fri Mar 16, 2018 5:03 pm
Wim Gielis, thank you for the hint about TI. I understand the purpose, but not sure how it works. Is the functionality the same as if it was a CellSecurity cube without "}", and security from it should be ruled to the other cubes (I don't see any rules that refer to it), or it actually automatically applies security to all cubes that have the same dimensions?
What has happened is that a developer has created a cube via the TI function CubeCreate; they have prefixed it with a } to hide it within the control objects. The name of the cube could be absolutely anything such as }turnips.
It isn't a standard part of the security or control model but something that a previous developer in your system has decided to create, as such it may be involved with security but if it is - it is only involved in whatever way that developer set up.
TM1 will not do anything with it by default as TM1 is not expecting it to be there.
Sadly without access to your system; no one here will be able to explain what it is actually doing in the same way they wouldn't be able to tell you what any of the cubes you have created (non control ones) are doing.

AskAndAnswer
Posts: 21
Joined: Fri Jun 02, 2017 6:35 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Re: }CellSecurity

Post by AskAndAnswer » Fri Mar 16, 2018 9:31 pm

declanr, thank you. I have not seen the cubes like that, that's why I asked thinking it might be a new TM1 feature that did not exist before. Actually, a great idea that could be borrowed by IBM :). Instead of creating cell security for each cube, just have one or two that will control only main dimensions. I can see a use for it.
If it behaves like a regular cube, I have no more questions. Thank you, everyone, for your help.

Wim Gielis
MVP
Posts: 1842
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

Re: }CellSecurity

Post by Wim Gielis » Sat Mar 17, 2018 1:19 am

You can already create a cell security cube with only the relevant dimensions. But it’s one such cube for every non-control cube that needs this cell security. However what you can easily do is set up a regular cube and rule the cell security cubes to look at that small lookup cube. These cube rules code will be rather easy to copy-paste.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 105 TM1 articles and a lot of custom code
Newest blog article: Looping over input files

tomok
MVP
Posts: 2505
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: }CellSecurity

Post by tomok » Sat Mar 17, 2018 1:28 pm

If I were a betting man I would put a wager on the reason the developer created this cube was as a base cube for a bunch of other cell security cubes for cubes that share the same dimensionality. You set the security here and then rule it over to the actual }CellSecurity_XXX cubes. I have done the exact thing before, I just didn't give my cube a name starting with "}".
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

Post Reply