Logon | Executed each time a successful logon occurs. insert into <owner>.bqaudit (username, day_executed, event_type) values (user, sysdate, 'Logon') Note: The logon audit event fires for each action when used with the Data Access Service. Because of connection pooling, it is not possible, at the Data Model level, to determine when an actual logon event is required. |
Logoff | Executed each time a successful logoff occurs. insert into <owner>.bqaudit (username, day_executed, event_type) values (user, sysdate, 'Logoff') Note: The logoff audit events fires for each action when used with the Data Access Service. A logoff event does not happen until the connection reaches the configured idle time. |
Pre Process | Executed after Process is selected, but before the query is processed. It is useful to track the date and time of both Pre Process and Post Process in order to determine how long a query takes to process. insert into <owner>.bqaudit (username, day_executed, event_type) values (user, sysdate, 'Pre Process') |
Post Process | Executed after the final row in the result set is retrieved at the user's workstation. It is useful to track the date and time of both Pre Process and Post Process in order to determine how long a query takes to process. insert into <owner>.bqaudit (username, day_executed, event_type, num_rows, sql_stmt) values (user, sysdate, 'Post Process', :ROWSRETRIEVED, SUBSTR(:QUERYSQL, 1, 200)) |
Limit:Show Values | Executed after selecting the Show Values button when setting a Limit. insert into <owner>.bqaudit (username, day_executed, event_type, datamodel, sql_stmt) values (user, sysdate, 'Show Values', :REPOSITORYNAME, :QUERYSQL) |
Detail View | This statement is executed when a user toggles a topic to Detail View and a sampling of data from the database is loaded. Remember that values are only loaded when you first toggle to Detail View, or when Cause Reload is selected in the Topic Properties dialog box. |
New Data Model | This statement is executed when the Data Model is downloaded from the document repository into a Interactive Reporting document. insert into <owner>.bqaudit (username, day)_executed, event_type, datamodel) values (user, sysdate, 'New Data Model', :REPOSITORYNAME) |
Data Model Refresh | This statement is executed after a Data Model is refreshed through ADR. insert into <owner>.bqaudit (username, day_executed, event_type, datamodel) values (user, sysdate, 'Data Model Refresh', :REPOSITORYNAME) |