This content has been marked as final. Show 5 replies
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.