SAP Business Warehouse is the new buzzword in SAP circles. I have written quite a lot now on the basic concepts of BW. You can find some basic information on SAP BW here and here. Many readers here have requested me to cover on interview questions on SAP BW business warehouse. Today, I am covering a popular question on SAP Business Warehouse about BW Statistics.

Q). What is BW Statistics and what is it used for?

Answer: BW statistics are a set of infocubes delivered by SAP as part of SAP BIW which are useful in measuring the performance of how quickly a query is calculated, or how quickly data in loaded into BW and so on. BW statistics as the name suggest are useful in showing data about the costs associated with BW queries, aggregative data, OLAP, SAP business warehouse management etc.

BW statistics can be enabled in SAP business warehouse using the menu path AWB >> Tool >> BW Statistics. This can result in significant reduction in overheads once individual data providers are enabled. To take an example, BW Statistics queries can be runtime queries, queries related to infocubes, mean time per query, use of infocubes etc. Finally, as part of the interview question, the candidate can also discuss how BW statistics can be installed. The Business content section of the AWB contains the settings for BW statistics. One can select the objects to be inserted for collection. After selecting the objects, the BW user must install the technical content i.e. the BW user role "SAP_BW_TCONT". After BW authorizations are complete, the last step is to install the infopackage groups for master data and transaction data.

Related Posts

SAP BW Tutorial Loading Data in Infocube
SAP R/3 Installation Guide Book
SAP Internet Transaction Server
Invoice Verification SAP R/3 MIRO MRBR