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

Physical query in advanced tab

Received Response
83
Views
4
Comments
User_EGB2F
User_EGB2F Rank 2 - Community Beginner
edited Aug 13, 2024 5:12PM in Oracle Analytics Cloud and Server

Hi,

Thanks for the previous answer.

How to get physical query in Advance tab without getting the result of report which was previous done if access is not available to check in view log in obiee 12c.

Request to provide in case any sample screen shots available


Thanks

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    a) Since you're talking about the Advanced tab I assume you mean "analysis" and not "report". A "report" is a different object type managed by a different part of the technology stack: "BI Publisher".

    b) You can never get the physical query (the one that is sent to the data source) from the Advanced tab. You see the XML construction and you see the LOGICAL query which is sent against the Server component. The Server component then writes the physical query against the data source.

    Maybe re-state more precisely what you're after. It sounds like you want to be able to see the detailed session log information from the Administration screen without having the necessary permissions to be able to see the session logging information from the Administration screen - which is simply a contradiction since the security options are there for a reason.

    So please state more precisely what you want if it's not what I assumed above.

  • User_EGB2F
    User_EGB2F Rank 2 - Community Beginner

    Thanks for the reply.


    What is that we get in advance tab then as I have been asked same question and they said that there is physical query can be seen in advance tab.What is that they trying to get it from me.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    I don't know what "they" are trying to get from you as I'm not the one talking to "them".

    What you get in the Advanced tab is precisely what I stated above: The logical SQL:

    And please close questions where you have received answers according to community standards as I have asked you to do in the other thread. It's part of a good community etiquette.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Please close questions you have received answers for. It helps other community members!