Home » Developer & Programmer » Warehouse Builder » Converting from Oracle Express Objects to Standard Form
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
Previous Topic: 'IN' is not a valid integer value
Next Topic: Question OWB 10.1.0.4.0
Goto Forum:
  


Current Time: Sat Aug 23 05:19:04 CDT 2014

Total time taken to generate the page: 0.09320 seconds