How to connect ActivePivot OLAP Cube in the Excel Sheet?

You can follow the given steps to get the connection string.

1. Open a new Excel sheet.
2. Click Data tab à From Other Sources à From Analysis Services.

Figure 1:Analysis Services

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

Note: When you have credentials to your SQL Server, enter the user name and password accordingly.

Figure 2: Database Server

4. Select the Cube and click Next.

Figure 3: Select the Cube

5. Finally, click Finish.

Figure 4: Save Data Connection File and Finish