This discussion is archived
0 Replies Latest reply: Feb 27, 2007 2:03 AM by 564173 RSS

ORA-00942 in CREATE DIMENSION

564173 Newbie
Currently Being Moderated
Hello! I have a problem. Execution of

CREATE DIMENSION DB_OLAP_EXMPL.CUSTOMER_DIM
LEVEL LVL_CUSTOMERS_CONTINENT IS (customer.id_continent)
LEVEL LVL_CUSTOMERS_COUNTRY IS (customer.id_country)
LEVEL LVL_CUSTOMERS IS (customer.id)
HIERARCHY CUSTOMER_HIER ( LVL_CUSTOMERS CHILD OF LVL_CUSTOMERS_COUNTRY CHILD OF LVL_CUSTOMERS_CONTINENT )
ATTRIBUTE LVL_CUSTOMERS_CONTINENT DETERMINES (customer.id_continent)
ATTRIBUTE LVL_CUSTOMERS_COUNTRY DETERMINES (customer.id_continent, customer.id_country)
ATTRIBUTE LVL_CUSTOMERS DETERMINES ( customer.id_continent, customer.id_country, customer.id)

gives me
[Error] Script lines: 1-8 --------------------------
ORA-00942: table or view does not exist

Tables exist, the names are written correctly. User has the following
ROLES:
CONNECT
DBA
OLAP_DBA
RESOURSE
SALES_HISTORY_ROLE
SELECT_CATALOG_ROLE

SYSTEM PRIVILEGES
ANALYZE ANY
CREATE ANY DIMENSION
CREATE DIMENSION
GRANT ANY PRIVILEGE
GRANT ANY ROLE
SELECT ANY TABLE
UNLIMITED TABLESPACE

I use Aqua Data Studio 4.5.2.
Any ideas?