Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: OLAP Configuration

Re: OLAP Configuration

From: Joel Garry <joel-garry_at_home.com>
Date: 6 Jul 2004 16:37:24 -0700
Message-ID: <91884734.0407061537.3a8fee40@posting.google.com>


marcio.portes_at_uol.com.br (Marcio Portes) wrote in message news:<dfea13a7.0406231933.7dc4f6b1_at_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.

Don't know much about it, but
http://download-west.oracle.com/docs/cd/B10501_01/olap.920/a95298/basics3.htm#1005704 or http://download-west.oracle.com/docs/cd/B10501_01/olap.920/a95295/cloner2.htm#1010182 seem to be appropriate. I'm guessing your workspace doesn't exist or was created somewhere your current user doesn't have access.

jg

--
@home.com is bogus.
"This is one of the worst and most dangerous court decisions ever
to appear relating to the Internet." - Lauren Weinstein:
http://www.ca1.uscourts.gov/pdf.opinions/03-1383-01A.pdf
Received on Tue Jul 06 2004 - 18:37:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US