ANALYSIS_MODEL_IDM=Mapped
U=Unmapped
Default Value: U
DIMENSION_IDPrompt Table: %EDITTABLE
A=Cube Attribute
N=Dimension
Y=Measure
Default Value: N
ANL_MOD_DIM(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ANALYSIS_MODEL_ID |
Character(15) | VARCHAR2(15) NOT NULL | Cube Definition ID |
| 2 | CUBE_SRC_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Cube Source Status
M=Mapped U=Unmapped Default Value: U |
| 3 | DIMENSION_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Dimension/Measure/Attribute
Prompt Table: %EDITTABLE |
| 4 | MEASURES_DIM_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Cube Component Role
A=Cube Attribute N=Dimension Y=Measure Default Value: N |