Operation Manual

Creating and Updating OLAP Reports
Changing the view of OLAP data
19
378 Crystal Reports User’s Guide
Changing the view of OLAP data
When analyzing OLAP data in your report, there are several basic ways to
change how the data is displayed in the grid.
Note: The methods described here let you manipulate your OLAP grid
directly from the Preview tab of Crystal Reports. You can also carry out the
same and additional, more advanced, functionality on the Cube View tab.
Search the online help for “Using the OLAP Worksheet” to learn more about
the functionality available on the Cube View tab.
u
To show or hide dimension members
1. Right-click the dimension whose members you want to show or hide.
2. On the shortcut menu, click Expand Member or Collapse Member.
The dimension expands to show its members, or collapses to hide them.
Tip: You can also double-click parent dimensions to drill down into the
hierarchical data displayed in the OLAP grid.
u
To create asymmetry in an OLAP grid
Using asymmetry, you can display different inner dimension members for any
number of outer dimension.
Note: You can create asymmetry only on stacked dimensions.
1. Right-click the member that you want to remove.
2. On the shortcut menu, point to Hide or Show and then select the
appropriate option.
For information about how to use these options, search the online help
for “Creating asymmetry” and “Restoring symmetry.”
u
To add totals to an OLAP grid
1. Right-click the dimension you want to see totals for.
2. On the shortcut menu, select Automatic Totals.
A submenu appears with options for the kind of totals you can add.
3. Select the option you want.
A “Total” row or column (or both) is added to your OLAP grid. To remove totals
later, select No Totals.