When an analysis is created in OBIEE, then it goes to presentation server, generates a logical sql , generates a hash key to check whether the result is in presentation server cache or not. If not, then goes to bi server and checks whether the result is in bi server cache or not. I have got the logical sql of bi server from obis1-query.log(OBIEE 22.214.171.124) but I can't find the logical sql of presentation server. Where can I find the logical sql of presentation server? Actually I want to execute SAGetSharedRequestKey ODBC function where i need presentation server logical sql. One more thing will i execute SAGetSharedRequestKey here Administration->Issue SQL. Though it says the statement goes to Oracle Bi server.
Have you seen this note: Fusion Applications: How to set up and access the nqquery.log to troubleshoot a single OTBI or OBIA query (Doc ID 1469168.1)
I know you are on a different version, but I htink it may still be applicable, in theory. Also, have a look here for file/log locations in 12c: OBIEE 12c: Quick Reference For Architecture, Lifecycle Management and File Locations (Doc ID 2067527.1)