BASE_CUBE3_VW (SQL View)	Index Back
Base Cube Def View Finds Cube Def's (i.e. Analysis Model) that are used as a base cube definition.

BASE_CUBE3_VW

(SQL View)

Base Cube Def View

Finds Cube Def's (i.e. Analysis Model) that are used as a base cube definition.

select ANALYSIS_MODEL_ID, DESCR from PS_ANALYSIS_MODEL where ANALYSIS_MODEL_ID in (select distinct ANALYSIS_MODEL_ID from PS_ANALYSIS_DB)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ANALYSIS_MODEL_ID Character(15) VARCHAR2(15) NOT NULL Cube Definition ID

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ANALYSIS_MODEL_ID	Character(15)	VARCHAR2(15) NOT NULL	Cube Definition ID
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description