OLAP Excel Reports

After you create a data warehouse and its OLAP cube, you can conduct complex reporting and analysis on data from the program. To manipulate subsets of data from the OLAP cube in spreadsheets, you can use the Microsoft Excel report templates to create workbooks in Excel.

The workbooks copy a subset of data from the OLAP cube, and you can manipulate the data in the spreadsheets to create complicated reports that take advantage of the cube’s multidimensional view of the data. To create Excel reports from the OLAP cube, go to Analysis and select OLAP Excel reports. The Excel Report Templates screen appears.

On this screen, you select a template from the hierarchy. A description appears under Template Information. To create a workbook based on the template, select Create Workbook. The Save Excel Workbook screen appears. After you save the workbook, you can create spreadsheets in Excel and manipulate the subset of data from the OLAP cube that is associated with the template. For information about how to create reports in Excel, see the Microsoft Excel help file.

Note: If you run a local copy of Excel against a remote OLAP server, you must connect to the cube over HTTP. To supply the URL for the OLAP Excel Reports feature to use in the connection string, see Edit HTTP Data Source URL.