Oracle Analytics and AI

Rookie_86

Hello Guru's,

Obiee Version: 12.2.1.3.0

We have enabled obiee usage tracking.

And, i'm able to query table 's_nq_acct' to view which user accessed our reports and other information like presentation name, start time, end time etc..

So, for an instance if i have 5 reports as of yesterday - i'm able to view usage tracking information for all those 5 reports as of yesterday.

But, if we delete 1 report today is there any indicator (field)/table within obiee usage tracking tables which flags that report is deleted ?

If not, how can purge logs for all the reports which are deleted.

So, that i can only have usage tracking information reg. active reports/reports which are still in our catalog shared folders.

Thanks,

Raymond.

[Deleted User]

1.) It's called an "analysis" if you are doing OBI. "report" means that you're doing BI Publisher.

2.) "Usage Tracking" means "it is tracking the usage of of data and queries" and not "management of BI Presentation server objects". That's what the sawlog is for.

3.) "If not, how can purge logs for all the reports which are deleted." <-- Usage Tracking is not a "log". It's multiple database tables - apart from S_NQ_ACCT you have S_NQ_DB_ACCT as well - which holds rows representing the queries. If you want to delete all entries in those tables for a given analysis, then you need to go to those tables, select all rows where QUERY_SRC_CODE = the fully qualified name of your analysis and then delete them.