Oracle® Argus Insight BusinessObjects Administrator's Guide Release 7.0.1 E28483-01 |
|
|
PDF · Mobi · ePub |
Argus Insight, formerly called Power Reports, is a highly optimized reporting module that compliments Argus Safety.
The Argus Insight Extract Transform and Load (ETL) engine extracts data from the Argus Safety database and populates a data warehouse in a format that allows efficient querying. The various query, drill-down, and output components of Argus Insight let you analyze your safety, workflow, or product data from all angles and produce reports that provide immediate business impact and maximum efficiency in decision-making.
This chapter includes the following topics:
With Argus Insight, you can generate a report in any of the following ways:
Use a query to retrieve a specific set of cases (a case series) from the data mart and then run a predefined report for those cases. Use the following Argus Insight components to retrieve the case series:
Query By Example (QBE)
Filters
Advanced Conditions
Run one of the following reports on the case series to create and store these in the Reports library:
Built-in standard reports
Custom reports
Create custom reports and analyze the data using the Report Writer.
Use the Report Writer to directly query the data mart.
Note:
You primarily use the Report Writer to directly query the data mart and create custom reports. However, you can apply the active case series filter on the reports to reduce the data set and improve report performance. The case series might become obsolete each time the data mart is refreshed by running an ETL. This is because new cases with similar attributes might get added to the data mart.Argus Insight includes the following components:
Query by Example (QBE) — Lets you create simple queries by entering specific values in fields on a form that looks substantially like the Argus Safety case form.
Filters — Lets you create queries by selecting a set of predefined fields and specifying multiple values in a field.
Advanced Conditions — Lets you create complex queries by selecting any of the various different fields in the data mart, and then applying Boolean and set operations on them.
Case Series — Provides a listing of all the cases that match the specified query criteria.
Standard Reports — Lets you run one or more reports on the case series. The standard reports are predefined reports built in to Argus Insight. Reports are grouped into categories such as Case Processing, Compliance, Configuration, General, Management, and Pharmacovigilance.
Report Writer — Lets you directly query the data mart and create custom reports by selecting any data mart fields as report columns. In the report output, you can apply filters, create nested groupings, and perform operations such as sort, total, count, and drill.
The custom reports you create can be stored in the Report Writer library or added to the Argus Insight application; you can run the stored reports on a case series.
The flowchart in Figure 1-1 depicts the steps that you typically follow to generate a report in Argus Insight. Refer to your company's guidelines for the exact workflow for generating reports and analyzing data in Argus Insight.
Table 1-1 describes the tasks shown in the flowchart.
Table 1-1 Tasks in the Process Flow
Task | Description |
---|---|
Log in to Argus Insight |
Log in to the Argus Insight application. |
Create a Query |
Depending on the complexity of the query, use these Argus Insight components to create a query:
|
Execute the Query to Generate a Case Series |
Execute the query to have the system search the entire data mart and retrieve a list of cases (case series) that match the criteria you specified while creating the query. |
Generate Standard Reports on the Case Series |
Select and run a built-in standard report. You can limit this report to only run on the case series. |
Generate Custom Reports on the Case Series |
Select and run a custom report you created and stored in the Report Writer library. You can limit this report to only run on the case series. |
Query the Data Mart |
Use the Report Writer to directly query the data mart and generate the required report. |