In previous versions of AAO, the connection for client machines was direct to SAP HANA through ODBC connections. In AAO 2.0+ that changes to the HTTP INA technique from what I gather.So in the past, when there were various issues or performance probl...
Doing some research on various performance topics I came across the fact that Analytic views are now shown as star joins in revisions >= SPS9.They seem almost identical with the following differences- Analytic views only allow attribute views in the ...
Someone recently asked how a HANA DATABASE view (not calculation/analytic/attribute view) can have a mandatory input parameter/variable/where clause attached to it. From this, I remembered that there is a system view (“SYS”.”EFFECTIVE_PRIVILEGES”) th...
First off, I have to recognize that this conversation was started (as always) in some blog comments with tim.korba2, who provided an approach that I tweaked and used in a current project. That's the best part about this community - a majority of my ...
A recent request came up at a customer who was migrating to a larger independent HANA sidecar scenario and wanted to move large groups of users from one HANA instance to another. Since there is no mass user creation functionality that I am aware of, ...
No Sylvain, I pretty much hit a brick wall with a couple of OSS incidents and even an onsite AO expert. There apparently is no "tool for the masses" to be able to do this type of analysis. All that can be done is send the traces to SAP for analysis. ...
Fiddler will not give the inner workings of the database as you mentioned - that was one of the first responses I received from development.This is cross posted in HANA space hereAdditionally I have opened 2 separate incidents to engage HANA support....
Hey Filipe, thanks for the note. In parallel I am also working on the trace functions from the HANA side.Unfortunately, there is also a big gap on that side. Due to the change in communication protocol, the requests are now in a different format and ...
I am just circling back on this as I got a response from SAP in the past month. Apparently the only known methods for capture the details behind the AAO request is either a python trace or a performance trace, neither of which can be readily analyzed...
Jan - don't follow this blog anymore - please use the link provided by Alexey above. This is an SAP provided solution and I have implemented the same a few times successfully. The link takes you to the "how to" documents that should walk you through ...