1. Profitability Analytics Cloud Service User Guide
  2. Dimension Management
  3. Attributes
  4. Creating Attribute Definition

3.4.2 Creating Attribute Definition

To create a new Attribute for a dimension, complete the following steps:

  1. Click the Add in the Attribute Summary Page.
    The Add Attribute Definition Page is displayed.
  2. Enter the Attribute Details as described in the following table:
    Field Description
    Attribute Details
    Dimension Select the Dimension for which the new Attribute is getting created.
    Numeric Code

    The Numeric Code to be assigned to the new Attribute Definition.

    You can enter the value manually or click Generate, to auto-generate a unique code.

    If you enter the value manually, the system will verify if the value is unique and assigns it.

    You can enter any number between 0 and 999,999,999.

    Name

    The unique Attribute Definition Name.

    You can enter up to 100 characters. All characters are allowed except " & ' and " ' ".

    Alphanumeric Field Value

    The name of physical column name that will be used to store attribute value in the Report Dimension Table.

    You can enter up to 100 characters. We recommend using only Underscore (“_”) as a special character.

    Description

    A brief description about the Attribute Definition.

    You can enter up to 100 characters. All characters are allowed except " & ' + @ and ~.

    Attribute Properties
    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:

    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 in the dimension's underlying attribute table.

    The maximum value of the NUMBER is set to 22.
    Dimension

    Select the Dimension to be associated with the new Attribute Definition.

    This field is enabled only if the Data Type is set to Dimension.
    Default Value

    The Default Value is set based on the selected Data Type. The Default Value is mandatory if this attribute is set as a Required Attribute.

    • If Dimension is set as the Data Type, select the Default Value from the drop-down list of members mapped to the selected Dimension.
    • 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 the Alphanumeric Value in the Default Value field.

    The Maximum characters allowed in Default Value field for String Data Type is 1000.
    Required Attribute
    • Yes - This Attribute is mandatory for the associated Dimension Members.
    • No - This is an optional Attribute for the associated Dimension Members.

    This field is disabled in Add and Edit Modes if any members already exist for the Dimension on which this attribute is defined.
    Seeded Value
    • Yes – This is selected only when the attribute is seeded out of box by the Cloud Service.
    • No – Always select this when you are creating a new attribute.
  3. Click Save.