CUBE_AGG_DIM

index back

PeopleSoft Field Name Field Type Column Type Description
ANALYSIS_DB_ID Character(15) VARCHAR2(15) NOT NULL Cube Instance ID

Default: CUBE_AGG_DEF.ANALYSIS_DB_ID

AGGREGATE_ID Number(4,0) SMALLINT NOT NULL Aggregate ID

Default: CUBE_AGG_DEF.AGGREGATE_ID

DIMENSION_ID Character(30) VARCHAR2(30) NOT NULL Dimension/Measure/Attribute

Prompt Table: ANL_DB_DIM_VW

SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number

Prompt Table: DIM_ROLLUP

DIM_LEVEL_NAME Character(30) VARCHAR2(30) NOT NULL Dim Level Name

Prompt Table: DIM_ROLLUP_LVL

LEVELS_FROM_TOP Number(3,0) SMALLINT NOT NULL Levels From Top

Prompt Table: TREE_LVL_VW

index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19