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…