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

Parameterize the OLAP Reports in Client Applications

In this post let’s see how you can pass the parameters into your OLAP report. The parameters have to be passed dynamically through the WinForm application. Here we will NOT be using the report parameters which you would have added on the report at the design time. The report is displayed through report control in…

1