ANALYSIS_DB_IDDefault Value: ANALYSIS_DB.ANALYSIS_DB_ID
DIMENSION_IDPrompt Table: %EDITTABLE15
A=Default
D=Dense
S=Sparse
Default Value: A
ANALYSIS_DB_DIM(SQL Table) |
Index Back |
|---|---|
Cube Instance Def Dimension |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ANALYSIS_DB_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Cube Instance ID
Default Value: ANALYSIS_DB.ANALYSIS_DB_ID |
| 2 | DIMENSION_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Dimension/Measure/Attribute
Prompt Table: %EDITTABLE15 |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | SEQUENCE_NBR_6 | Number(6,0) | INTEGER NOT NULL | Sequence |
| 5 | ESS_DIM_SPARSITY | Character(1) | VARCHAR2(1) NOT NULL |
Sparsity
A=Default D=Dense S=Sparse Default Value: A |