HP Intelligent Management Center Standard Software Platform - Manual (Page 17)

Creating an OLAP report.........................................................................487
To create an OLAP report...................................................................487
Specifying the data source.................................................................487
Defining the structure of the grid........................................................488
Setting sliced dimensions and specifying the number of grids...........490
Applying a predefined style................................................................492
Inserting a chart..................................................................................493
Updating an OLAP report........................................................................493
To update a cube location in an OLAP grid object.............................494
Updating the database location..........................................................495
Formatting data in an OLAP grid.............................................................495
Changing the background color of a dimension.................................496
Creating an alias for a dimension.......................................................497
Formatting grid lines...........................................................................498
Labelling dimensions..........................................................................498
Changing the view of OLAP data ...........................................................498
To show or hide dimension members ................................................499
To create asymmetry in an OLAP grid...............................................499
To add totals to an OLAP grid............................................................499
To change the display format for member names..............................500
To alter the data displayed in the OLAP grid......................................500
To pivot an OLAP grid .......................................................................500
To define the order of fields in the OLAP grid ...................................500
Sorting and filtering OLAP grid data........................................................501
Sorting data in an OLAP grid .............................................................501
Filtering data in an OLAP grid ...........................................................503
Adding calculations to OLAP grids .........................................................504
Printing, Exporting, and Viewing Reports 505 Chapter 20
Distributing reports...................................................................................506
Printing a report..................................................................................506
Crystal Reports 2008 SP3 User's Guide 17
Contents