This content has been marked as final. Show 4 replies
Use SET VARIABLE LOGLEVEL=2; in Answers->Advanced tab Prefix
If helps mark as correct
Edited by: Srini VEERAVALLI on Mar 28, 2013 5:22 PM
Since its production, you may not have much choice in modifying the RPD. You best bet might be to take xml from production, apply it in answers in dev, and get the query from development.1 person found this helpful
Also, if you still concerned about dev RPD not being the same in dev compared to prod, then deploy copy of production RPD on your local machine or a sandbox if you have OBIEE installed there, and get query from there (after setting the right log level).
Take the logical query from analysis which would be shown from 'Manage Sessions' and run this in 'Issue SQL' under Administration and enable whatever logging you want to starting with 4 is recommended. Now you can click view log to get the physical query.!
Run this in your DB.
Mark if helps.