Security Improvements to dimension security in Analysis Services 2005 (By Mosha Pasumansky)
| Improvements to dimension security in Analysis Services 2005 (By Mosha Pasumansky) |
| Written by Mosha Pasumansky |
| Saturday, 19 May 2007 18:36 |
|
What changed with respect to dimension security in Analysis Services 2005 ? A lot ! I will try to touch on most important changes. Attribute based instead of hierarchy based.This is perhaps the most important change. The concept of UDM goes across entire Analysis Services, and dimension security is not an exception. Just like calculations in MDX are attribute based - so is dimension security. In terms of Analysis Services 2000 it means that when master dimension is secured - all of its virtual dimensions would get secured appropriately and vice versa. For example, if we secure specific member on attribute Year - automatically all months of that year, all weeks of that year, all quarters of that year etc - get also secured. This is similar to Analysis Services 2000 - when you secure the parent - all of its children get secured, but it only worked in single hierarchy. In Analysis Services 2005 - all hierarchies: Year-Quarter-Month, Year-Week, Year-Month etc will get secured accordingly. |
Top Rated
- SSAS Implementation Best Practices slides in PDF format
- SSRS Report Against a SSAS Parent Hierarchy
- Handling inter-dimensional members dependency and reducing cube sparsity using reference dimensions in Analysis Services 2005
- Cube structure optimization for MDX query performance in Analysis Services 2005 SP2: Tips for Parent Child Hierarchies usage
- Handling Multiple Calendars with a M2M Scenario
- Passing MDX parameters in Reporting Services reports
- Using UserName to Control Data Access and Default Member in SSAS 2K5 (Carrie Williams)
- SSAS Tutorial: SQL Server 2005 Analysis Services Tutorial by Accelebrate
