Activity trace in BI

[Former Member]

Hi everyone,

is it possible to trace the activities of a user in a BI query? For example, can you log which key figures and characteristics a user has used in a query, which navigation states has he used?

Thank you very much.

Greetings,

Daniel

[Former Member · Accepted solution]

Hi,

you can do this with RSRT.

Go to RSRT--> then give the query name then click on Execute+ Debug.

Then a screen comes up then check the check box aganist Display SQL Query... there ypou can able to see the key figs & Chars used in the quey through the SQL statement displayed there.

Also you can use the tCODE: RSRTRACE for the the require user.

Regards, Siva

[Former Member · Accepted solution]

Hi Siva,

thanks for this information, it was helpful but unfortunately nonsatisfying. I think I have to provide more background information:

Because of data security a branch should not be able to navigate through sensitive data. We know that such security reasons can be handled with authorization but our customer doesn't want to handle this with authorizations. In fact they want to act like "transparency for transparency" - users may see everythink, but the data security branch can watch them doing so (via logging and protocols).

Now the data security branch doesn't want to read sql statements but have a clearly readable logfile with this information.

Any solution is an option, even a custom application can help us there. But how do you retrieve this kind of information like "what has a user done"?

Thanks in advance.

Daniel