The Settings Area

The Settings Area contains a number of sections whose inputs control various aspects of the current cube view.

Selection Criteria

Open the Selection Criteria section to enter filter values for the user parameters defined on this cube type. User parameters that have been configured as ‘Save with Cube View’ on the cube type will be saved when the cube view is saved.

Compare

Open the Compare section to enter one or more sets of criteria that are used to retrieve data sets for comparison to the data retrieved by the main Selection Criteria. Use the Add and Delete buttons to add or remove a set of criteria. The comparison values will be displayed side by side with the main cube values in the data views. Note that the pseudo dimension Dataset must be included as a dimension column in order to display comparison views.

View Options

Open the View Options section to access buttons that toggle on and off the display of the supported data view types. The buttons can be used to change the order in which the views are displayed, using drag and drop. Any changes made to the default button settings will be saved when the cube view is saved. Refer to the Views Area topic for more information on the available data views.

Dimensions

Open the Dimensions section to view the list of dimensions defined on this cube type, as well as the pseudo dimension Dataset and the date/time filter, if applicable. Use drag and drop to move a dimension into the list of Columns or Rows displayed in the data views. Moving a dimension into the Unassigned list will remove it from the data views.

Format

Click the Edit button on the Format section to open a dialog box in which conditional formatting, such as background or text color, can be defined for the values in the data grid. Refer to Defining Conditional Formatting for more information about the formatting controls.