How to connect ActivePivot OLAP Cube in the Excel Sheet ?
You can follow the given steps to get the connection string.
- Open a new Excel sheet.
- Click Data tab à From Other Sources à From Analysis Services.
Figure 1:Analysis Services
- 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
- Select the Cube and click Next.
Figure 3: Select the Cube
- Finally, click Finish.
Figure 4: Save Data Connection File and Finish