Parameterize OLAP Report using SP

A. Set a linked server (analysis server) in your SQL Server   In the SQL Server Surface Area Configuration enable ‘Ad Hoc Remote Queries’ 1. Open SQL Surface Area configuration 2. Go to Database enginer –> Ad Hoc Remote Queries –> Set Enable OPENROWSER andn OPENDATASOURCE support   In SQL Mgmt Studio in Server Objects…

0

Dynamic Security in SSAS Cube

Technorati Tags: SSAS,Cube,Security,Dynamic Security,username,Analysis Services,SQL Analysis Services For implementing dynamic security in your SSAS cube you need make little change in the Dimension model. Steps: 1. Assuming you already have a dimension to store the employee credentials for whom you want to apply the security. If such dimension is not there then create one.In AdventureWorksDw…

12