Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1088056066.72063_at_yasure>...
> 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?
Yes I did.
Though, how can I confirm that?
Received on Thu Jun 24 2004 - 16:10:06 CDT
