User`s guide

Suppressing Cross-Tab data................................................................................................334
15.5.5
Displaying summarized fields horizontally.............................................................................336
15.5.6
Advanced Cross-Tab features..............................................................................................336
15.6
Calculated Members............................................................................................................336
15.6.1
Embedded Summaries.........................................................................................................340
15.6.2
Building Queries.................................................................................................................343Chapter 16
Connecting to a universe.....................................................................................................343
16.1
To connect to a universe......................................................................................................343
16.1.1
Defining the data selection for a query.................................................................................344
16.2
To build a simple query.........................................................................................................344
16.2.1
To create a combined query.................................................................................................345
16.2.2
Quick reference to objects...................................................................................................345
16.2.3
Editing an existing query.......................................................................................................346
16.3
To edit an existing query......................................................................................................347
16.3.1
Viewing the SQL behind a query..........................................................................................347
16.4
To view the SQL when you create a query...........................................................................347
16.4.1
To view the SQL after you have created a query..................................................................348
16.4.2
Query filters and prompts.....................................................................................................348
16.5
Creating query filters............................................................................................................348
16.5.1
Building prompts..................................................................................................................349
16.5.2
Combining query filters and prompts....................................................................................350
16.5.3
Using And or Or to combine query filters.............................................................................351
16.5.4
Quick reference to query filter operators..............................................................................351
16.5.5
Editing and removing query filters.........................................................................................354
16.5.6
Filtering data using subqueries and database ranking...........................................................354
16.6
What is a subquery?.............................................................................................................355
16.6.1
Building a subquery..............................................................................................................355
16.6.2
What is a database ranking?.................................................................................................357
16.6.3
Creating a database ranking.................................................................................................358
16.6.4
Creating and Updating OLAP Reports................................................................................361Chapter 17
OLAP reporting with Crystal Reports...................................................................................361
17.1
OLAP grid objects................................................................................................................361
17.1.1
Creating an OLAP report......................................................................................................362
17.2
To create an OLAP report....................................................................................................362
17.2.1
Specifying the data source...................................................................................................362
17.2.2
Defining the structure of the grid..........................................................................................363
17.2.3
Setting sliced dimensions and specifying the number of grids..............................................365
17.2.4
Applying a predefined style..................................................................................................366
17.2.5
2012-03-1412
Contents