SSAS Articles 
Security Dimension Security in Analysis Services 2005 (by Richard Tkachuk)
Security Dimension Security in Analysis Services 2005 (by Richard Tkachuk)
| Dimension Security in Analysis Services 2005 (by Richard Tkachuk) |
| Written by Richard Tkachuk |
| Tuesday, 01 May 2007 15:31 |
|
Analysis Services 2005 has two security models for securing data: dimension security and cell security. Dimension security is used to permit or deny access to members of a dimension and any data associated with those members. Cell security permits or denies access to cell values only. For example, consider the example of a cube containing a customers dimension with a country attribute hierarchy and two measures, sales and expense. |
Latest Author Articles
- Handling Begin and End Times in SQL Server Analysis Services 2008
- IIF Function Query Hints in SQL Server Analysis Services 2008
- Richard Tkachuk discusses the SQL CAT team, working with Analysis Services
- Querying Dimension Members In Analysis Services
- Reverse Running Sums and Set Aliases (by Richard Tkachuk)
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
