Skip Headers
Oracle® Argus Analytics User's Guide
Release 7.0.3
E47948-03
Index
Next
Contents
List of Figures
List of Tables
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Finding Information and Patches on My Oracle Support
Finding Documentation on Oracle Technology Network
Related Documents
Conventions
Revision History
Part I Using Oracle Argus Analytics
1
Getting Started with Oracle Argus Analytics
Overview
What Can I Do Using Oracle Argus Analytics?
Architecture
Reporting
Regulatory Compliance
Tracking Data
Managing ETL Versions
Executing the ETLs
Security
2
Using Oracle Argus Analytics
Overview
Accessing Oracle Argus Analytics
Viewing a Dashboard
Using Oracle Business Intelligence
Logging In
Working with Oracle Business Intelligence
Oracle Business Intelligence Interactive Dashboards
Oracle Business Intelligence Analysis
Oracle Business Intelligence Agents
Performing Common Tasks in Oracle Business Intelligence
Signing Out of Oracle Business Intelligence Enterprise Edition
Using Online Help
Navigating in Oracle Business Intelligence
What is Available to You After Accessing Oracle BI?
What is the OBIEE Home Page?
What is the OBIEE Global Header?
Setting Preferences
Steps to Set Preferences
Exporting the Oracle BI Results
Sorting Options Menu and Buttons
Drilling In Results
What Is Drilling?
Where Can I Drill?
Printing an Oracle BI Dashboard or Saved Request
Emailing an Oracle BI Dashboard Page or Request
3
Working with Reports
Pre-defined Reports
Opening and Using Dashboards
Custom Reports
Viewing Reports With Your Apple iPhone
Part II Administration
4
Extract Transform Load Programs
ETL Architecture
Oracle Argus Analytics Hierarchy
Executing the ETL Execution Plans in Informatica
Parameters Used by Informatica ETLs
Executing the ETL Load Plans in ODI
Customizing an ETL Execution Plan (Informatica)/Load Plan (ODI)
Creating an ETL Execution Plan (Informatica Only)
Creating an ETL Load Plan (ODI Only)
Modifying an ETL Execution Plan (Informatica Only)
Modifying an ETL Load Plan (ODI Only)
Scheduling an ETL Execution Plan (Informatica Only)
Scheduling an ETL Load Plan (ODI Only)
Customizable User Exits in Oracle Argus Analytics ETLs
VW_CONFIGURABLE_TARGET_DAYS
VW_CONFIGURABLE_DUESOON_DAYS
5
Maintaining the Repository and Data Mart
Maintaining the Oracle Argus Analytics Repository
Modifying the Repository
Maintaining the Argus Analytics Data Mart
Derivations
Extensions
Substitutions
Modifying Data Mart Tables
6
Performance Considerations
Conformed Dimensions in Oracle Argus Analytics
Aggregate Facts in Oracle Argus Analytics
Creation of Prompts and Filters
Mandatory Prompts
Creating a mandatory field in page-level prompts
Setting up default values
OBIEE Caching and Cache Seeding
7
Implementing Security
About Security in Oracle Argus Analytics
Example
Setting Up User Authentication
Creating User Accounts in DAC/ODI
Creating Users and Groups for Oracle Argus Analytics
Implementing Security using OAM and Configuring SSL for Oracle Argus Analytics
Part III Appendices
A
Dashboards and Reports
Oracle Argus Analytics Dashboards
Case Processing History
Case Processing History Dashboard Pages
Case Processing Management
Case Processing Management Dashboard Pages
Personal User Dashboard
Personal User Dashboard Pages
Expedited Report History
Expedted Report History Dashboard Pages
Expedited Report Management
Expedited Report Management Dashboard Pages
Case Work History
Case Work History Dashboard Pages
Oracle Argus Analytics Reports
Enterprise Incremental ETL Status
Audience
Report Type
Location
Dimensions
Reports Referenced
Reports Referencing This Report
Column Descriptions
Completed Case Versions - Volume Overview
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Completed Case Versions – Volume Trend
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Completed Case Versions – Line Listing
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Completed Cases – Statistical Overview
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Completed Cases – Volume Overview
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Completed Cases – Volume Trend
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Completed Cases – Line Listing
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Completed Case Versions – Lock Compliance Overview
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Completed Case Versions – Lock Compliance Proportion
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Completed Case Versions – Lock Compliance Trend
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Completed Workflow States – Line Listing
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Completed Case Version Routing – Line Listing
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Repeated Workflow States – Volume Overview
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Repeated Workflow States – Volume Proportion
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Pending Cases – Volume Overview
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Pending Cases – Line Listing
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Pending Cases – Lock Compliance Overview
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Pending Cases – Lock Compliance In Days
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Pending Workflow States – Compliance Overview
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
My Completed Workflow States – Volume Trend
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
My Repeated Workflow States – Volume Overview
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
My Completed Case Versions – Line Listing
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
My Completed Workflow States – Line Listing
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
My Pending Cases – Overview
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
My Assigned Cases – Line Listing
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
My Unassigned Cases – Line Listing
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Other Assigned Cases – Line Listing
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
My Completed Case Version Routing – Line Listing
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
My Case Modified Duration Per State – Statistical Overview
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
My Case Unmodified Duration Per State – Statistical Overview
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
My Case Read Duration Per State – Statistical Overview
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
My Case Idle Duration Per State – Statistical Overview
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
My Submitted Expedited Reports – Volume Trend
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
My Submitted Expedited Reports – Submission Compliance Trend
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Completed Expedited Reports – Line Listing
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Completed Expedited Report Routing – Line Listing
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
My Pending Expedited Reports – Overview
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
My Assigned Expedited Reports – Line Listing
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
My Unassigned Expedited Reports – Line Listing
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Other Assigned Expedited Reports – Line Listing
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Submitted Expedited Reports – Volume Overview
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Submitted Expedited Reports – Volume Trend
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Expedited Reports Never Submitted – Volume Trend
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Submitted Expedited Reports – Submission Compliance By User Group
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Submitted Expedited Reports – Submission Compliance By Destination
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Submitted Expedited Reports – Submission Compliance Trend
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Pending Expedited Reports – Volume Overview
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Pending Expedited Reports – Line Listing
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Pending Expedited Reports – Submission Compliance Overview
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Pending Expedited Reports – Submission Compliance In Days
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Failed/Pending ACK Expedited Reports – Volume Overview
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Failed/Pending ACK Expedited Reports – Volume Trend
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Duration Case Modified Per Version and Case – Statistical Overview
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Duration Case Modified Per State – Statistical Overview
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Duration Case Modified Per User/State – Statistical Overview
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Completed Case Version Routing – Line Listing
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Duration Case Unmodified Per Version and Case – Statistical Overview
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Duration Case Unmodified Per State – Statistical Overview
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Duration Case Unmodified Per User/State – Statistical Overview
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Duration Case Read Per Version and Case – Statistical Overview
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Duration Case Read Per State – Statistical Overview
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Duration Case Read Per User/State – Statistical Overview
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Duration Case Idle – Statistical Overview
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
Duration Case Idle Per State – Statistical Overview
Audience
Report Type
Location
Dimensions
Supplementary Prompts
Reports Referenced
Reports Referencing This Report
Column Descriptions
B
Oracle Argus Analytics Presentation Catalog
Dimensions in Oracle Argus Analytics Presentation Catalog
Facts and Sources in Oracle Argus Analytics Presentation Catalog
C
Troubleshooting
Verify whether the DAC client is able to use Informatica commands
Unable to run Informatica Workflow from DAC
Aborting a Workflow
Unable to Sign In to Oracle Argus Analytics
Index