What is the use of BW statistics?

Answer Posted / shankar.ngbs

BW statistics is for performance anylsis of the system. In
tables RSDDSTAT* all information is stored how long a query
took, how a long a loading process took and so on.
With this information you can analyze which are your long
running queries, the most performance taking actions and so
on. This reporting is available in the web, in BEx by
predefined queries. To be able to execute these queries you
have to activate technical content and load it regularly (on
a daily basis). You can also setup the so-called BI
Administrators cockpit. See help.sap.com or here in SDN for
much more detailed information. The other way is of course
to visit class "BI Performance & administration".



You can install the BW statistics same as Business content.
Go to Business Content tab in RSA1--go to BW Statistics
infoarea--collect all the BW statistics Cubes and Multiprovider.
Once it is done you can load data and can able to report on
them.

Check this links for more,

http://help.sap.com/saphelp_nw04/helpdata/en/eb/3c8c3bc6b84239e10000000a114084/frameset.htm

BW Statistics Queries,

http://help.sap.com/saphelp_nw04/helpdata/en/eb/3c8c3bc6b84239e10000000a114084/frameset.htm

Technical Content,

http://help.sap.com/saphelp_nw04/helpdata/en/eb/3c8c3bc6b84239e10000000a114084/frameset.htm




BW Statistics:we have a option to activate BW statistics in
BW 3.x version in AWB--->tools--->Activate BW Statistics

In BI 7.0 the options to activate BW Statistics is available
in DWB (RSA1) ---> Tools ---> Settings for BI Statistics

(or) you can run the transaction RSDDSTAT to do the same

Hi

The BI admincockpit is process of one of the function known
as Administration of the the DWWB.

We can also access this through the tcode ZPORTAL which is a
single signon which will be having diff iviews as
UWL,Webanalyser,BEx portfolio,My portfolio,Info
broadcaster.we can also see the statistics in this along
with the error handling function with it
refer to the links below
http://help.sap.com/saphelp_nw04s/helpdata/en/07/4938ae7514494b9f3272fa4350dfb4/frameset.htm
http://help.sap.com/saphelp_nw04s/helpdata/en/44/08a75d19e32d2fe10000000a11466f/frameset.htm

Is This Answer Correct ?    13 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you navigate to see the error idocs?

489


What are the steps to create DB connect?

1435


wt is difference between user group and reference user group?

2104


what is structure in reporting?

1050


You want to see the log of transport connection. What t-code would you use? List the steps.

535






What are the components of sap bw system?

485


What are the options to calculate result as ? summation?

1462


Give examples of data sources that support remote cubes?

1615


What is the conversion routine for units and currencies in the update rule?

2100


How to gathering the requirement

1515


How would you do the optimizing the dimensions

491


What is generally included in the data target administrative task?

499


Without taking downtime how to fill logistics extractors (2lis types)

1211


What are the delta options available when load from flat file?

546


What are the settings for Transport?

1612