Re: OLAP Configuration

Marcio Portes wrote:

> I was trying get start with sql model, but get this message.
> What is wrong?
>
> I am on XP Professional with 10.1.0 (10g).
>
> SQL> insert into t
> 2 select rownum, rownum+10
> 3 from all_objects
> 4 where rownum <= 10
> 5 /
>
> 10 rows created.
>
> SQL>
> SQL> create or replace view v as select empno, rownum rn, sal from t;
>
> View created.
>
> SQL>
> SQL>
> SQL> select empno, rn, sal
> 2 from v
> 3 model
> 4 partition by ( empno )
> 5 dimension by ( rn )
> 6 measures ( sal )
> 7 rules
> 8 ( sal [ any ] = 2 * sal [ cv(rn) ] );
> from v
> *
> ERROR at line 2:
> ORA-37002: Oracle OLAP failed to initialize. Please contact Oracle
> OLAP technical support.
> ORA-33262: Analytic workspace EXPRESS does not exist.

Did you install the OLAP functionality during the install?

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)