DIM_TREE_VW (SQL View)	Index Back
Dim Rollup Tree View Displays Tree Name for Primary Rollup of the Dimension.

DIM_TREE_VW

(SQL View)

Dim Rollup Tree View

Displays Tree Name for Primary Rollup of the Dimension.

SELECT DISTINCT DIMENSION_ID , %Substring(QRYNAME, 1,18) FROM PS_DIM_DATA_SRC WHERE SEQUENCE_NBR = 1 AND TREE_NODE <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DIMENSION_ID	Character(30)	VARCHAR2(30) NOT NULL	Dimension/Measure/Attribute
2	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name