5.1 Adding Attribute Definition

Attributes facilitate you to define the properties or qualifiers for the Dimension Members. The Write role should be mapped to your user group, from the User Group Role Map Window.

To create an Attribute definition in the Attributes Window:

  1. From the Attributes window, click Add

    The Attribute Definition (New Mode) Window is displayed.

    .

    Figure 5-1 Attributes Window


    Attributes Window

  2. In the Dimension Section, select the required dimension from the drop-down list.
  3. Click the Code Generate icon button 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.

    Note:

    Name: The characters & ’ ” are restricted in the Name Field.

    Description: The characters ~&+' "@ are restricted in the Description Field.

  5. Enter the Attribute Window is as tabulated:

    The following table describes the fields in the Attribute Window.

    Table 5-1 Fields in the Attributes Window and their Descriptions

    Field Description
    Fields marked in red asterisk (*) are mandatory.
    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 the 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. See the OFS 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 on 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 then select --More—and the Member Search Window is displayed.

    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 the

    Figure 5-2 Icon

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

    If STRING is selected as the Data Type:

    Enter an Alphanumeric Value in the Default Value field.

    The Maximum Number of characters allowed in the Default value field for String Data Type is 1000.
  6. Click Save . The entries are validated and the defined Attribute is captured.