SQL Server Analysis Services 2005/2008 articles,blogs,scripts,FAQs,tools,books

Summary: How to use UserName to limit access to data in SSAS and set the Default Member. We will modify the Adventure Works SSAS cube to demonstrate the use of UserName.

Contents

Introduction
Definition of UserName Function
Overview of the Employee Dimension Table
Overview of the Employee SSAS Dimension
Modifying the Employee SSAS Dimension
Add Dimension Level Security to a Role
Results Demonstrated in ProClarity (How to Test)
Conclusion

Introduction

This paper will discuss how to use the UserName function to restrict data access and control the default member in SSAS 2K5. To most effectively demonstrate the topic being addressed we will refer to the Adventure Works cube and discuss the modifications necessary. The Adventure Works cube is provided in the installation package of SQL Server 2K5.

Read more...