Manage Field Dimension

When a Dimension has been selected for the Field in the settings, then a Dimension Value Filter-button will appear in the settings. The button has initially orange color identifying that no Dimension Value filtering has been made. The color will turn to green as soon as any dimension filtering setting has been made for the field. Dimension Value Filter

By clicking the Dimension Value Filter-button the first level of Dimension Values will be opened.

Selecting Dimension for the Field

When you select a Dimension for a Field from the dropdown, the name of the Field remains the same even though the name of the Dimension differs. Multiple Fields in the Table can share the same Dimension.

Autogenerate Dimension Values

When the Dimension is selected for a Field that already has value and are type of "text" or "integer", the Dimension Values will be generated from existing unique field values in the database.

Filtering Dimension Values for a Field

You can open and close the next level by clicking the name/label of the parent Dimension Value. Selecting at least one Dimension Value in the list will mean that unselected Dimension Values will not be available for the field in Reporting. When a Dimension Value is selected all its child Dimension Values will also be selected. However, if you choose, that no child Dimension Values will be available for the field, you can right-click the Dimension Value. Dimension Value will then turn blue and child values cannot be reached. Right-clicking again will make the child Dimension Value available again.

Hyphen ("-") in the Dimension Value checkbox means, that some of the subDimension Values are selected but not all. Checked means that all the Dimension Values below also are selected. If none or all of the Dimension Values are checked, then it means that field does not have any filter in place.

Allow empty fields

When Dimension has been selected for the field, then the settings include also "Allow blanks" and "All options" -checkboxes. When "Allow blanks" is selected, then user does not have to select any Dimension Value for the field in Reporting.

Reporting all DimensionValues

When "all options" is selected then default reporting-tables will automatically include rows for all the Dimension Values.