CUBE_AGG_DIM

index back

PeopleSoft Field NameField TypeColumn TypeDescription
ANALYSIS_DB_IDCharacter(15)VARCHAR2(15) NOT NULLCube Instance ID

Default: CUBE_AGG_DEF.ANALYSIS_DB_ID

AGGREGATE_IDNumber(4,0)SMALLINT NOT NULLAggregate ID

Default: CUBE_AGG_DEF.AGGREGATE_ID

DIMENSION_IDCharacter(30)VARCHAR2(30) NOT NULLDimension/Measure/Attribute

Prompt Table: ANL_DB_DIM_VW

SEQUENCE_NBRNumber(2,0)SMALLINT NOT NULLSequence Number

Prompt Table: DIM_ROLLUP

DIM_LEVEL_NAMECharacter(30)VARCHAR2(30) NOT NULLDim Level Name

Prompt Table: DIM_ROLLUP_LVL

LEVELS_FROM_TOPNumber(3,0)SMALLINT NOT NULLLevels From Top

Prompt Table: TREE_LVL_VW

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