About Dataset-Level Filters
As a dataset owner you can apply filters to one or more tables in a dataset, to enable Oracle Analytics business analysts and users to access only the data they need.
For example you can create a filter on a school state column that only shows data from schools in the State of California in workbooks.
Dataset-Level Filters Overview
- As a dataset owner, you can filter your data at the dataset-level before you or other analysts create workbooks.
- You manage dataset-level filters in the dataset filter bar in the Join Diagram.
- You can apply multiple filters to a dataset at the same time.
- You can filter data on multiple tables and columns. For example, you might apply a filter to a SCHOOLS_METRO column in a SCHOOLS table and to a TOTAL_DONATIONS column in a DONATIONS table using
SCHOOLS.SCHOOLS_METRO='rural' AND DONATIONS.TOTAL_DONATIONS > 10000. - You use expressions to specify dataset filters. For example, SCHOOL_METRO='rural'.
- When you add dataset filters in the Join Diagram, the preview data shown isn't filtered, but the dataset is filtered when workbook consumers and content authors access the dataset.
Tips on Using Dataset-Level Filters
- To display the the dataset filter bar, in the Join Diagram click the dataset filter bar icon
on the toolbar. - To add a filter to a dataset, in the dataset filter bar, click Add Filter and use the expression editor to specify filters.
- To edit a filter, click a filter tile in the dataset filter bar to display the expression editor.
- To remove a filter from the dataset, right-click the tile in the dataset filter bar and select Delete.
- To show filter values in filter tiles, right-click the tile in the dataset filter bar and select Show Values.
- Save your filtered dataset before you create workbooks from it.