HOW TO IDENTIFY THE OBIEE REPORTS WHICH ARE NOT USED FROM LONG TIME

How to create catalog report:
1.First open File-> Open Catalog 

2.Then enter the credentials and click on OK and then again OK on the pop up that comes.

 3.Expand Catalog Root and select Shared Folder
 4.Then in the toolbar expand Tools -> Create Report and this appears.

 5.Select ‘Select Type to report on’ as ‘Analysis’ and in the ‘Available Columns’ list select ‘Name’, ‘Path’ and bring them to ‘Columns in the Report’ sectionCheck the Distinct option as well.Then Click Ok.

 6.In the Report Preview add the Path to “Save Report to” to store the Excel and select Excel Format checkbox and then click on OK.

How to create report in Answers for used reports:
 1). Login to production BI .

  2). Click New->Analysis and select Usage Tracking Subject area
  3). In Usage Tracking Subject area, expand Topic folder and select Query Type and Webcat Path columns

  4). Add a valued ‘Report’ to the Query Type column filter and click OK

  5). Add ‘%/users/%’ by selecting Operator as ‘is not LIKE (pattern match)’ for Webcat Path column and click OK

  6). Click on Results Tab

 7). After getting the report click on  icon and select Excel->Excel 2003+ to download the report to excel Below Highlighted Report got executed, as a result it has entry in S_NQ_ACCT table thus showing in the usage tracking report.  There are other reports in the same path but they never got executed.