2 Replies Latest reply: Jun 26, 2013 10:44 AM by 1001997 RSS

    How to rename a CUBE in awm

    1001997

      I have created a cube in awm, but now I Have to rename the name of the cube. What is the command to do that?

       

      Thanks

        • 1. Re: How to rename a CUBE in awm
          DavidGreenfield

          You should be able to do it in AWM as long as you have a recent enough version (11.2.0.2?). 

           

          1. Select the cube in the navigation
          2. Modify the name field
          3. Press Apply

           

          You can also do it using PL/SQL (as long as the AW is not attached by any other session.)  Just replace "OLD_CUBE_NAME" and "NEW_CUBE_NAME" as appropriate.  This assumes you are running as the owner of the cube.

           

          begin

            dbms_cube.import_xml(

             '<Metadata Version = "1.2">

               <Cube Name = "OLD_CUBE_NAME"  NewName = "NEW_CUBE_NAME"  ETViewName = ""/>

             </Metadata>');

          end;

          /

          • 2. Re: How to rename a CUBE in awm
            1001997

            Thanks . Resolved