Dimension levels

Dimension levels

View and manage dimensions levels, which are used for cube data. 

The following actions can be performed: 

• Add records
• Sort and filter dimensions levels
• Export and import metadata
• Delete records
• Navigate to dimension items

Dimlevel code

Each dimension level must have a unique code.

Name

A name is required for each dimension level. HTML code is not allowed in the name field.

AggregateType

Defines how Swing aggregates data at this level. The following options are available:

• Sum: Aggregation is calculated by summing the data.
• Mean: Aggregation is based on averages. If a weight variable is set, a weighted average is used.
• No aggregation: No aggregation is performed. Swing Viewer ensures that at least one member is always selected.
• Unknown: Aggregation type is not explicitly set. Swing will determine the appropriate method based on the data type of the indicator.

Sequence number

Specifies the order in which the dimension level appears in the database.

Description

A description can be provided for each dimension level. This helps administrators include additional context or metadata.

Formatting is supported using a limited set of HTML elements:

• <strong> or <b>
• <i>
• <u>
• <em>
• <p>
• <span>
• <h1> through <h6>

Since HTML is allowed in the description, make sure to use valid HTML syntax. Special characters like < and > must be encoded as (&lt;) and (&gt;).

More information

If additional information is available for a dimension level, the administrator can provide a reference to an external HTML file. The file name should be entered in the More Information column.

Dimension code

Links the dimension level to its corresponding dimension.

Items

The members or elements defined at this dimension level.