workbook - statistics

[Former Member]

Hi

how can i get a statistic abou the use of workbooks?

thanks in advance for help.

Stefania Iandolo

[Former Member]

This question as been posted before and I don't think I have ever seen an answer. It's my understanding that the BW statistics that are captured are all query/navigation level statistics. I don't believe the BW Statistics captures what workbook invoked the query.

[Former Member]

Yeah, that's what my understanding on it was.

Ta

Gill

[former_member228339]

Hi...

ST03N Expert mode

Run Transaction SM66

Identify the process id

Run transaction ST04 and find the process in Oracle session

Get the execution Plan

Read mode (Table RSRREPDIR)

Tables RSDDSTAT / RSDDSTATAGGR

Cache Monitor(RSRCACHE)

Function Module

RSDDCVER_RFC_BW_STATISTICS

BW Stats Cubes

RSRT

RSRTRACE

with regards,

hari

[Former Member]

Hello,

For statistics of the queries and workbooks i made a query on standard cube

OBWTC_CO2.

venku

[Former Member]

Venku,

How did you get details of workbooks from here?

Thanks

Gill