APPLIES TO: 2013 2016 2019 SharePoint Online
-->
In MS Excel 2007 on PC you can connect to a MS Analysis Services Cube via Excel. I can't see how to do the same on Mac using Excel 2008 there. Does anyone know how to access the OLAP cube data on. In this situation, you might consider converting your PivotTable to a formula-based report using Excel 2016's new Cube-based functions.
You can use Excel to create OLE DB or ODBC connections and then share those connections with others. An OLE DB or ODBC connection is useful for connecting to data sources, such as Excel workbooks, legacy databases, or non-Microsoft databases. When you can upload a data connection to an Excel Services trusted data connection library in SharePoint Server 2013, the data connection is available for you and others to use to create data models, reports, scorecards, and dashboards. Depending on the particular data source that is used, people can easily refresh data in Excel Services workbooks so that the most current information is displayed.
Before you begin
Before you begin this task, review the following information about prerequisites:
Step 1: Use Excel to create OLE DB or ODBC data connections
You can use Excel to create an OLE DB or ODBC connection. This enables you to connect to lots of different data sources. Examples include Microsoft SQL Server, Microsoft Access, and Oracle databases, although there are many others. You can create an OLE DB or ODBC data connection by using one of several methods:
Use the following procedures to create OLE DB or ODBC data connections
To create a connection by using the Data Connection Wizard in Excel
If cannot create the connection that you want by using the Data Connection Wizard in Excel, you can try to create the connection by using a Microsoft Query wizard. This is useful for connecting to older databases. However, the connection that you create might not be supported in Excel Services. Contact a SharePoint administrator to verify that the connection that you create is supported so that people can refresh data in Excel Services files. The following procedure describes how to create a connection by using a Microsoft Query wizard.
To create a connection by using a Microsoft Query wizard in Excel
By default, the data connection is saved in the My Data Sources folder in the Documents library on your computer.
Step 2: Upload data connections to SharePoint Server
After data connections are created, the next step is to upload it to a data connection library. We recommend that you use a Business Intelligence Center site to store and manage business intelligence content, such as data connections.
Note
If you are not using a Business Intelligence Center site, make sure that you use a data connection library that is specified as a trusted location in Excel Services. For more information, see Manage Excel Services trusted data connection libraries (SharePoint Server 2013).
To upload a data connection to SharePoint Server
See alsoConceptsComments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |