2 Replies Latest reply: Oct 31, 2012 8:59 PM by 950654 RSS

    Error deleting CUBE

    950654
      hello good day

      I have the following problem.

      I have a bucket called 'mt_met' which I need to remove

      But when I click to delete cube brand me the following errors.

      *
      XOQ-01961: Object Cube "ODI_FIN.MT_MET" can not be dropped while it is still a dependency of Cube Build Process "ODI_FIN.SOLVE".
      XOQ-01961: Object Cube "ODI_FIN.MT_MET" can not be dropped while it is still a dependency of Cube Build Process "ODI_FIN.SOLVE12".
      XOQ-01961: Object Cube "ODI_FIN.MT_MET" can not be dropped while it is still a dependency of Cube Build Process "ODI_FIN.SUMM".
      XOQ-01961: Object Cube "ODI_FIN.MT_MET" can not be dropped while it is still a dependency of Cube Build Process "ODI_FIN.SUM".


      To create a maintenance script:

      "ODI_FIN.SOLVE"
      "ODI_FIN.SOLVE12".
      "ODI_FIN.SUMM".
      "ODI_FIN.SUM".


      These maintenance script when I click In the navigation tree to create the script does not appear maintenance I can not delete,

      I need help.

      Deleting the maintenance script or I can remove my cube and delete the dependency and check the error by clearing.

      Please helpme
        • 1. Re: Error deleting CUBE
          DavidGreenfield
          To remove the cube build processes you can try this. (Close AWM before running it.)
          begin
          dbms_cube.import_xml(
          '<Metadata Version="1.0">
            <NamedBuildProcess Name="SOLVE" Owner="ODI_FIN" Action="REMOVE"/>
            <NamedBuildProcess Name="SOLVE12" Owner="ODI_FIN" Action="REMOVE"/>
            <NamedBuildProcess Name="SUMM" Owner="ODI_FIN" Action="REMOVE"/>
            <NamedBuildProcess Name="SUM" Owner="ODI_FIN" Action="REMOVE"/>
          </Metadata>');
          end;
          /
          • 2. Re: Error deleting CUBE
            950654
            Thanks

            the problem was resolve

            best regards