Re: OLAP Configuration

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