Description of the illustration prod_hierview.gif
Product Primary Hierarchy View: This screen capture of the hierarchy view for the Product Primary hierarchy shows a crosstab describing the columns of the view. The Dimension Name is PRODUCT, the Hierarchy Name is PRIMARY, and the View Name is PRODUCT_PRIMARY_VIEW. The columns of the view are described in a table with these columns: Column Name, Data Type, and Object Type. These are the rows of the table, which describe the columns of the view:
-
DIM_KEY VARCHAR2 Key
-
LEVEL_NAME VARCHAR2 Level Name
-
PARENT VARCHAR2 Parent
-
TOTAL VARCHAR2 Hierarchy Level
-
CLASS VARCHAR2 Hierarchy Level
-
FAMILY VARCHAR2 Hierarchy Level
-
ITEM VARCHAR2 Hierarchy Level
-
PACKAGE VARCHAR2 Attribute
-
BUYER VARCHAR2 Attribute
-
MARKETING_MANAGER VARCHAR2 Attribute
-
LONG_DESCRIPTION VARCHAR2 Attribute
-
SHORT_DESCRIPTION VARCHAR2 Attribute