Hi..
<b>In addition to enhanced query performance, this approach allows for a better front-end architecture and easier access to the reports repository. Open the Web AD and create the report SENDER_WEB. Select the BEx sender report as DATAPROVIDER and create the RECEIVER_WEB report based on the corresponding BEx report.
In the BW environment, execute RSBBS and access the Maintain Sender/ Receiver Assignment screen. The BExsender report is listed in the Query tab along with the BEx receiver report, which was previously defined. It is located in the Receiver section of the screen.
Press Shift+F4 for the Report Assignment prompt and select the BW Web Application option under the Report
Type tab. In the Report section, locate the RECEIVER_WEB report and press F8 to transfer your selection.
Now you are able to drill through from your SENDER_WEB report to the two queries in Figure 5. The difference
between the two is that RECEIVER_ WEB report is custom designed to meet the customer’s needs.
You can add more Web AD elements and enhance the RECEIVER_WEB report.
For example, you could add a filter element like I did to the report template todisplay how the report is filtered. Various other options are also available via the Web AD including changing the visual appearance of the report. The BExreceiver report is available in the Goto option of the SENDER_WEB report and can be displayed through a Web browser. This is the default option and based on a standard SAP template that cannot be changed or edited.</b>
If the BW statistics are turned on, the systems collects data. These data is inserted in different tables:
Tables, which are filled by ‚OLAP‘:
RSDDSTAT
RSDDSTATAGGR
RSDDSTATAGGRDEF
Tables, which are filled by ‚WHM‘:
RSDDSTATWHM
RSDDSTATCOND
RSDDSTATDELE
Use of OLAP for Each InfoCube (Time)
Components of runtime per query
Use of OLAP for Each InfoCube (Records)
Records selected / transferred
Query Runtime
User, query, # of navigations, components of runtime
Use of OLAP by Date
Use of OLAP according to time of day
Mean Time Per Query
Mean time per navigation
Data Load: Utilizing WHM per InfoSource
BW Performance Tuning Knowledge Center - SAP Developer Network (SDN)
[original link is broken]
performance docs on query
https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3f66ba90-0201-0010-ac8d-b61...
https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/cccad390-0201-0010-5093-fd9...
https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/ce7fb368-0601-0010-64ba-fad...
https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/c8c4d794-0501-0010-a693-918...
https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/064fed90-0201-0010-13ae-b16...
weblog
/people/prakash.darji/blog/2006/01/27/query-creation-checklist
/people/prakash.darji/blog/2006/01/26/query-optimization
Message was edited by:
krish
Message was edited by:
krish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.