Setting Table Area Structure

Table area structure includes:

NOTE. If shared dimension is not added to sidehead dimensions or to shared dimensions of table area heading, it will be a private dimension of indicators.

Filter is a cube that is used to filter dimension elements displayed in the sidehead for various parameter values. The filter cells can be filled with value or the cell can be empty. The sidehead will display elements with values.

NOTE. When filter is used, displaying of totals is unavailable too.

Filter structure

To set a table area structure, use the table area editor:

Table area structure

Table area editor elements

To determine table area structure:

  1. Set table area name in the Table box.

  2. Add dimensions, indicators, filter, and algorithms to structure.

  3. Change position of dimensions and indicators.

  4. Selection dimension elements.

  5. Execute detailing of dimensions to set up navigation from a dimension element to an object detailing its value.

  6. Group dimensions of sidehead by specified attributes if required.

  7. Display additional names of sidehead dimension elements.

If required, transpose table.

Next, set up calculation algorithms if required.

To finish working in the table area editor, click the button:

Operations with Dimensions, Indicators, Filter, and Algorithms

Available operations with dimensions, indicators, filters, and algorithms in the table area editor:

Add dimensions, indicators and algorithms

Add filter

Move dimensions and indicators

Remove dimensions, indicators, filter, and algorithms

Limit filter elements

Reorder dimensions, indicators and dimension attributes

Display additional names of dimension elements

Transpose

Set up grouping

Deny indicator value entry

Rename indicators

See also:

Building Data Entry Form| Inserting and Setting Up Table Area| Working with Ready Data Entry Form