Attribute Tab in the Subset Editor


Related main article: Description of Subset Editor

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 activate the Attribute Filter by marking the checkbox in the upper-right corner of the tab window.

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. First, activate the Attribute Filter by marking the checkbox, then enter “J*” in the SalesPerson field (see screenshot below).

If you wanted to filter for all of the 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 Oktober 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.