cancel
Showing results for 
Search instead for 
Did you mean: 

How to know Query view usage statistics?

manohar_k20
Explorer
0 Kudos

Dear SCN Members,

Please help me out in this.

What are the tables where query view usage statistics will be stored in sap bw?????

Regards,

Mano

Accepted Solutions (1)

Accepted Solutions (1)

former_member976
Active Contributor
0 Kudos

Hi,

please check the below statistics cube- 0TCT_C01

if don't have install the form the BI content then load it to data check the cube data.

it will says which query how  many users are using.

Thanks,

Phani.

manohar_k20
Explorer
0 Kudos

Hi Pani,

I need to get the usage statistics of a query view but not query.

Thanks for your response.

Regards,

Manohar

Answers (5)

Answers (5)

former_member199945
Active Contributor

Hi,

Go to ST13  tcode and provide tool name BW_QUERY_USAGE  their it will provide  all details .

Table : RSDDSTAT_OLAP

Thanks

MartinMaruskin
Active Contributor

Have a look into BW's statistics tables:

RSDDSTAT_OLAP     - Front-end & OLAP Statistics -> this is table for BEx query usage data

RSDDSTAT_DM Data - Manager Statistics

chanda
Contributor

Hi,

You can check table - RSDDSTAT_OLAP, if you so not have 0TCT_C01 installed.

HANDLETP = OLAP     .

Hope it hels.

Regards,

Sudhir

manohar_k20
Explorer
0 Kudos

Hello SCN,

Can you plz help me out on this.

Regards,

Manohar

manohar_k20
Explorer
0 Kudos

Dear All,

What ever you have replied is related to queries but not query views, what I observed in your responses.

Kindly help me out in this .

Regards,

Manohar


MartinMaruskin
Active Contributor
0 Kudos

Mohanar, in the table RSDDSTAT_OLAP there are a all BEx objects tracked. See field Event ID in the same table which describes object involved. Have a look into this help page for details:

https://help.sap.com/saphelp_nw70ehp1/helpdata/en/45/f0488a1aa03115e10000000a1553f7/content.htm

Cheers

m./

manohar_k20
Explorer
0 Kudos

Hi Martin,

Thanks for your reply.

This events describes objects involved, but the problem here is, if a query is executed in portal with a saved view, then is there any table which keeps track of this particular query is executed because of this particular view.

Regards,

Manohar