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

Chapter 30. Retrieving Data from OLAP Se... > Performing OLAP Analysis on Database...

Performing OLAP Analysis on Database Data

You can use Excel PivotTables and PivotCharts to analyze relational database data that has not been loaded into cubes on an OLAP server. For example, you might have your own Microsoft Access database that you want to analyze, or perhaps you need to work with data in an Oracle database that wasn't defined with the requirements when the database administrator built server-based cubes. If you have been using regular Excel PivotTables with a relational data source, you might find that you get better performance if you first build a cube from the data and then use OLAP PivotTables.

Starting the OLAP Cube Wizard

Choose Data, Import External Data, New Database Query, and create a new query or edit one that's already saved. Be sure the check box to Use the Query Wizard to Create/Edit Queries is selected in the Choose Data Source Dialog. See Chapter 29, “Using Excel with Access and Other Databases,” for details on using the Query Wizard. In the Choose Columns step of the Query Wizard, be sure you include all the database columns from your data source that correspond to the measures and dimension levels you want to include in your cube. When you get to the final step of the Query Wizard (see Figure 30.17), choose Create an OLAP Cube from This Query, and click Finish to launch the OLAP Cube Wizard.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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