BASE_CUBE_INST_IDPrompt Table: BASE_CUBE3_VW
ESS=Hyperion Essbase
IAS=PS/ROLAP
MOS=Microsoft OLAP Services
PPL=Cognos PowerPlay
STS=Generic Star Schema
BASE_CUBE2_VW(SQL View) |
Index Back |
|---|---|
Base Cube Instance ViewFinds Cube Instance Def's that are used as a base cube. Also, note that the field BASE_CUBE_VW.BASE_CUBE_INST_ID is actually mapped to the ANALYSIS_DB.ANALYSIS_DB_ID column. |
| select ANALYSIS_DB_ID, ANALYSIS_MODEL_ID, DESCR, ANALYSIS_PLATFORM, VIRTUAL_CUBE_FLAG from PS_ANALYSIS_DB where ANALYSIS_DB_ID in (select distinct BASE_CUBE_INST_ID from PS_ANALYSIS_DB) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BASE_CUBE_INST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Base Cube Instance ID |
| 2 | ANALYSIS_MODEL_ID | Character(15) | VARCHAR2(15) NOT NULL |
Cube Definition ID
Prompt Table: BASE_CUBE3_VW |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | ANALYSIS_PLATFORM | Character(3) | VARCHAR2(3) NOT NULL |
Analysis Platform
ESS=Hyperion Essbase IAS=PS/ROLAP MOS=Microsoft OLAP Services PPL=Cognos PowerPlay STS=Generic Star Schema |
| 5 | VIRTUAL_CUBE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Virtual Cube Flag |