Difference between BW statistcs for a cube and for overall system

[Former Member]

Hai all,

We have a BW system with a process chain for Bw statistics for the whole system. I made a process chain with DB statistics for one my cube. I am sorry. I have little knowledge of the statistics.

My question is would be useful to have statistics for the whole system or perhaps a BW statistics cube

or

Constructing DB statistics every time when cube is loaded?

Which one is advantageous and more recommended? I would appreciate if somebody could refer me to some kind of documentation on this topic.

Thank you very much.

[Former Member · Accepted solution]

I'm a little fuzzy on what statistics you are discussing.

There are Database statistics that are collected on the tables in your BW and there are 'BW Statistics" cubes that contain operational data about what goes on in your BW, how many queries have run, load times, compress times, etc.

It sounds to me like what you are describing is there is one Process Chain that is loading data to the BW Statistics cubes, and you created another chain that is collecting Database statistics.

This is just a guess on my part. What is loaded to the BW Statistics cube is completly different data used for different purposes than database statistics.

BW Statistics are loaded to InfoCubes that are named 0BWTC_C* . What Process Types are being used in these two Process Chains - that would clear this up.

[Former Member · Accepted solution]

Thanks Pradeep and Pizzaman. Pizzaman's answer actually solves my problem that the BW statistics cube is different from the DB statistics on a cube.

Thanks a lot. I will learn about them from the service market place referreed ny Pradeep. I have access to it.

Thanks once again.

[Former Member]

Visu,

If you have access to Service Marketplace or i can send you a PPT which helps with the BW Stats.

How to... Set up BW Statistics 2.x/3.x (pdf)

SAP BW Performance Monitoring with BW Statistics (ppt)

Tell me which ever is serves your need faster.

Pete