Any way to log user "Export to external format" action in OBIEE 12c

deniska

We successfully use Usage Tracking to log user queries.

But we want to log user export actions.

Is there any way to do it?

Saresh-Oracle

Hi Deniska,

Please check this Note:

OBIEE 12c: Ability To Track The Number Of Times Users Export Analysis And Dashboards (Doc ID 2104887.1)

Thanks,

Sareesh

deniska

Thanks But, there is absolutly nothing in this Note.

The Bug(22713104) from the Solution even doesnt exist.

Or you mean that there is no such feature in current OBIEE 12c ver?

Saresh-Oracle

Hi Deniska,

Yes. The feature does not exist as of now. Thats the reason I shared the note with you.

It is an enhancement request.

For the benefit of your community peers, if you find this reply on your thread has either resolved or helped progress your issue, please mark the reply Correct or Helpful.
Refer to Was Your Question Answered in the My Oracle Support Community (MOSC)? Mark Replies Correct or Helpful!

Thanks,

Sareesh

[Deleted User]

https://support.oracle.com/epmos/faces/DocContentDisplay?id=1966917.1

it's JH logging that you need to reconfigure to get this since the component doing the work is JH and not OBIPS.

Surprised to see this noted as "The feature does not exist as of now". It's even an official support document.

Gianni Ceresa

Not only the JavaHost knows, but also OBIPS knows when you do an export. If you enable advanced logging in OBIPS you can also track those actions.

Surprised by an answer from Oracle saying the functionality doesn't exist when it's there for many years (at least 5-6 minimum), even more asking for "points" with that answer .

[Deleted User]

OBIPS knows too (it is aware of the fact but doesn't do the heavy lifting) but I don't remember which log source that is exactly and creating a custom log writer is more work than working with the JH logs

Gianni Ceresa

True, it is more work.

The original request isn't precise enough to know how many more things must be tracked on top of usage tracking for auditing (guessing based on the request).

[Deleted User]

Absolutely. Personally I'd go for a log writer. Not even a question.

deniska

Thanks a lot for sharing this. But I'd like to put this info directly in database...

Is there any way or just to read these info from files and write to db with another service/programm?

Gianni Ceresa

You have to script that part yourself.

Usage Tracking and agents execution logs are the only things that OBIEE writes directly in the DB, the other ways of tracking things are really fully based on log files. The process must be done by yourself (there are many tools which can be used to automate the job, but it's all outside of OBIEE)