Obiee usage tracking info

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.

User_XUL9L

Thank you so much for correcting me.

[Deleted User]

Being precise in forum posts help get pertinent responses and faster+easier problem resolution.

Thomas Dodds

https://www.rittmanmead.com/blog/2016/12/enhanced-usage-tracking-for-obiee-now-available-as-open-source/

^ perhaps there's something here that you can use ...

Gianni Ceresa

You already got maybe what you are looking for ...

But aren't you just looking at how to knows what analysis/dashboard has been deleted from your catalog? In that case the link posted by Thomas helps. An alternative ways would be to use the script provided in SampleApp loading the whole content of the catalog in a DB and then look for deltas there and you get the list of objects which have been deleted from the catalog.

More in general I would probably not delete anything from Usage Tracking, if you do you better run out of the office before the audit come to have a look at your OBIEE

You can filter out from the usage tracking analysis the info related to objects deleted, but for auditing I would not really delete those lines for real (so just hide them in your usage tracking analysis).