How to Find Unused query from technical content from a specified Time

[Former Member]

Hi Experts,

I am looking for some inputs for finding unused queries from a specified period.

Actual requirement : Like if i give the date range as 01.2008 - 12.2008, it should give me the list of Queries that were not run even once during this period.

solution tried out:

There is a field BI Count( keyFigure) in the Multi Cube 0TCT_MC01, but couln't put a restriction on this Key figure where count is zero.(logic i had in my mind).

Tried the options of using Formula Variable by Replacement Path, but didn't find a way.

Could you please help me in finding the solution.

Thanks in advance.

Ganesh Thota.

[Former Member]

this table/view may helps.

goto SE11---> give V_CMP_JOIN table name.

this table/view will provides Inner join for query components without texts. timestamps will provide when the reports are excuted and other details.

[Former Member]

Hi,

This is my take on it-

Define the '0query' ( or info-object bearing the master data for queries) as an info-provider. Create a Multiprovider using the info-object and the transactional data cube. Create a report on this MP and define a condition on the KF equal to 0. The statistics cube will have data only for queries that have been run, it will not have the data for the queries not run. So a Vlookup kind of functionality is needed between the data in the cube and the master data.

Regards,

Saurabh Diwakar

[Former Member]

Hi,

Apart from 0TCT_MC01, one other way around is you could find the query usage from BI Work Load Statistics

DB02.

Thanks,

ChandraDeepak