Statistics in 2004s and Query total runtime

[Former Member]

Hi Everyone,

We are setting up stats in 2004s. We have all business content activated and loading successfully. All looks good from that end. We see Data Manager and Frontend Cubes (Basic and Virtual).

Question is:

Where exactly can you see total query runtime? The data is broken out by Data Manager (backend/DB time) and Frontend (OLAP time).

Thanks, Mark

[Former Member · Accepted solution]

Frontend & OLAP Statistics:

- RSDDSTAT_OLAP (database view)

DataManager Statistics:

- RSDDSTAT_DM (database view)

Process Chain Statistics:

- RSPCLOGCHAIN, RSPCPROCESSLOG

DTP Statistics:

- RSDDSTATDTP, RSBKREQUEST

InfoPackage Statistics:

- RSDDSTATWHM

BI Object Status:

- RSMDATASTATE_EXT

Process Status:

- RSPCPROCESSLOG, RSPCLOGCHAIN

Hope it Helps

Chetan

@CP..

[Former Member · Accepted solution]

Hi Chetan,

I'm aware of those links, but thanks...others may find them useful.

I resolved it myself by taking a look at delivered BC queries (should have done in the first place).

Thanks, Mark.

[Former Member · Accepted solution]

you may wish to paste those queries and cube here for others to check.

Chetan

@CP..