PSCUBDIM2_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.

PSCUBDIM2_VW

(SQL View)

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 , CUB_BLANK_MEMBER FROM PSCUBDIMENSION WHERE CUB_DIMTYPE <> 'X'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CUB_DIMENSIONID2 Character(30) VARCHAR2(30) NOT NULL Dimension Name

2 CUB_DIMTYPE Character(1) VARCHAR2(1) NOT NULL Dimension Type
A=Accounts
C=Country
D=Date-Time
S=None
T=Time
X=Attribute

3 CUB_BLANK_MEMBER Character(30) VARCHAR2(30) NOT NULL Blank Member

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CUB_DIMENSIONID2	Character(30)	VARCHAR2(30) NOT NULL	Dimension Name
2	CUB_DIMTYPE	Character(1)	VARCHAR2(1) NOT NULL	Dimension Type A=Accounts C=Country D=Date-Time S=None T=Time X=Attribute
3	CUB_BLANK_MEMBER	Character(30)	VARCHAR2(30) NOT NULL	Blank Member