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

Embedded Summaries.......................................................................458
Building Queries 461 Chapter 18
Connecting to a universe.........................................................................462
To connect to a universe....................................................................462
Defining the data selection for a query....................................................463
To build a simple query.......................................................................463
To create a combined query...............................................................464
Quick reference to objects..................................................................465
Editing an existing query..........................................................................466
To edit an existing query.....................................................................467
Viewing the SQL behind a query.............................................................467
To view the SQL when you create a query.........................................467
To view the SQL after you have created a query...............................468
Query filters and prompts........................................................................468
Creating query filters..........................................................................468
Building prompts.................................................................................469
Combining query filters and prompts.................................................471
Using And or Or to combine query filters...........................................471
Quick reference to query filter operators............................................472
Editing and removing query filters......................................................475
Filtering data using subqueries and database ranking............................476
What is a subquery?...........................................................................476
Building a subquery............................................................................477
What is a database ranking?..............................................................480
Creating a database ranking..............................................................480
Creating and Updating OLAP Reports 485 Chapter 19
OLAP reporting with Crystal Reports.......................................................486
OLAP grid objects..............................................................................486
16 Crystal Reports 2008 SP3 User's Guide
Contents