Filters

Filters enable you to select data to be displayed either in the table or in the chart. The creation of query filters is identical to the creation of cube filters.

In the creation of filters for queries, you can create three types of filters:

Optional Items: optional filters can be enabled/disabled by the user.

Compulsory Filters: compulsory filters are created by the administrator and they cannot be disabled by the user.

Compulsory filters enable you to have fixed filters for each group of users or even per users, enabling each group/user to have a different view of the same query through these filters.

Segment Filters: segment filters create a subcube containing only data concerning the filter created. Thus, the query is performed by using this subcube and not against the original cube, what speeds up queries.

Each type of filter may have parameters called prompts, that can be filled out by users when the query is performed or be fixed by the administrator. Parameters are characterized by starting with a colon sign (:). For example:

Clients tab, fill out the Field A1_EST with :STATE

Click Next to define warnings for the query.