DIM_ROLLUP

index back

Dimension Rollup


  • Parent record: DIMENSION
  • PeopleSoft Field NameField TypeColumn TypeDescription
    DIMENSION_IDCharacter(30)VARCHAR2(30) NOT NULLDimension/Measure/Attribute
    SEQUENCE_NBRNumber(2,0)SMALLINT NOT NULLSequence Number

    Default: 1

    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    MEMBER_SOURCECharacter(1)VARCHAR2(1) NOT NULLRollup Type
    B=Tree + Queries
    Q=Queries
    T=Tree
    U=Undefined

    Default: U

    DECOR_TYPECharacter(1)VARCHAR2(1) NOT NULLDecoration Type
    N=None
    P=Prefix
    S=Suffix

    Default: N

    DECOR_STYLECharacter(1)VARCHAR2(1) NOT NULLDecoration Style
    C=Custom
    D=Dimension Name
    L=Level Name
    DECORATIONCharacter(30)VARCHAR2(30) NOT NULLCustom Text
    DECOR_TYPE_DTLCharacter(1)VARCHAR2(1) NOT NULLDetail Decoration Type
    N=None
    P=Prefix
    S=Suffix

    Default: N

    DECOR_STYLE_DTLCharacter(1)VARCHAR2(1) NOT NULLDetail Decoration Style
    C=Custom
    D=Dimension Name
    L=Level Name
    DECORATION_DTLCharacter(30)VARCHAR2(30) NOT NULLDetail Custom Text
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19