ANL_DB_DIM_VW

(SQL View)
 Index Back

Cube Def Dim View

Finds Cube Def (i.e. analysis_model) components that are Dimension's.

select PS_ANALYSIS_DB_DIM.ANALYSIS_DB_ID, PS_ANALYSIS_DB_DIM.DIMENSION_ID from PS_ANALYSIS_DB_DIM, PS_ANALYSIS_DB where PS_ANALYSIS_DB_DIM.ANALYSIS_DB_ID=PS_ANALYSIS_DB.ANALYSIS_DB_ID and exists (select 'X' from PS_ANL_MOD_DIM where ANALYSIS_MODEL_ID= PS_ANALYSIS_DB.ANALYSIS_MODEL_ID and DIMENSION_ID=PS_ANALYSIS_DB_DIM.DIMENSION_ID and measures_dim_flg='N')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ANALYSIS_DB_ID Character(15) VARCHAR2(15) NOT NULL Cube Instance ID
2 DIMENSION_ID Character(30) VARCHAR2(30) NOT NULL Dimension/Measure/Attribute