This content has been marked as final. Show 5 replies
Under AWM mapping, click on "Show SQL" button and see if you can execute that SQL manually (in SQL*Developer).
Thanks for the reply, but i couldn't figure out any option or button which gives sql. I am using latest AWM (version 220.127.116.11.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:
Click on the 'Mappings'
In the right-window, you will see the mappings and under that there are three buttons:
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.
It is strange that the "Show SQL" button is not showing up in your AWM session.
Open up SR for this. Someone from OLAP development will probably help.