To add dimension attributes:
Enter the following:
Name
Description
Key Attribute
Select Key Attribute if this attribute is the key attribute.
Data Type
Select one:
Date
Date and Time
Integer
List
Do one:
Click Add, and then enter values for the attribute.
To import or export list items from a CSV file, click Import or Export
.
Note:
This feature is available only in 11.1.2.4.101 (patch 21357574). For information about new features and updating to release 11.1.2.4.101, see My Oracle Support https://support.oracle.com/.
Select Import Type to have any new import add items to the end of the list.
Number
If you select Number, select formatting options (The defaults are set in the Preferences section of the System Settings:
For Decimal Places, enter a value for the number of decimal places to be displayed.
Select Display as Percentage to display a percent sign.
Select Thousands Separator to display a thousands separator (for example, 1,000.00). The system displays the thousands separator symbol for the user locale.
In Negative Number, select how to display negative numbers; for example, (123).
Text (255 characters maximum)
True or False
Yes or No
Default Value
The attribute is populated with this value by default, which you can override.
Note:
The system allows multiple attributes as key for a dimension.