1 Reply Latest reply on Nov 6, 2018 4:15 PM by Charles M

    Logical sql of a analysis of presentation server in OBIEE 12.2.1.4

    Mostafizur Rahman

      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 12.2.1.4) 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.