SDM_DIMENSION_ATTRIBUTE

This table stores all attributes of each dimension.

Details

Object type: TABLE

Primary Key

Table 4-47 Primary Key Table

Constraint Name	Columns
SDM_DIM_ATTRIB_PK	DIMENSION_ATTRIBUTE_ID

Details

Object type: TABLE

Foreign Key

Table 4-48 Foreign Key Table

Table	Foreign Table	Foreign Key Column
SDM_DIMENSION_ATTRIBUTE	SDM_DIMENSION_ATTRIBUTE	REFERENCE_ATTRIB_ID
SDM_DIMENSION_ATTRIBUTE	SDM_DIMENSION	DIMENSION_ID

Columns

Table 4-49 Column Details Table

Name	Data Type	Length	Precision	Scale	Null Allowed	Comments
DIMENSION_ATTRIBUTE_ID	NUMBER		18	0	No	Unique identifier of the record.
DIMENSION_ID	NUMBER		18	0	No	Dimension, to which, this attribute belongs. Refers to DIMENSION_ID of SDM_DIMENSION table.
NAME	VARCHAR2	80			No	Name of the attribute.
DATA_TYPE	VARCHAR2	20			No	Data Type of the attribute, for example, Date, Date/Time, List, Integer, Number, Text, Boolean.
IS_KEY	CHAR	1			No	Indicates whether this attribute is a key or not. Value is Y or N.
USE_DEFAULT_VALUE	CHAR	1			No	Indicates whether default value should be used or not. Default value is stored in DEFAULT_VALUE column. Value is Y or N.
ATTRIBUTE_ORDER	NUMBER		4	0	No	Indicates the order, in which, attributes should be displayed.
ATTRIB_TYPE_INTERNAL	VARCHAR2	40			No	Indicates type of the attribute, for example, ScenarioName, ScenarioDescription, EntityName, EntityDescription, EntityCurrency, UserDefined.
DESCRIPTION	VARCHAR2	1000			Yes	Description of the attribute.
DEFAULT_VALUE	VARCHAR2	1000			Yes	If USE_DEFAULT_VALUE is Y and DATA_TYPE is Text, YesNo, TrueFalse or List then corresponding default value is stored here.
DEFAULT_VALUE_NUM	NUMBER		29	12	Yes	If USE_DEFAULT_VALUE is Y and DATA_TYPE is Integer or Number then corresponding default value is stored here.
DEFAULT_VALUE_DATE	DATE				Yes	If USE_DEFAULT_VALUE is Y and DATA_TYPE is Date or DateTime then corresponding default value is stored here.
DECIMAL_PLACES	NUMBER		2	0	Yes	Indicates number of decimal places when data type of the attribute is Number.
USE_THOUSAND_SEPARATOR	CHAR	1			Yes	Indicates whether thousand separator should be used to display a number or not. Value is Y or N.
IS_PERCENTAGE	CHAR	1			Yes	Indicates whether it should be displayed as percentage or not. Value is Y or N.
NEGATIVE_NUMBER_FORMAT	VARCHAR2	10			Yes	Indicates format of negative number display, for example, -123 or (123)
REFERENCE_ATTRIB_ID	NUMBER		18	0	Yes	When attribute references attribute of another dimension. Refers to DIMENSION_ATTRIBUTE_ID of SDM_DIMENSION_ATTRIBUTE table.
DB_COLUMN_NAME	VARCHAR2	100			Yes	For each dimension, one table is created dynamically to store the members. This field indicates the database column name, where, value of this attribute is stored.
APP_ID	NUMBER		1	0	No	Identifier for the application to which the row corresponds to, for example, SDM:4.
OBJECT_VERSION_NUMBER	NUMBER		9	0	No	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
LAST_UPDATE_LOGIN	VARCHAR2	255			Yes	Who column: indicates the session login associated to the user who last updated the row.
LAST_UPDATED_BY	VARCHAR2	255			No	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	DATE				No	Who column: indicates the date and time of the last update of the row.
CREATED_BY	VARCHAR2	255			No	Who column: indicates the user who created the row.
CREATION_DATE	DATE				No	Who column: indicates the date and time of the creation of the row.

Indexes

Table 4-50 Index Table

Index	Uniqueness	Columns
SDM_DIM_ATTRIB_PK	UNIQUE	DIMENSION_ATTRIBUTE_ID
SDM_DIM_ATTRIB_U1_DIM_NAME	UNIQUE	DIMENSION_ID, SYS_NC00026$