5 Filtering and Selecting Data for Analyses

This section describes how to filter and select data for analyses.

Topics:

• Typical Workflow for Filtering and Selecting Data

• About Filters and Selection Steps

• Creating Filters for Columns

• Editing Filters for Columns

• Reusing Filters

• Using a Saved Analysis as a Filter

• Advanced Techniques: How Dashboard Prompts and Analysis Prompts Interact

• Refining Selections of Data

• Manipulating Members Using Groups and Calculated Items

For more detailed information about filtering and selecting data for analysis, see Oracle Fusion Middleware User's Guide for Oracle Business Intelligence Enterprise Edition.

Typical Workflow for Filtering and Selecting Data

To start filtering and selecting data to display in analyses, refer to the typical workflow described in the following table:

Task	Description	More Information
Create an analysis	Select and arrange columns that you want to use in an analysis.	Creating Your First Analysis
Create a filter	Limit the results that are displayed when an analysis runs.	Creating Filters for Columns
Edit a filter	Change the operator and values in a filter.	Editing Filters for Columns
Save a filter	Save filters in the catalog or with the analysis.	Saving Filters
Create a selection step	Select members, new groups, existing groups, new calculated items and conditions for displaying data.	Creating Selection Steps
Create a group	Group column values for display in an analysis.	Creating Groups and Calculated Items
Create a calculated item	Apply a function to column values to calculate a new value.	Creating Groups and Calculated Items