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.

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.