User`s guide

OLAP grid objects provide true multi-dimensional reporting. Add dimensions to either axis to analyze
three, four, or more dimensions in a single OLAP grid. Or instead of viewing multiple dimensions within
one OLAP grid, create multiple OLAP grids within the same report.
Note:
When Crystal Reports displays an OLAP grid, it can do so quickly if the grid is long (down many pages)
instead of wide (across many pages). When the grid is long, the program processes it on a page-by-page
basis. When the grid is wide, the program must gather all the data before it can display a page. This
may require significantly more processing time.
17.2 Creating an OLAP report
OLAP reports are created using the OLAP Report Creation Wizard or the OLAP Expert. Before you
start creating your report, ensure you have the following information:
• OLAP Type
• Server/Database name
• User ID
• Password
• Parameters (applies only to OLE DB for OLAP)
Tip:
You can return to the OLAP Report Creation Wizard by selecting the OLAP Design Wizard option on
the Report menu. Do this if you want to change your page dimensions, or if you want to change parameter
values.
17.2.1 To create an OLAP report
• On the Start Page, click OLAP Cube Report Wizard.
The OLAP Report Creation Wizard appears with the OLAP Data screen active.
17.2.2 Specifying the data source
Use the OLAP Data screen to define the OLAP data source.
1.
Click Select Cube.
2012-03-14362
Creating and Updating OLAP Reports