19/07/2007 4:12:16 PM
Analysis Services Security
In this session, Richard will walk through and demonstrate the security options available with Analysis Services including datasource, cube, cell level, contingent, read/write, dimension and dimension member security.
Microsoft SQL Server Analysis Services has many security features to protect OLAP/ROLAP data from reading and writing. Some of these features offer useful ways to simplify reporting and analysis needs.
For example, in the old days, reporting systems often had to create multiple sets of reports. One set of reports for each geography, another set for each level of the management hierarchy, and sometimes another set for the intersection of these two sets.
Nowadays, OLAP security allows you to create one report for which different users see different sets of data based on their security rights. These are features that, in a practical sense, are not available from relational databases.
About Richard Lees
Richard Lees is the Managing Director of EasternMining, http://EasternMining.com.au He is well known around the world as the author of ThinSlicer. Richard has been a database specialist for over 20 years and an OLAP specialist for 10 years. He was employed by Microsoft as a BI specialist for 9 years. Richard has made available many OLAP demonstrations on http://RichardLees.com.au/Demonstrations
Venue: Mechanics' School of Arts, Level 1, 280 Pitt St, Sydney |
Duration 5:30pm Share Ideas, Network with your Peers (with Pizza & Drinks), 6:00pm until 8pm Session |
On: Wednesday, 12 September 2007