OSA

OBIEE 11g Project to Replace OSA

Last post of the decade!  I just thought I would update you all that we're working on a project to implement OBIEE 11g to replace an existing Oracle Sales Analyzer implementation that has been working for over a decade.  We'll add more detail later.

Some initial observations:

1. We were waiting for OBIEE 11g because we needed the OLAP presentation capabilities of OBIEE 11g to implement the project.  OSA has had these for two decades, including: hierarchical drilldown (hierarchical columns in OBIEE 11g), custom groups (custom aggregates in OSA), and more OLAP capabilities.

2. OBIEE offers many more presentation opportunities.  For example, in OSA, there are just reports and graphs.  Now, we can add prompts, graphs, as well as the traditional pivot tables.

3. Adding attribute columns to a report is much more intuitive.  In OSA, we had to create custom measures to simply add a column that had a higher level parent as a column in a report.  Since OBIEE represents everything as columns, we can simply add those columns to a report.

4. OBIEE is more of an application development platform than OSA.  We can create links between reports, add special prompts, LOTS of things.

Look for more observations in the coming days/weeks/months.

OFA and OSA De-Support Notice

Oracle will be de-supporting Oracle Financial Analyzer (OFA)  and Oracle Sales Analyzer (OSA) and at the end of this year.   Below is the support you can expect to see from Oracle:

Error Correction Support (ECS): 31-DEC-2009
ECS includes the following:

Telephone and Electronic support, consisting of:
Answers to customers' questions Workarounds, where possible
Assistance with migration plans to a supported platform and/or product

Bug fixes and Backporting of fixes
Certification with supported products, newer operating system versions or new compilers
Escalation support, response time adherence and skill availability

Extended Support (ES):  31-DEC-2010
ES includes the following:

Telephone and Electronic support, consisting of:




Answers to customers' questions
Assistance with migration plans to a supported platform and/or product
Workarounds, where possible


We have several customers that have successfully used OFA and OSA for years and are still getting value out of it.  We want to make sure you are well covered when this software is officially de-supported from Oracle. We have presentations on comparisons of Essbase and Oracle OLAP, two common technologies for replacing OFA and OSA and other Express-based applications.  Hyperion Planning could be another migration path.  Check out Oracles website for additional information on the de-support for OFA or OSA.