0 Replies Latest reply: Feb 27, 2007 4:03 AM by 564173 RSS

    ORA-00942 in CREATE DIMENSION

    564173
      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?