Subset Security

Post Reply
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Subset Security

Post by jim wood »

Guys,

I'm pretty certain I know the answer to these questions but here goes....

1) Can you set security for subsets?
2) Can you use subsets (rather than consolidations) to control access to elements within element security via rules? (I know you can do it easily using TI)

Thanks,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Alan Kirk
Site Admin
Posts: 6667
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Subset Security

Post by Alan Kirk »

jim wood wrote: I'm pretty certain I know the answer to these questions but here goes....

1) Can you set security for subsets?
No, only elements within them. If you want to draw a longer bow than even Robin Hood could manage, you could have a TI assign security to those elements based on membership or not of the subset (which leads us to our next point below), but that doesn't affect whether the user can see the subset. For that, all you have is either public or private.
jim wood wrote:2) Can you use subsets (rather than consolidations) to control access to elements within element security via rules? (I know you can do it easily using TI)
No. In fact off the top of my head I can't think of any officially supported, non-Easter egg rule functions that you can use with subsets, primarily because it would make the rule calculations rather unpredictable and dependent on the contents of a subset at any given time which would hardly enhance TM1's reputation for reliability. It's worth noting that there is no rule equivalent of (for instance) SubNm. It could be argued (not persuasively, but it could be argued) that this is also the reason that SubsetGetElementName has such a bizarre name compared to SubNm; to emphasise the fact that "this is a TI function only and there ain't no rule equivalent.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Post Reply