Oracle Analytics Cloud for Oracle EPM Part 2 – The Test Drive

The Intro

Hey Friends! This blog is second part in a series covering the use of Oracle Analytics Cloud for Oracle EPM. You can check out the first blog in this series here:

I had touched on Covid-19 impacts being felt across the world in my last post. I recently watched a very interesting limited series documentary on Netflix on Covid-19, called: Coronavirus, Explained.

Watching the series it was good to know that there is some incredible work going into finding a cure / vaccine and lots of scientific innovation feeding that process. Highly recommend checking this series out.

Since my last post I have had a family members catch the virus and really struggle with it, but all have since recovered. In Australia, we have had a second wave / spike in cases in a few places like New South Whales and Victoria.

2020-07-27 10_29_16-Australia Coronavirus_ 14,935 Cases and 161 Deaths - Worldometer

I really hope that everyone is doing everything they can to keep well and safe and I really hope that they find a cure/vaccine soon…

Today I will aim to cover: Testing the OAC for EPM new connectivity and if there are performance or capability/functionality improvements.


Login to Oracle Analytics Cloud and Ensure You are On Oracle Analytics Version 5.6 or later (If you are on Gen 1 you will need to patch if on Gen-2 and still not on this version, contact Oracle Support):

2020-07-27 10_52_12-Oracle Analytics and 8 more pages - Work - Microsoft​ Edge2020-07-27 10_51_34-Oracle Analytics and 8 more pages - Work - Microsoft​ Edge

 Create a New Connection:

2020-07-27 10_50_13-

Enter connection information. Note the following:

  1. You can connect to Planning, Financial Consolidation and Close, and Tax Reporting
  2. You will need to include the Domain at the end of the URL2020-07-27 11_05_07-Oracle Analytics and 9 more pages - Work - Microsoft​ Edge
  3. You have three connection authentication options: 1 option will allow you to define set credentials and the others will rely on the user’s session or the user to enter credentials (select what suits you, keep data security in mind with the selection here)

2020-07-27 10_57_54-Oracle Analytics and 9 more pages - Work - Microsoft​ Edge

Go to Connections You Should See The Created Connection Here. Select this Connection to Create a Data Set. Then Select the Cube you want to create a Data Set for (note: you can create multiple data sets from the one connection). Note: You do not get much options here to prepare / enrich / profile the data. Once done click create project.

2020-07-27 11_11_32-Oracle Analytics and 9 more pages - Work - Microsoft​ Edge

2020-07-27 21_30_54-Edit Post ‹ Oracle Hyperion - The Force Is With You —

2020-07-27 11_16_30-

If you would like to see an output video sample of a dashboard, check out this video post from Benjamin Arnulf: 


To simplify this I am going to break this down into the good and the needs improvement buckets:

  • Good
    • Automatic Generation Definitions Based on Hierarchies in Oracle EPM

2020-07-27 11_19_46-Untitled and 9 more pages - Work - Microsoft​ Edge

    • Performance Seems Reasonable (only high level testing conducted)
    • Use of the OAC Capability for EPM Data (Example: Narrate Functionality)
    • Display data from multiple data sources including EPM on the same dashboard/canvas or within the same project
    • Very easy setup (minutes type thing)
    • No longer requires enterprise edition of OACS as there is no need for RPD (cost effective solution)
    • I believe this is the only analytics tool in the market with a direct connector to Oracle EPM / Other Oracle SAAS products
  • For Improvement
    • Inability to link data sets to Oracle EPM Data sets (this was possible using the legacy RPD approach)
    • Hierarchies Functionality / Drilling Capability – Whilst the generation definitions are a good step towards this and you can drill into the next generation from the current; I would like to see hierarchy definitions and seamless drilling as default capability
    • Encountered a bug related to using new generation attributes with data (displaying incorrect data when not specifying generations below the current in focus. Will log this and hopefully gets resolved quickly)

In general, I do see good progress being made on this front and only see that it will get better with time. Would recommend to keep an eye out for upcoming improvements in the Public Road Map or Whats New for Oracle Analytics Cloud.

I will log the bug mentioned and have added the other points to Customer Connect as ideas (Inability to link and Hierarchy Improvements), please like these to help us improve our Analytics tool further.


  • Ensure in your EPM application aliases exist for all members, OACS doesn’t default to member names when Alias is not present, possibly another improvement area.

A Message

Stay safe and healthy. The force is forever your friend and ally!


Leave a Reply

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

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

Facebook photo

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

Connecting to %s

Blog at

Up ↑

%d bloggers like this: