PSCUBDIM_VW

(SQL View)
 Index Back

Cube Dimension Builder

View to ignore attribute dimensions. Attribute dimensions can only be added from within the component, not through normal Add processing.

SELECT CUB_DIMENSIONID , CUB_DIMTYPE FROM PSCUBDIMENSION WHERE CUB_DIMTYPE <> 'X'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CUB_DIMENSIONID Character(30) VARCHAR2(30) NOT NULL Dimension Name (see PSCUBDIMENSION).
2 CUB_DIMTYPE Character(1) VARCHAR2(1) NOT NULL Dimension Type
A=Accounts
C=Country
D=Date-Time
S=None
T=Time
X=Attribute