Articles in this section
Category / Section

How to connect ActivePivot OLAP Cube in the Excel Sheet in SIlverlight OlapChart ?

1 min read

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

  1. 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

  1. Select the Cube and click Next.

Figure 3: Select the Cube

  1. Finally, click Finish.

Figure 4: Save Data Connection File and Finish

Did you find this information helpful?
Help us improve this page
Please provide feedback or comments
Comments (0)
Please sign in to leave a comment
Access denied
Access denied