BW Statistics Queries & Dashboards

[Former Member]

Hello All,

I have a required to build a BW Statistics Dashboard (cockpit).

I already activated the BW Statistics and daily deltas are loading to the cubes. Now i am in the process of creating BW Dashbords.

My question is what Reports/Queries/Charts are frequently used to in BW Stats Dashboards?? any performance indicators ??

any sample dashboards documents or specs for the same are welcome. praveen.sapbi@gmail.com

Thanks in advance

POPS

[Former Member · Accepted solution]

hi

If you are on BI 7.0 - go for BI Admin cockpit which is standard feature...

There are lots of BI queries avialble in busniess contewnt which you can use

Gaurav

• Assign pts if it helps*

[Former Member · Accepted solution]

Hi Wond & Gaurav

Thanks for your useful information.

If possible can you pls send me a screenshot of a sample Dashboard for BW Stats. praveen.sapbi@gmail.com

PS: I m on BW 3.5

Thanks

Praveen

[Former Member · Accepted solution]

Hi,

Is it possible for you to forward me the DASHBOARD report.

shabanaamlani@gmail.com

Thanks

[Former Member]

In 7.0, there is a new BW Statistical Query and Dashboard which can be published on portal, but if you are not in 7.0, then you can use the existing BW Statistical query which was attached to the statistical cubes. Then you just need to create dashboard.

1. Most/least frequently executed query.

2. Average time the most executed query takes.

3. Load performance, how long does the normal daily (weekly, monthly) loads take.

4. Master data load performance.

there are thousands of performance measures in the query and you can create dashboard on those metrics.

thanks.

Wond