OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » dimensions

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

dimensions [message #227976]

Fri, 30 March 2007 09:06

chaits85
Messages: 2
Registered: March 2007

Junior Member

I want to create a dimension hierarchy on a table 'time' but am unable to create it. I'm putting the structure of the table as well as the message oracle gives when i try to create the hierarchy. pls help.

Structure of table 'time' :

create table time
(timeid char(4) primary key,
day char(3),
week number,
month number,
quarter number,
year number
);

Dimension:

SQL> CREATE DIMENSION timedim
2 LEVEL DAY IS (time.day)
3 LEVEL WEEK IS (time.week)
4 LEVEL MONTH IS (time.month)
5 LEVEL QUARTER IS (time.quarter)
6 LEVEL YEAR IS (time.year)
7 HIERARCHY TIME_ROLLUP
8 (
9 day CHILD OF
10 week CHILD OF
11 month CHILD OF
12 quarter CHILD OF
13 year
14 )
15 /
CREATE DIMENSION timedim
*
ERROR at line 1:
ORA-04044: procedure, function, package, or type is not allowed here

Report message to a moderator