The Analysis View Filter Table
Here you can set a dimension value filter for an analysis view. By setting a dimension value filter, you specify that only entries with the dimension values set in the filter are to be included in an analysis view. To set the filter, click the AssistButton in the field.
The Dimension Value Filter can be useful if you have set up an analysis view specifically to monitor a particular part of a company's activities, for example, sales in a department or sales in a specific area.
You can enter a maximum of 250 characters, both numbers and letters. There are certain rules for how these can be combined. Here are some examples of how your company might use filters:
Meaning |
Sample Expression |
Entries Included in Update |
Equal to |
200 |
Dimension value 200 |
Interval |
200 .. 350 |
Dimension values 200 through 350 |
Either/or |
ADM|SALES |
Dimension value Administration and Sales. |
Different from |
<>SALES |
All dimension values except Sales |
Click here to learn more about dimensions.