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

Connecting to OLAP Data

Before you can work with OLAP data, you need to connect to it. Connecting to OLAP data with Microsoft data analysis software is very similar to connecting to other types of data; the only difference is that you connect to data that resides in a cube on an OLAP database server computer or in an offline cube file. To connect to an OLAP database, you need to know the OLAP server name, the OLAP database name, and the OLAP cube name. To connect to an offline cube file, you need to know the path to the offline cube file. Although OLAP data cubes can be built from any data source, including Oracle, DB2, and mainframe systems, in the examples in this chapter, we’ll assume that cubes are stored on computers running Microsoft SQL Server 2000 Analysis Services or are offline cube files stored on the local computer.

Note

Most OLAP databases house too much data to store in a single offline cube file. An offline cube file contains, in most cases, only a portion of the data stored in a cube on an OLAP database server or a portion of the data stored in a relational database on a network server computer.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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