Oracle Financial Services Analytical Applications Infrastructure is the complete end-to-end Business Intelligence solution that is easily accessible via your desktop. A single interface lets you tap your company’s vast store of operational data to track and respond to business trends. It also facilitates analysis of the processed data. Using OFSAAI you can query and analyze data that is complete, correct, and consistently stored at a single place. It has the prowess to filter data that you are viewing and using for analysis.
It allows you to personalize information access to the users based on their role within the organization. It also provides a complete view of your enterprise along with the following benefits:
Track enterprise performance across information data store.
Use one interface to access all enterprise databases.
Create consistent business dimensions and measures across business applications.
Automate the creation of coordinated data marts.
Use your own business language to get fast and accurate answers from all your databases.
Deploy an open XML and web- based solution against all major relational or multi-dimensional databases on Microsoft Windows and UNIX servers.
The OFSAA Infrastructure consists of below components / Modules that are used to deploy an analytical solution.
Data Model Management
Data Management Tools
Unified Analytical Metadata
Rules Run Framework
Metadata Browser
Operations
System Configuration & Identity Management
Object Administration
Forms Framework
A common landing page is available for all users until a preferred application landing page has been set. The landing page is divided into multiple tabs and each tab has specific links to OFSAA Infrastructure and/ or Application modules. Depending on the OFSAA Application being accessed and the access roles mapped to the logged in User, the Tabs and links are displayed.
Applications Tab:
This tab lists the various OFSAA Applications that are installed in the OFSAA setup. The Select Application drop-down list displays the OFSAA Applications, based on the logged in user and mapped OFSAA Application User Group(s). Links to related modules within Applications and Infrastructure are grouped appropriately to maintain a unified experience.
Sandbox Tab:
This tab lists the various OFSAA Sandboxes created in the OFSAA setup and the Select Sandbox drop-down list displays the OFSAA Sandboxes based on the logged in User and mapped OFSAA Application User Group(s). Links to modules that operate only on Sandbox features are grouped in this tab.
Object Administration Tab:
This tab lists the various OFSAA Information Domains created in the OFSAA setup. The Select Information Domain drop-down list displays the OFSAA Information Domains based on the logged in User and mapped OFSAA Application User Group(s). Links to modules that enable object traceability and migration of objects are grouped in this tab.
System Configuration & Identity Management Tab:
This tab lists the OFSAA Infrastructure System Configuration and Identity Management modules. These modules work across Applications/ Information Domains and hence there are no Application and Information Domain drop-down lists in this tab. Links to modules that allow the maintenance of setup installation and identity management tasks are grouped together in this tab.
When you are in a particular tab, the available menus are displayed in the Left Hand Side (LHS) as well as in the Work Area or Right Frame. You can drill-down through menus from both places and navigate to the required screen.
Note: The navigation path differs from Application to Application. That is, based on the selected Application, the navigation varies.
Data Model Management is intended for uploading the warehouse data from the operational systems to database schema using ERwin xml file.
Data Management Framework is a comprehensive data integration platform that facilitates all the data integration requirements from high-volume and high-performance batch loads to event-driven integration processes and SOA-enabled data services. This module is used for managing Data movement. This includes sub modules like Data Sources, Data Mapping, Data File Mapping, Post Load Changes and Data Quality Framework.
Data Entry Forms and Queries module facilitates you to design web based user-friendly Data Entry windows with a choice of layouts for easy data view and data manipulation. This module has sub modules like Forms Designer, Data Entry, and Excel Upload.
Unified Analytical Metadata is intended for the Information and Business Analysts who are instrumental in supporting and affecting analytical decisions. This module is used to define and maintain analytical metadata definitions. This module has sub modules like Alias, Derived Entity, Dataset, Dimension Management, Business Measure, Business Processor, Build Hierarchy, Business Dimension, Catalog, Essbase Cube, Oracle Cube, Filters, Expression, Map Maintenance, and Cube Migration.
Rule Run Framework facilitates you to define a set of rules, reporting objects, and processes that are required to transform data in a warehouse. This module has sub modules like Rule, Process, Run, and Manage Run Execution.
Metadata Browser module provides extensive browsing capabilities of metadata, helps in tracking the impact of changes to metadata, and trace through to the source of originating data. The metadata in Metadata Browser window is organized into different categories like Data Foundation Metadata, Business Metadata, and Process Metadata.
Operations module facilitates you in administration and processing of business data to create the highest level of efficiency within the system and to derive results based on a specified rule. It includes sections like Batch Maintenance, Batch Execution, Batch Scheduler, Batch Monitor, Batch Processing Report, Batch Cancellation, and View Log.
System Configuration & Identity Management module facilitates System Administrators to provide security and operational frame work required for Infrastructure. It includes sections like Server Details, Database Details, OLAP Details, Information Domain, Configuration, Segment/Metadata Mapping, and Segment Map Security.
Object Administration facilitates System Administrators to define the security framework with the capacity to restrict access to the data and metadata in the warehouse, based on a flexible, fine-grained access control mechanism. These activities are mainly done at the initial stage and then on need basis. It includes sections like Object Security, Object Migration, Translation Tools, and Utilities (consisting of Metadata Difference, Metadata Authorization, Save Metadata, Write-Protected Batch, Component Registration, Transfer Document Ownership, Patch Information).