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

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