| Converting from Oracle Express Objects to Standard Form [message #252835] |
Fri, 20 July 2007 04:00 |
kubcio
Messages: 1
Registered: July 2007
|
Junior Member |
|
|
Converting from Oracle Express Objects to Standard Form
Hello
I try to import database from Oracle Express Server to OLAP 10g. I do everything, step by step, like in OracleŽ OLAP Application Developer's Guide 10g Release 1 (10.1). But I have problem with Create the TIME_END_DATE and TIME_TIME_SPAN variables. When I define new INTEGER or DATE variable
(DEFINE time_end_date VARIABLE DATE <TIME T0.HIERDIM>)
I get error message:
ORA-34492: Analytic workspace object AWM!T0.HIERDIM does not exist.
What is hierdim (t0.hierdim)? IMHO it is value of TIME dimmension property HIERDIM.
In DML Reference I checked that after datatype (DATE) can be only dim/dims
DEFINE name [VARIABLE] datatype [<dims...>] [WITH AGGCOUNT] [PERMANENT | TEMP ] -
[(partition-instance...)] [WIDTH n] [AWworkspace] [SESSION]
Where is the problem. What I did wrong?
(analytic workspace was attached)
I'm using a xademo database from express. It is also used in OLAP Application Developer's Guide
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
