8). SAP BW ....STATISTICS

Q.What is the use of Bw statistics?
Ans.The sets of cubes delivered by SAP is used to measure performance for query, loading data, etc; it also shows the usage of aggregates and the cost associated with them. Gives data on aggregates, OLAP and Warehouse management.
Q.How d o you enable monitoring using bw statistics?
Ans. Individual data prov ders can be enabled to minimize overhead; AWB →Tools→ BW statistics

Q.How do you install BW statistics?
Ans.Use business content to install
a.using the business content section of AWB, select info area “BW Statistics”; right click and select insert onjects for collections; select before and after data flow for grouping and install
b.Similarly install the technical contents SAP_BW_TCONTrole
c. Install the info package groups for Master data/text and transaction data.

Q.Give some examples of queries delivered with BW statistics?
Ans.
a.Mean time per query
b.Runtime query
c.Using infocubes
dUtilizing OLAP