ANALYSIS_MODEL_IDDefault: ANL_MOD_DAT_SRC.ANALYSIS_MODEL_ID
QRYNAMEDefault: ANL_MOD_DAT_SRC.QRYNAME
Prompt Table: QRY_FLD_HDNG_VW
Prompt Table: ANL_MOD_DIM
Default: 1
ANL_MOD_DIM_FLD |
index back |
|---|
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| ANALYSIS_MODEL_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Cube Definition ID
Default: ANL_MOD_DAT_SRC.ANALYSIS_MODEL_ID |
| QRYNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Query Name
Default: ANL_MOD_DAT_SRC.QRYNAME |
| QRYFLDNAME | Character(30) | VARCHAR2(30) NOT NULL |
Source Field
Prompt Table: QRY_FLD_HDNG_VW |
| DIMENSION_ID | Character(30) | VARCHAR2(30) NOT NULL |
Dimension/Measure/Attribute
Prompt Table: ANL_MOD_DIM |
| COMPONENT_NBR | Number(3,0) | SMALLINT NOT NULL |
Component Number
Default: 1 |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |