 |
|
Oracle Tips by Burleson |
Chapter 7 Oracle Storage and Object
Internal Scripting
Dimension Level Column Key
Owner Name Name Name Position
-------- ---------- ---------- -------------------- ---------
TELE_DBA TEST_DIM CHILD_ID ID 1
TEST_DIM PARENT_ID PARENT_ID 1
The database dimension-level report should be
reviewed to ensure that the levels are assigned to the proper
columns.
Reports showing the relationship of dimension
to hierarchy and dimension and attribute are shown below. The output
is similar to previous reports.
dim_hierarchies.sql
--**********************************************
--
-- Copyright © 2003 by Rampant TechPress Inc.
--
-- Free for non-commercial use.
-- For commercial licensing, e-mail info@rampant.cc
--
-- *********************************************
rem
rem NAME: dim_hierarchies.sql
rem FUNCTION: Generate a lit of all dimensions and hierarchies in
the
rem database for a specific user or all users
rem HISTORY: MRA 5/12/98 Created
rem
| 
