cancel
Showing results for 
Search instead for 
Did you mean: 

BW Statistics

Former Member
0 Kudos
111

Hi,

I know where BW Statistics are used and I know how to install the BW Statistics in BW. But

1. People say that we need to load the data into statistics cubes using infopackages. But what data we need to load and from where do we need to load?

2. Do we need to keep on loading the data for ever?

3. How does the data loaded is useful in improving the performance of the BW System(loading/Queries etc..)?

Thnx.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello,

Yes the technical content cubes need to be loaded like other cubes till you need reports based on these.

These cubes will have respective data for what each one of them is meant for. for eg: OLAP cube should have the concerned data. Such data is for those cubes which are marked for availability for statistics.

in rsa1->environment->bw statistics for infoprovider

you have already selected them.

Thanks and hope this helps...

Former Member
0 Kudos

Hello,

sorry for an error in the earlier post. it's rsa1->tools and not rsa1->environment.

regards,

Answers (2)

Answers (2)

edwin_harpino
Active Contributor
0 Kudos

hi,

1. yes, we need to run infopackage to load data from statistic tables RSDDSTAT* to basic cube 0bwct_c02, 0bwct_c03, 0bwct_c04, 0bwct_c05, 0bwct_c09, 0bwct_c11.

each time we do query navigation and data loading, it's recorded in these RSDDSTAT** tables.

2. yes, we need to schedule the upload (just delta).

3. the data loaded contains info of

- OLAP -> query access performance, each time spent on accessing database, front end time etc. and

- WHM - warehouse management -> extraction time of each infoproviders.

hope this helps.

Former Member
Former Member
0 Kudos

Hi,

You would need to do the following:

1. First "turn-on" the statistics for the all the cubes that you want. RSA1 -> Tools.

2. Now after each dataload for your cube you would refresh the statistics for that cube. You can include that as a process in your process chain also.

3. Now load the BW statistics regularly. In most of the projects it is loaded daily during ealry hours (when no official activity is on).

4. Now you can execute the BW queries and find all the details you need like - how many users accessed a particular query, how many aggregates, OLAP time for a query, etc...

Also refer this link:

http://help.sap.com/saphelp_nw04/helpdata/en/f2/e91c3b85e6e939e10000000a11402f/frameset.htm

Hope this helps.

Bye

Dinesh

Former Member
0 Kudos

Hi,

Thanx for the Info provided. But I would like to know what data is loaded and from where?