You can meet the requirements by creating dynamic filters
You can meet the requirement by using parenthetical filtering
Filters cannot be combined with other column filters from the same subject area to further constrain the results of a request
The variables have to be constructed and saved in the repository to be used in Siebel