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