• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Connecting to an OLAP Cube

Now that your DBA has the company data flowing into an OLAP cube, you want to view that information. To work through the examples in this book, you can download a local version of an OLAP cube from http://www.mrexcel.com/pivotbookdata.html. Or, if your company has SQL Server 2000 and a DBA, you can ask your DBA to set up the Sales cube for the Foodmart database using MS Analysis Services. Analysis Services can be installed from the SQL Server 2000 CD. Analysis Manager contains an excellent tutorial for setting up this demo cube.

Make the Connection to a Local Cube

Select PivotTable and PivotChart Report from the Data menu. In step 1 of 3 of the wizard, select External Data Source as you did in Chapter 9 (see Figure 10.4).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint