Related main article: Subsets Overview
If there are attribute entries in a database, then you can filter the corresponding dimension for these attributes using the Attribute tab of the Subset Editor. To select options in the Attribute tab, you must first you must first add an Attribute filter.
Let's look at an example. In the Customers dimension of the Biker database, each customer has a salesperson as an attribute. We want to filter for salespersons whose names begin with the letter J.
Enter "J*" in the SalesPerson field (see screenshot below).
If you want to filter all customers associated with a particular salesperson, you would enter the salesperson's name in the SalesPerson field.
Entries in the same line are connected with "AND", entries in different lines are connected with "OR".
The displayed examples in the screenshot show PERL regular expressions and operators for number conditions. Operators for number conditions can be used if the attribute contains number values ( e.g. prices of products as attributes).
You can filter by attribute translation by selecting the fields available in the Use translation section. For example, if you have attribute translation activated for Month, searching for October returns the results for October.
Note: This section is visible in the Subset Editor only when the Language attribute is defined in the according dimension.
Using Named Ranges in the Attribute tab
Enter for example following entries:
Give the range the name "SalesPerson1".
When you now set the attribute filter, you can select “Named range” in the pulldown menu on the right side:
With the selection "SalesPerson1" the Subset will filter out all customers that have the attribute value "David".
Updated March 27, 2024