10 Generate Oracle Business Intelligence Enterprise Edition 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 Business Intelligence Publisher.
Note:
Analysis can be done on the RPD once the Oracle Argus Mart ETL has brought all the necessary data from Oracle Business Intelligence Publisher Enabled Oracle Argus Safety.
To bring Oracle Business Intelligence 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 > BIP Aggregate Reporting.
-
In the Oracle Business Intelligence Publisher Aggregate Temp tables, set the following:
- Persist data—Yes
- Number of days to persist—Like, 50
The Oracle Business Intelligence 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 Business Intelligence Publisher Aggregate Temp tables will be populated in Oracle Argus Mart tables.
-
Run the Oracle Business Intelligence Publisher Aggregate Reports (PMAR, DSUR, PBRER) to persist data.
The Oracle Business Intelligence Publisher Aggregate Reports data in OBIEE 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 Business Intelligence 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: