10 Generate Oracle Analytics Server Answers and Work on Aggregate Analysis—Sample Dashboard
Oracle Argus Insight provides an out-of-the-box RPD for analyzing the data of aggregated reports generated through Oracle Argus Safety or Oracle Analytics Publisher.
Note:
Analysis can be done on the RPD once the Oracle Argus Mart ETL has brought all the necessary data from Oracle Analytics Publisher Enabled Oracle Argus Safety.
To bring Oracle Analytics Publisher FAR reports data, you must configure the system to persist executed reports data in Oracle Argus Safety:
-
Login to Oracle Argus Safety and navigate to
Argus Console > System Configuration > Common Profile Switches > Reporting > Aggregate Reporting.
-
In the Oracle Analytics Publisher Aggregate Temp tables, set the following:
- Persist data—Yes
- Number of days to persist—Like, 50
The Oracle Analytics Publisher Aggregate Reporting data is purged based on the number of the days mentioned here, but when that data is transferred to Oracle Argus Mart tables via ETL that data will be persisted. However, re-running the Initial ETL of Oracle Argus Mart will purge all the data from Oracle Argus Mart tables, and then only data available in Oracle Argus Safety Oracle Analytics Publisher Aggregate Temp tables will be populated in Oracle Argus Mart tables.
-
Run the Oracle Analytics Publisher Aggregate Reports (PMAR, DSUR, PBRER) to persist data.
The Oracle Analytics Publisher Aggregate Reports data in OAS dashboard can only be seen by the user who has access to that particular report in Oracle Argus Safety
-
Run Argus Mart ETL to transfer the Oracle Analytics Publisher Aggregate Reports into Oracle Argus Mart DB.
-
Login to Oracle Argus Analytics with the user who has access to the above executed report in Oracle Argus Safety, and check the Dashboard and Answers.
For more information, see: