Filters
Filters enable you to select data to be displayed either in the table or in the chart.
As this filter definition is being done in the cube, these filters are automatically reproduced as optional filters for queries that are created with this cube. For further information about optional filters, see the section Filters in query creation.
However, a cube filter cannot be changed in the query.
Creating Filter for Cubes
1. In filter page, click New.
2. Enter a name and description.
3. Click Send.
There are three types of filters: Optional, Compulsory, and Segment. Nevertheless, filters defined for cubes are automatically define as optional and they are displayed in the query as optional. |
In SIGADW, you can define cube filters through two ways: Expressions and Fast Mode.
Expressions
To create a filter with expressions, in which you can define more complex expressions:
1. Select the filter in which you want to define an expression.
2. Select the folder Expression.
3. Click (...).
In the filter, you must use an expression created in SQL syntax, using attributes and indicators defined in the cube and choosing them in the list presented on filter definition screen.
After creating the expression, just save it by clicking Save. Important: click Send to save the definition of filter expression.
Fast Mode
In this filter, user can do filters fast and with little typing. It is a very intuitive way of creating filters. Creating a filter in Fast Mode:
| • | Select the filter in which you want to define an expression and click  |
| • | A screen is displayed in which you can select attributes (through their dimensions displayed) and indicators. Click the dimension you want or click the indicators folder. |
Attributes of the dimension chosen or indicators are displayed in the grid.
To create a simple formula for each attribute, a QBE Expression is used. You can create it manually following some conventions (according to the table below) or you can use a QBE Help.
QBE Help
Click 
to activate QBE Help (select one of the formulas and enter the respective fields):
After clicking Apply, QBE Help creates a QBE expression for the field (as it was created manually).
QBE Conventions
/ .. /
It is equivalent to LIKE command of SQL. For example, in the field Customers:
C..
Only customers that start with C are selected.
..A
Only customers that end with A are selected.
..A..
Only customers that have A in the expression are selected.
/ - /
It enables you to define value ranges. For example:
A-C = Only customers that start between A and C are selected.
/ >,< /
It enables you to choose between the lowest and the highest value. For example:
>Marcelo = All customers that come after Marcelo are selected.
/ , /
It enables you to choose values that are between commas. It corresponds to IN command.
For example:
Marcelo, Elaine, Julia = The customers Marcelo, Elaine, and Julia are selected.
If you put more than one expression in several attributes, they are related through AND expression. If the same attribute has more than one expression, filters are related through OR expression. |
Instead of entering a QBE Expression, you can simply select some records through Selection.
By doing it, data presented in the database for that dimension attribute or cube indicator are displayed.
After defining cube filters, now you can also create virtual fields. For this, click Next.