Adding Attribute Definition

Attributes facilitates you to define the properties or qualifiers for the Dimension members.

To create an Attribute definition in the Attributes screen:

  1. From the Attributes window, Click Add. The Attribute Definition (New Mode) window is displayed.

  2. In the Dimension section, select the required dimension from the drop-down list.

  3. Click in the Numeric Code field. A unique code is auto generated. You can also manually enter the code in the Numeric Code field.

  4. Enter the Name and required Description for the Attribute.

  5. Enter the Attribute Properties as tabulated:

Field

Description

Fields marked in red asterisk (*) are mandatory.

Data Type

Select the Data Type as DATE, DIMENSION, NUMBER, or STRING from the drop down list.

If NUMBER is selected as the Data Type:

The Scale field is enabled with 0 as default value. Enter a Scale value >= 0. If it is left as 0, values for this attribute will be limited to Integers. If you wish to enable decimal entries for this attribute, the maximum Scale value must be > 0 and <= the scale defined for NUMBER_ASSIGN_VALUE in the dimension's underlying attribute table. Please refer to the Data Model Utilities Guide for further details on the attribute table.

Required Attribute

Select Yes or No. If this is set to No, an attribute value is optional for the associated dimension members.

Note: This field is disabled in Add and Edit modes if any members already exist for the Dimension upon which this attribute is defined.

Default Value

If Required Attribute is set to Yes, a Default Value must be entered, otherwise it is optional.

If DIMENSION is selected as the Data Type:

  • Select the required Dimension from the drop down list in the Dimension field.

  • Select the Default Value from the drop down list of members mapped to the selected Dimension.

If the required Member is not listed in the drop-down, select - More - and the Member Search screen is displayed. For more information refer search.

If NUMBER is selected as the Data Type:

  •  Enter a numeric value in the Default Value field, and it must be consistent with the Scale you have defined.

If DATE is selected as the Data Type:

  • Click button to select a valid date as the Default Value from the calendar.

If STRING is selected as the Data Type:

  •  Enter alphanumeric value in the Default Value field.

  1. Click Save. The entries are validated and the defined Attribute is captured.

Back to Top