ANL_DB_DIM_VW

 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 Field Type Column Type Description
ANALYSIS_DB_ID Character(15) VARCHAR2(15) NOT NULL Cube Instance ID
DIMENSION_ID Character(30) VARCHAR2(30) NOT NULL Dimension/Measure/Attribute
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20