Analyzing Cubes using Office Client Components - Professional SQL Server Analysis Services 2005 with MDX - page 824

Figure 15-48
5. Click the Edit button to specify the connection details to Analysis
Services 2005. You will now see the Select Data Source dialog. You
will see the data source connection you established to the Adven-
tureWorks database while working with Excel Pivot tables. You can
select from one of the data sources available in this dialog or create
a new data source connection to an Analysis Services database.
Select the existing connection and click OK. In the commands and
options dialog select the cube Adventure Works as shown in Figure
15-48 . You can now close the commands and options dialog.
6. At this point you have established a connection to the Analysis Ser-
vices database and you can now analyze data within the pivot table
by dragging and dropping dimensions and measures from the pivot
table field list. You can now create your OWC pivot layout with appro-
priate protection and publish this web page to your end users.
7. You have now learnt to create web pages that include OWC pivot
tables that can be published on your IIS so that your end users can
analyze data. In the next section you will look at another product
from Microsoft called Data Analyzer that helps in analyzing data from
Analysis Services.