What is Oracle Retail Analytics?

Retail Analytics is very similar to the more popular Oracle Business Intelligence Applications (OBIA).
OBIA offers an appliance that is tightly integrated with a specific source system, giving a pre-built BI solution. It is designed to interface with Oracle ERP and financial sources (like Oracle EBS, Siebel CRM, JD Edwards and Peoplesoft), though there are adaptors that are available for non-Oracle systems like SAP.

Retail Analytics is specifically designed to integrate with the Oracle Retail suite, utilising oracle’s technologies to deliver a complete BI solution for retail businesses.

It consists of a pre-built data warehouse (Oracle) schema, that is populated by an Extract – Load – Transform tool (Oracle Data Integrator (ODI)) with a reporting tool (Oracle Business Intelligence Enterprise Edition (OBIEE)) that has been pre-built with 100’s of specific retail metrics, reports and dashboards.

RA - Basic architecture


In keeping with the OBIA, Retail Analytics provides you with the basis of a common enterprise information model (CEIM). The CEIM gives a robust and consistent view of the data – which should allow for complex reporting and allows a solid foundation for the ‘inevitable’ customisations that occur in BI projects.

The current version of Retail Analytics architecture is very similar to the newly released OBIA and the existing Oracle BI Fusion edition, so the ability to integrate this with other BI apps is certainly a possibility.

Whilst it is similar to OBIA, Retail Analytics does have some differences.
The most notable (at the time of writing this) is that there is no program as part of the application that handles the population of the data warehouse.
In earlier versions of OBIA, there is a tool called the DAC (Database Administration Console);this tool runs the tasks and execution plans that populates the data warehouse. The latest version (OBIA uses 2 custom web-based tools to ‘administer’ the batch runs.
Retail Analytics is packaged with batch scripts but there is no program to schedule or run them.

Oracle Retail Analytics is the parent of more 5 granular offerings; Oracle Retail Merchandising Analytics, Oracle Retail Customer Analytics, Oracle Retail Planning Analytics, Oracle Retail Supply Chain Analytics and Oracle Retail Stores Analytics. N.B. Only Merchandising and Customer version are currently on general release.

We are deploying the Oracle Retail Merchandising Analytics product.

As with most Oracle products there are various point versions of the software, we are looking at Oracle Retail Analytics 13.2.5. This ships with ODI, OBIEE and is certified to be used with Oracle 11gR2 database.

I think I have covered most of the high level points (and tried not to descent into too much waffle).

Next posts will probably be installationary (sic) in nature but first I need to read the documentation (again)……….

Tagged with: , , , ,
Posted in Architecture
2 comments on “What is Oracle Retail Analytics?
  1. mohit says:


    What version of RA you have installed or planning to install.
    I do not see much documentation around the configuration of Retail Analytics. Did you encounter too many challages or was it smooth configuration.


    • nitibob says:

      Hi Mohit
      The version we are looking at implementing is 13.2.6

      There isn’t much documentation on RA, I hope this blog addresses this.



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s