Range Construction Mode

Unknown macro: {scrollbar}

Using the Range construction mode, you can define a categorization of data according to the values of a certain measure included in the model. This allows you to observe data in groups when analyzing the information in the O3 Browser. The hierarchy for this Dimension type is one level. It includes the ranges, each with minimum and maximum values.

First, you must indicate which of the defined measures you are using to define the intervals.
Then, add a field for each interval, name the interval to identify it for the Browser, and determine the minimum and maximum values for each interval.

Using the example of a Sales Cube, you could define a range of Rank to classify the sales into three intervals: small or unitary sales, medium-sized sales, and large sales.

There are two special values you can use when entering the extreme values of an interval. The MIN value represents the minimum of values existing in the Data Source, and the MAX value represents the highest of values. This makes it possible to generate a range containing all the elements of the Dimension; defining the first interval from the MIN value and the last interval up to the MAX value.

Adding a Range Dimension

Use the Add Dimension command or the Insert Dimension command to add a dimension in range construction mode.

To add a dimension in range construction mode:

Select the Dimension branch in the Design tree.
Add a new Dimension
- To add a dimension to the end of the list, choose the Add Dimension command.
  The dimension is added and the Properties Pane is displayed.
- To insert a dimension right after an existing dimension, select it and choose the Insert Dimension command.
  The dimension is added and the Properties Pane is displayed.
Turn on the Range radio button.
Complete the fields in the Property Pane.
To add a field to the Intervals table, choose the New Field button. A row adds.
Double-click on each field in the row to enter a value.
To remove a field from the Intervals table, click on the row and choose the Delete Field button. The field is deleted.

Note
The measure you use in the range construction mode must be created before you define the dimension.

The Dimension Property Pane - Range Construction Mode

In Range construction mode, the dimension property pane includes these tabs:

Description
General
Order

The Description Tab

Property	Description
Name	Enter the name of the dimension.
Description	Enter a description of the dimension.

The General Tab

Property	Description
Default Value for Null Fields	Enter the label of the special node created to accumulate the registers in cases where data from the Measures Data Source has null values in the identification of this dimension key, or out of range values for the hierarchy category.
Store Dimensions As	For every dimension you can select any of this options to store the elements of the dimension. To select one you must know how many total elements (for all levels) the dimension will have. Byte (8 bits)max 256 elements Short (16 bits)max aprox. 65.000 elements (should be enough for most dimensions) Integer (32 bits)max aprox 4 billion elements.
Related Dimension	Links a dimension with another with the same structure and similar information. (See Related Dimensions)
Measures	Choose a measure from the list to use in defining the intervals.
Intervals Table	Specify each of the levels in this table. Name the interval and determine the minimum and maximum values for the interval. Use the New Field button to add a level immediately after the last available one. Use the Delete Field button to remove a level.

The Order Tab

This section refers to a mechanism that activates rankings from O3 Designer during the design phase of the model.

See Automatic Rankings

Property	Description
Activate Order	Activates the automatic ranking of elements in the dimension.
All Elements	Indicates that all elements will be displayed after sorting
First	Indicates that only the first N elements will be displayed after sorting.
Show Others	In cases when only a few elements are shown, it is possible to include an extra element, called Others, that summarizes those left out of the view.

This feature does not imply the sorting of elements in the hierarchy. This is just a presentation feature. To sort elements in the dimension see the sorting options in the properties pane for dimension levels in standard dimensions

Unknown macro: {scrollbar}