Skip to Content
Former Member
Aug 05, 2009 at 09:17 AM

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


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.