Dimensions [message #22715] |
Wed, 23 October 2002 22:55 |
rajesh
Messages: 173 Registered: November 1998
|
Senior Member |
|
|
I want to create a dimension and hierarchy. I created the table location as follows
CREATE TABLE location (
city VARCHAR2(30),
state VARCHAR2(30),
country VARCHAR2(30),
mayor VARCHAR2(30),
governor VARCHAR2(30) );
I created the dimension location_dim as follows
CREATE DIMENSION location_dim
LEVEL city IS location.city
LEVEL state IS location.state
LEVEL country IS location.country
But when i try to create the hierarchy loc_rollup as follows,
HIERARCHY loc_rollup (
city CHILD OF
state CHILD OF
country )
I get the following error
SQL> HIERARCHY loc_rollup (
SP2-0734: unknown command beginning "HIERARCHY ..." - rest of line ignored.
SQL>
SQL> city CHILD OF
SP2-0734: unknown command beginning "city C..." - rest of line ignored.
SQL> state CHILD OF
SP2-0734: unknown command beginning "state C..." - rest of line ignored.
SQL> country )
SP2-0042: unknown command "country )" - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
What is going wrong? Please reply to my email id.
|
|
|
|