Table of contents
- Getting Started
- Getting Help
- Keyboard Shortcuts
-
Installation and Data Sources
- Install an ODBC driver so that you can access an external data source
- Install OLAP providers
-
Setting Up Data Sources
- Databases you can access
- Specify a source to retrieve data from
- Set up a data source that uses the Microsoft Access driver
- Set up a data source that uses the Microsoft dBASE or FoxPro driver
- Set up a data source that uses the Microsoft Excel driver
- Set up a data source that uses the Microsoft ODBC for Oracle driver
- Set up a data source that uses the Microsoft Paradox driver
- Set up a data source that uses the Microsoft SQL Server driver
- Set up a data source that uses the Microsoft SQL Server OLAP Services driver
- Set up a data source that uses the Microsoft text driver
- Creating, Opening, and Saving Queries
- Running Queries
- Creating and Connecting to OLAP Cubes
- Changing Queries
- Limiting the Data You Retrieve
- Creating Calculated Fields
- Changing the Result Set
- Finding, Sorting, and Reviewing Data
- Changing Data in a Queried Database
- Using Dynamic Data Exchange (DDE)
- Troubleshooting