Queries made to the database to obtain more detailed information than in the contents of the multidimensional model are defined from tables or views existing in the DBMS. The views are used in those cases when the query involves fields from more than one table.
Configuration of query elements means:
- Identifying the query with a adequate name
- Associating the name of the table or view over which the query is made.
- Defining the fields of the query that you wish to view as columns in the Drill Through pane.
- Defining the fields you wish to use as filters in the query, allowing the user to restrict its result to the values stated in them. Detailed filter definition can be found in the Defining Filters section.
The O3 Browser Tools menu contains the Drill Through functionality with the options to define a new query and to edit an existing one, besides defining connections to the database.
The following picture shows the dialogue box that lets you configure a query to the database.
Picture 5: Configuring a Query
The configuration window displays two panes:
- Definitions Pane (left pane)
- Properties pane (right pane)
The definitions pane contains a first node with the "Drill Through" label whose properties define the query to the database.
Filters are added to the node labeled "Filters" in the definitions pane. Their attributes are defined in the properties pane and are described later in this section.
The following section describes the query configuration properties.