OLAP Configuration

From: Marcio Portes <marcio.portes_at_uol.com.br>
Date: 23 Jun 2004 20:33:48 -0700
Message-ID: <dfea13a7.0406231933.7dc4f6b1@posting.google.com>

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. Received on Wed Jun 23 2004 - 22:33:48 CDT