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 NameField TypeColumn TypeDescription
ANALYSIS_DB_IDCharacter(15)VARCHAR2(15) NOT NULLCube Instance ID
DIMENSION_IDCharacter(30)VARCHAR2(30) NOT NULLDimension/Measure/Attribute
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19