You can use the following procedure to view Excel workbooks that connect to OLAP data cubes by using the Analysis Library node in the Reporting workspace. Workbooks are saved to the Analysis Library by Service Manager so that report users can easily access them.
To use the analysis library
In the Service Manager console, click Reporting, expand the Analysis Library node, and then navigate to the folder that contains an Excel workbook that you want to open.
Select the Excel workbook that you want to open and then in the Tasks list, click Open Excel File.
In the Excel workbook, you can refresh the data from the data warehouse. For example, if you are using Excel 2010, you can click the Data tab and then click Refresh All to update the workbook.