I am running into a problem when i try to maintain any dimension or cube in Analytic Workspace Manager(version 22.214.171.124.0). I get the following error. oracle.AWXML.AWException: Action BUILDDATABASE failed on object RRR_DWH_OWNER.TEST at oracle.AWAction.BuildDatabase.Execute(Unknown Source) at oracle.olap.awm.wizard.awbuild.BuildWizardHelper$1.construct(BuildWizardHelper.java:167) at oracle.olap.awm.ui.SwingWorker$2.run(SwingWorker.java:109) at java.lang.Thread.run(Thread.java:619) Caused by: oracle.AWXML.AWException: ***Error Occured: Error Validating Dimension Mappings PRODUCTS.DIMENSION. Key Expression RRR_DWH_OWNER.RRR_PRODUCTS.ID for Mapping Group PRODUCTS.PRODUCTS_HIERARCHY.PRODUCT.MAPGROUP1.DIMENSIONMAPGROUP, Level PRODUCTS.PRODUCT.LEVEL, Hierarchy PRODUCTS.PRODUCTS_HIERARCHY.HIERARCHY is Incorrectly Mapped to RDBMS.
+... 4 more+
I tried everything but couldn't resolve it.
Kindly help here.
Thanks for the reply, but i couldn't figure out any option or button which gives sql. I am using latest AWM (version 126.96.36.199.0).
Can you please tell me the exact location where i can find this option.
In AWM, open up the cube. Click on + sign next to cube.
Under that you will see five nodes: Measures Calculated Measures Mappings Views Cube Scripts
Click on the 'Mappings'
In the right-window, you will see the mappings and under that there are three buttons: Show SQL Apply Revert
Click on 'Show SQL' button to see the sql.
Cut/paste the sql into SQL*developer and see if you can execute it.
I tried my best to find this sql script option but couldn't spot one. Please refer to this snapshot [http://dl.dropbox.com/u/2249237/awm.PNG], there is nothing other than Apply and Revert.
Can you tell me what can be the possible reasons for this kind of error, because I have gone through my cube and dimensions mappings over and over again but couldn't find a way to fix it.