OFSAA - Oracle Financial Services Analytical Application Installation Overview

OFSAA – Oracle Financial Services Analytical Application Installation Overview

Oracle Financial Services Analytical Application (OFSAA) is business intelligence application that enables financial institutes to measure and meet risk-adjusted performance objectives.

This post covers overview of OFSAA (v 7.2) installation

1. OFSAA Infrastructure consists of Database tier , Application tier, and Web Tier (all three tiers can be on same machine or on different machines)

2. Minimal recommended configuration for OFSAA is 2 CPU, 4GB RAM and 1.5 GB Hard Disk (for dev/test environment)

3. OFSAA is certified on Sun/Oracle Solaris, IBM AIX, RedHat/Oracle Enterprise Linux, Microsoft Windows Server.

4. Certified Application Servers are IBM WebSphere, Apache Tomcat, Oracle/BEA WebLogic Server

5. Certified Database for OFSAA is Oracle Database

6. Hyperion Essbase is optional component. Hyperion Essbase is required only if you wish to use OLAP features of OFSAA.

7. If OFSAA is deployed on Windows Server and you wish to integrate OFSAA with LDAP server (for user authentication) then OPEN LDAP 2.2.29+ is required

8. OFSAA can be installed in

a) Single Tier Installation mode – All tiers i.e. database, application and web are installed on same machine.

b) Multi Tier Installation mode – one or all of Database, Application and Web Tier are deployed/configured on different machines. (install oracle database client on application tier)

9. Multiple Instances of Application or Web Tier can be installed for scalability and resilience . First application instance is called as Default Application Instance. Additional application instances can be added later.

10. Database used for OFSAA application should be created with default NLS_NCHAR_CHARACTERSET as AL16UTF16 and OPEN_CURSORS value should be at least 100 .

Step by step installation of OFSAA coming soon ..

Leave a Comment:

15 comments

Nagesh says November 7, 2011

Waiting for the next post …..
Thanks for not leaving any stone untouched 🙂

» OFSAA - Oracle Financial Services Analytical Application : Installation High Level Steps Online Apps DBA: One Stop Shop for Apps DBA’s says November 8, 2011

[…] OFSAA – Oracle Financial Services Analytical Application : Installation High Level Steps Posted in November 8th, 2011 byAtul Kumar in ofsaa Print This Post This post covers OFSAA (Oracle Financial Services Analytical Application) installation on WebLogic (as application server). For installation overview check my previous post here […]

» OFSAA - Oracle Financial Services Analytical Application : Installation Steps Online Apps DBA: One Stop Shop for Apps DBA’s says November 8, 2011

[…] OFSAA – Oracle Financial Services Analytical Application : Installation Steps Posted in November 8th, 2011 byAtul Kumar in ofsaa Print This Post This post covers OFSAA (Oracle Financial Services Analytical Application) installation on WebLogic (as application server). For installation overview check my previous post here […]

Chitanya says October 1, 2012

Hi ,
what are the mandatory skills needed for the oracle ofsaa and in what areas need to be skilled
also how obiee is associated with ofssa

hari says January 7, 2013

Hi,
Can i have the data model for OFS Profitability Management.

hari says January 7, 2013

I am trying to install OFSAA, getting an ERROR : OFSAAI-1226(Mismatch in Java versions) can anyone help me on this. I have installed jdk1.6_29 on linux 64-bit 5.8 version.

rajfti12 says June 11, 2013

Atul,
Hi,
I am Looking for some help in implementing OFSPA version 6.1 on top of OFSAA 7.3.2 and OFSAPM. I have gone thru the entire installation and configuration document and ran the PA installer successfully to get the PA schema created but data didn’t get loaded in any of the dimension or fact tables.
Can you help?

NSHIT says August 29, 2013

Hi,

I’m looking to have a Sr.Consultant as a Trainer for a Training opportunity in Chennai. Please write to me in confidence: nishitb@crownpro.in OR nishitb@yahoo.com or call me on 9341772744

Thanks!
Nishit