How to get connection string from an Excel sheet in .NET WebForms OlapGrid ?

This KB illustrates that how to get connection string from an Excel sheet.

Solution

You can follow the given steps to get connection string.

Step 1

Open a new Excel sheet.

Step 2

Click Data tab  à From Other Sources à From Analysis Services.

Step 3

The Data Connection Wizard dialog appears. Provide server name in Server Name textbox and click Next.

Step 4

Select the Cube and click Next.

Step 5

Finally, click Finish.

Step 6

Now, click the Analyze tab à Change Data Source à Connection Properties…

Step 7

The Connection Properties window appears. Select the Definition tab and copy the connection string.

You can use this connection string in your project or application, holding your OLAP control.