3 Replies Latest reply on Mar 21, 2013 10:52 PM by DavidGreenfield

    AWM CUBE Maintainance

    user10048382
      We have schema "OOWAAPP".

      In AWM I have created "PEN_NB2_STD" workspace.

      Under that I have created CUBE "ANTAL_PERSONER_CUBE" which is based on View.

      I want to do incremental load by changing value in View condition.

      Could you please give me sample loading script which I can run.

      I tried as below

      BEGIN
      DBMS_CUBE.BUILD('PEN_NB2_STD.ANTAL_PERSONER_CUBE USING (CLEAR, LOAD, SOLVE)','S',false,1,true,true,false);
      END;



      Error:--
      ORA-37162: OLAP error
      XOQ-01710: unknown build item "PEN_NB2_STD.ANTAL_PERSONER_CUBE"
      ORA-06512: at "SYS.DBMS_CUBE", line 234
      ORA-06512: at "SYS.DBMS_CUBE", line 287
      ORA-06512: at line 2


      BEGIN
      DBMS_CUBE.BUILD('OOWAAPP.PEN_NB2_STD.ANTAL_PERSONER_CUBE USING (CLEAR, LOAD, SOLVE)','S',false,1,true,true,false);
      END;

      eRROR:'
      ORA-37162: OLAP error
      XOQ-01703: error during parse of build process script: "BUILD OOWAAPP.PEN_NB2_STD.ANTAL_PERSONER_CUBE USING (CLEAR, LOAD, SOLVE)", ""
      ORA-06512: at "SYS.DBMS_CUBE", line 234
      ORA-06512: at "SYS.DBMS_CUBE", line 287

      Edited by: user10048382 on Mar 21, 2013 11:20 AM