Defining the Data Area

When you filter or sort by value, the data area is enabled. The data area is used to define the slice of data to which the filter or sort applies. Often this is the same slice of data on which you are reporting. But, for example, you might want to see sales figures in one financial year where a condition in a previous financial year applied. The data area has two columns, Hierarchy and Selection. To define the data area, you list the hierarchies on which the report is based and select elements from them.

If you do not define the data area, the filter or sort applies to the elements currently selected in the report.

Note: The data area is not applicable to value filters that you create in the axis designer for slice segments.

See Filters in slice segments.

To define the Data Area:

Open Filter in the List Designer.
Click New Filter.
Select Value.
The Data Area is enabled.
Define the Data Area manually, or fill it with default values and edit them as necessary.
1. To define the Data Area manually, click <Select Hierarchy> in the Hierarchy column and select a hierarchy, element, set or tuple.
  See Using elements in the Data Area.
2. Click Current element in the Selection column and click the browse button.
  The Select Elements dialog is displayed.
  Specify the element to use, or select a variable which contains the required element.
  
  SeeUsing variables in the Data Area.
1. To fill the Data Area with default values, click Fill.
  The Hierarchy and Selection columns fill with the hierarchies and values currently used in the report.
2. To use an element, set, or tuple in place of the currently selected hierarchy, click the selected hierarchy and select from the drop-down list.
3. To use an element or variable in place of the currently selected element, click the browse button of the current element and select from the Select Elements dialog.