[Home] [Help] [Dependency Information]
Object Name: | BSC_SYS_DIM_LEVELS_BY_GROUP |
---|---|
Object Type: | TABLE |
Owner: | BSC |
FND Design Data: | BSC.BSC_SYS_DIM_LEVELS_BY_GROUP |
Subobject Name: | |
Status: | VALID |
BSC_SYS_DIM_LEVELS_BY_GROUP stores information about the dimension groups
such as dimension group identifier and dimension level identifier. Some of the dimension level properties are set at this level for instance total and comparison flag.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BSC_SYS_DIM_LEVELS_BY_GROUP_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
DIM_GROUP_ID
DIM_LEVEL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DIM_GROUP_ID | NUMBER | (5) | Yes | Dimension group identifier |
DIM_LEVEL_ID | NUMBER | (5) | Yes | Dimension level identifier |
DIM_LEVEL_INDEX | NUMBER | (3) | Yes | Dimension level index |
TOTAL_FLAG | NUMBER | (1) | Yes | Flag to indicate if the TOTAL item applies |
COMPARISON_FLAG | NUMBER | (1) | Yes | Flag to indicate if the COMPARISON item applies |
FILTER_COLUMN | VARCHAR2 | (30) | The column to use in condition | |
FILTER_VALUE | NUMBER | The filter value for condition | ||
DEFAULT_VALUE | VARCHAR2 | (2) | Option Default , 'T'= by total, 'C'= by comparison | |
DEFAULT_TYPE | NUMBER | (5) | How to handle default_value, when dimension set is changed | |
PARENT_IN_TOTAL | NUMBER | (3) | Behavior when dimension parent is in TOTAL | |
NO_ITEMS | NUMBER | (1) | If there are not items the drill will be disabled | |
WHERE_CLAUSE | VARCHAR2 | (4000) | where clause statement |
Cut, paste (and edit) the following text to query this object:
SELECT DIM_GROUP_ID
, DIM_LEVEL_ID
, DIM_LEVEL_INDEX
, TOTAL_FLAG
, COMPARISON_FLAG
, FILTER_COLUMN
, FILTER_VALUE
, DEFAULT_VALUE
, DEFAULT_TYPE
, PARENT_IN_TOTAL
, NO_ITEMS
, WHERE_CLAUSE
FROM BSC.BSC_SYS_DIM_LEVELS_BY_GROUP;
BSC.BSC_SYS_DIM_LEVELS_BY_GROUP does not reference any database object
BSC.BSC_SYS_DIM_LEVELS_BY_GROUP is referenced by following:
|
|
|