A dimension filter is used to restrict the FDcolumn to specific dimension values.

The filter can include a single dimension, a range of dimensions, or a group of dimensions. The filter can also include dimension value sets. Because dimension values can vary, a dimension-based system does not have to adhere to an exact length.

The filter is applied, regardless of whether the report includes a reporting tree.

You can use a wildcard character (? or *) in any position. When you specify multiple accounts, place a comma between accounts, as in the following example:

+Account=[1200], +Account=[1100], Department=[01?]

To receive all departments for a specific account, you can exclude the Department dimension in the dimension filter. For example,

+Account=[1100],Department

is treated the same as:

+Account=[1100]

You can also use any combination of alphanumeric characters for exact matching, and you can define partial dimensions. For example, Location = [10*]includes all location dimension values that begin with 10.