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 |