I can see the alternate hierarchy is in }DimensionSecurity cube. I thought I can put some securities on them but apparently it doesn't work in PAW. Users with NONE access can still see and use the hierarchies normally. As long as the user has READ access on dimension, then he can use alternate hierarchy without any issue. I tested the case and seems to work in this way.
Is there a way to control security on alternate hierarchy?
Security on Alternate Hierarchy?
- PavoGa
- MVP
- Posts: 617
- Joined: Thu Apr 18, 2013 6:59 pm
- OLAP Product: TM1
- Version: 10.2.2 FP7, PA2.0.9.1
- Excel Version: 2013 PAW
- Location: Charleston, Tennessee
Re: Security on Alternate Hierarchy?
A shot in the dark here, but have you tried applying security to the }Hierarchies_dimname dimension?
Ty
Cleveland, TN
Cleveland, TN
- macsir
- MVP
- Posts: 782
- Joined: Wed May 30, 2012 6:50 am
- OLAP Product: TM1
- Version: PAL 2.0.9
- Excel Version: Office 365
- Contact:
Re: Security on Alternate Hierarchy?
Thanks, yes, I have tried and TM1 actually created that security cube for me but still doesn't work. According to IBM's reply, it hasn't been implemented yet but on their roadmap.