What are conditions?

Conditions are worksheet items that enable you to choose what data to display on worksheets. Conditions filter out data that you are not interested in, enabling you to concentrate on data that you want to analyze. For example, in the figure below, the "Edit Worksheet dialog: Select Items tab: Conditions tab" shows that a condition is active that only displays 2000 data (i.e. Calendar Year = 2000).

Figure 13-1 Worksheet conditions in Discoverer

Description of the illustration consimp.gif

You create conditions by specifying condition statements against which to match worksheet data. Discoverer uses conditions as follows:

• data that matches your condition statements is displayed

• data that does not match your condition statements is not displayed

Conditions are categorized as follows:

• single conditions - contain a single condition statement

• multiple conditions - contain two or more condition statements in a single condition item (for more information, see "What are multiple conditions?")

• nested conditions - contain condition statements that are defined within other condition statements (for more information, see "What are nested conditions?")