Re: OLAP Configuration

Nobody else has a clue or anything?

thank you

marcio.portes_at_uol.com.br (Marcio Portes) wrote in message news:<dfea13a7.0406241310.7a057123_at_posting.google.com>...
> 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 Wed Jun 30 2004 - 21:59:50 CDT