BW 3.5 (NW04)
In case, you are using BEx Analyzer or the browser for executing the query, you can see the query runtime statistics in the BW system only if the BW statistics for the InfoCube are activated on which the query is running.
Therefore, please activate the BW statistics on all the Basic InfoCubes on which the query is running. You can do this from TCode: RSDDSTAT or from RSA1-> Tools -> BW Statistics for InfoProviders.
Now, execute the query from BEx or the portal and after executing login to the BW system (ABAP system) and go to Transaction SE16.
In transaction SE16, enter the table name as (Table Name = RSDDSTAT)and in the QueryID field enter the technical name of the "query" and then press execute.
Now, you will see all the runtime statistics for the query, like the total runtime, DB time, OLAP time and the frontend time.
The other way to see the query details is to run the same query in the "Query Monitor" (TCode : RSRT) with the option "execute and debug" and in the options select "display runtime statistics". After you execute the query on the output screen, just go back and you will see the query statistics for the current exection of the query.
BI 7.0 (NW 7.0)
Same things need to be followed here also.
The difference is that you can activate the BI statistics on a query also in case of BI 7.0.
Therefore, from "RSA1 -> Tools -> Settings for BI statistics" or from TCode: RSDDSTAT, activate the statistics on the query, you are referring to.
Now, after running the query in BEx Web Analyzer or BEx Excel addin, you can again go to SE16 and here now, you need to enter the table name as "RSDDSTAT_OLAP" to see the new BI query runtime statistics.
For getting the details of the DM time, you can also use the RSDDSTAT_DM table.
The other option of RSRT is also valid in this case.
Hi, Nice posts from your side Anjali.
ReplyDeleteI am an aspiring BI consultant and wants to be in touch with certified and worthy professionals like you. Can you please provide me with some real time issues on this blog or my email id, which you faced and solutions so that I can learn from them......
Thanks & regards,
Mohammed Naveed.
mohdnaveed03@gmail.com
Hi Naveed,
DeleteThanks for taking time out to go through my blog. As for real-time scenarios I would say there is nothing like real-time scenarios. Its all up to you what you make out of them. If you are a newbie in BI, I would suggest you attend a training class. Simultaneously, go thru sdn (I have posted in this blog how to access each of the spaces) and understand the issues faced by others, the solutions which worked for them and then try to simulate the same in your system. Then you may sometimes get stuck becoz of some errors, find solutions....So thatz how you learn. For eg: if you decide to work in SD area, take any DS say 2LIS_11_VAHDR, find the issues others faced on that and work on them. The most important of all is streamlining what you want to do. Otherwise you will get lost, as you know its an ocean out there.
As for the issues I faced on the course, I have already listed them out in the blog. It all starts with "Error:......" and I have also mentioned the solutions that worked for me. You can also find some scenario (so called real time) which I worked on in Generic and LO extraction. The links to which are already in my blog. I have published them in SDN. They are explained screen-by-screen. You can try it out on your own. I have even listed out all my certification preparation and interview questions I faced.
So basically, once you start working on all these you will be doing all (real-time) scenarios. For support issues, you can find lots in the Internet. Try it on, but keep your basics strong thatz the key to success ;-)
If you want to know more about any specific area plz write it on, I will take it up ASAP.
Keep the Spirits,
Anjali