Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Logical sql of a analysis of presentation server in OBIEE 12.2.1.4

Received Response
1
Views
1
Comments
Mostafizur Rahman
Mostafizur Rahman Rank 3 - Community Apprentice
edited Aug 13, 2024 5:35PM in Oracle Analytics Cloud and Server

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.

Answers

  • Charles M
    Charles M Rank 6 - Analytics Lead

    Hi,

    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)

    Regards,

    Charles