This content has been marked as final. Show 2 replies
For all these kind of things, just save your AW to an xml file and then take the appropriate tags and run the DBMS_CUBE.IMPORT_XML command.
I did that on my AW and I was able to come up with the following code, which worked fine.
dbms_cube.import_xml( to_clob( q'!
In some cases, you may have to provide the Version and Minimum database version with the <Metadata> tag, which you can also get from your xml file.
*<Metadata Version="1.3" MinimumDatabaseVersion="18.104.22.168">*
Edited by: Nasar Ali-Khan on Oct 5, 2012 7:43 AM
Thank you, Nassar. It worked like a charm.
For any skeptical people reading this: dbms_cube.import_xml only modifies the tags you include. The rest of the Analytic Workspace remains untouched.