The elements of a business attribute are the unique values for that attribute. For example, 2011 and 2012 are elements of the Year attribute, while New York and London are elements of the City attribute.
On a report, attributes are chosen to build the report, and once the report is executed, the attribute's elements are displayed in the rows or columns.
The filter type called an attribute element list qualification qualifies (or filters) report data based on a list of attribute elements belonging to an attribute. For example, the attribute Customer has elements - individual customer names. For a report containing the attributes Region, Customer, and Income Range, use an attribute element list qualification on the attribute Customer to obtain income data for only those customers specified in the filter.
To create a stand-alone attribute element list qualification filter:
On the project's main page, click
Create Filter to view the
New Filter screen. Or, from
the Admin menu, choose Filter. From the Filters page, click the Create Filter
icon.
In the pane on the left, navigate to the attribute that has the elements to filter a report's data.
Right-click the attribute and select Add to Filter.
To create the list of elements which the filter will use to filter data:
Click Select.
From the In List drop-down list, select one of the following:
To define what attribute elements the filter should include data for, select In List.
To define what attribute elements the filter should exclude data for, select Not In List.
The Available pane displays the elements that belong to the attribute chosen for this filter.
Select an element and then click the right arrow to move the element to the Selected pane. Press CTRL to select multiple elements. If the Available list contains a large number of elements, use the Search for field to locate the elements to select.
To search for objects:
Beginning with specific letters, by typing those letters followed by an asterisk. For example, to find regions beginning with south, type south* in the Search for field and click the Filter button. South, Southeast, and Southwest are displayed.
Ending with specific letters, by typing an asterisk (*) and those letters. For example, to find regions ending with west, type *west in the Search for field and click the Filter button. Northwest and Southwest are displayed.
With a specific name, by typing the name in quotes (" "). For example, to find the South region, type "South" in the Search for field and click the Filter button. South is displayed, but not Southeast or Southwest.
Beginning with specific letters and ending with specific letters, by typing the first letters, then an asterisk (*), then the last letters. For example, to find regions beginning with S and ending with th, type s*th in the Search for field and click the Filter button. South is displayed.
Containing specific letters, by typing the characters separated by the percent sign (%). For example, to find regions that contain both S and th, type s%th in the Search for field and click the Filter button. South, Southeast, and Southwest are displayed.
Based on an attribute form, by typing the name of the attribute form in brackets [] followed by a colon and the value to search for. For example, to find customers with the first name Maxwell, type [First Name]:Maxwell in the Search for field and click the Filter button. Maxwell Perez is displayed, but not Delores Maxwell.
Click Apply to create the filtering condition.
From the File menu, select Save As and navigate to the desired folder. Enter a name and description for the filter in the Name and Description fields, and click OK to save the filter.
The filter can now be added to a report.
Adding a stand-alone filter to a report
Attribute-to-attribute qualification
Metric-to-metric qualification
Shortcut-to-a-report qualification
Shortcut-to-a-filter qualification
_____________________________
Copyright © 2019, Oracle and/or its affiliates. All rights reserved.
Legal Notices