Saturday, April 1, 2017

Oracle Fusion Financial GL is an Essbase Cube!

Let me start by saying.
I am only slightly surprised at the time I am writing up this blog post.

Why? Good question. I found that there is little to no talk, chatter, blog, twitter, media buzz or hype about this topic.

But, back in the spring of 2007, Oracle bought a company called Hyperion or more formally Hyperion Solutions Corporation and known on the NASDAQ as HYSL for approx. $3.3B. Press Release - Oracle. Many would, can and will continue to speculate as to the answers of why. But this blog post is going to focus on one good reason as to why Oracle bought Hyperion. And this EPM guy is happy to share.. let's take a closer look.

Setting the stage and getting into the background. We are going to look into the Oracle Cloud ERP. Stop! Yes, I said ERP and NOT EPM! But please, keep reading, because I think that you as an EPM-er, just like me, will get a kick out of what I am going to share.

Basic facts. A search on of this phrase "Oracle Fusion Financials Release 11" returns 1 result. Huh? Stop the presses, 1 result. Not sure why.

Anyway, if you follow the link there is an Implementation Guide, wonder what is in there? Nothing I found very interesting in the "Common Implementation Guide".
Let's keep looking. And I am going to look at the "Financials Implementation Guide".

Well, look at that, in the Overview section, there is something called "Financial Business Intelligence Analytics", and has a sub-section "General Ledger Business Intelligence Analytics" .. wonder if there is more on this???

Going back to the Contents, this is interesting, "35 Define Financial Reporting", what is this?

This is it. I am hooked in. Hook. Line. And Sinker!
Like an FDMEE fish swimming upstream >o
*wink* <insert EPM joke here> *wink*

Well, and now you had me at hello .. Smart View! My dear, dear, good ole' friend. I didn’t know you also spent time with the General Ledger, ERP??!
Who is this that you have not told me about??
But even better, many of your other EPM reporting friends are here with you! Financial Reporting, Financial Reporting Workspace, Financial Reporting Studio.. tell me more!


Financial Reporting Center is comprised of numerous components:
  • Financial Reporting: Financial users and analysts access live reports and books or published snapshot reports and books from previously scheduled batches in a variety of formats. Other functionality includes:

    • Refreshing report data using runtime points of view or parameters
    • Drill through capability from parents to other parents
    • Drill down to detail balances, journal lines, and subledger transactions.
  • Smart View: Financial analysts view, import, manipulate, distribute, and share data from your Oracle Fusion General Ledger balances in Microsoft Excel.
  • Account Monitor and Account Inspector: Financial analysts monitor and track key account balances in real time at every level of your dimensions and hierarchies. These tools provide multidimensional account analysis and drill down capability.
  • Financial Reporting Workspace: Reporting administrators create, open, save, and delete folders and store report objects, reports, and snapshot reports.
  • Financial Reporting Studio: Report authors use an object-oriented graphical report layout with report objects, such as text boxes, grids, images, and charts, to design reports.

Okay, so now we are done. Not yet. Although this led us to a little bit of a dead end. I am working currently on Oracle Financials Cloud Release 11. And what I just found makes me want to find out and learn more!

Wonder what is new for Oracle Applications Release 11? Video Spotlight on Financials

Am I seeing this right in the video!? Multidimensional analysis..

And at 2 minutes and 37 seconds of this video, did i hear what I think I just heard?!?! ".. these are based on multidimensional cubes.. they can be updated on demand..".

And then a minute later at 3 minutes and 30 seconds, ".. with Release 11 we are also delivering powerful modern reporting and analytics.. analytical applications for mobile devices using BI mobile app designer.."

And then we get to the "Analyze | One Location for Reporting and Analytics" at approx. 3 minutes and 55 seconds. ".. reports based on .. BI Publisher, Oracle Transactional Business Intelligence, Hyperion Financial Reporting, General Ledger Sunburst, and BI mobile App Designer.."

Also, an interesting fun fact to note. The name of the Application that is used in that video is the same as .. well .. this one! :)
Which one is that you ask since you didn't click on the link to watch the video.
That was the video for Oracle PBCS. Yes, I said. PBCS! The sample application for PBCS is called Vision.

PBCS: Vision

Fusion Financials: VISION

Well, that is fun, nice and interesting all at the same time.

But I am not easily getting to the rabbit that I am chasing.. until I stumble onto, this, the "Financial Reporting Center: How It Works". I am mentally turned around for a second because for a brief moment I forgot if I was researching an EPM something or another, and remember that I was looking into and researching Fusion Financials Cloud ERP. And notice, it uses the word "cube"!

This to me is the EPM Hyperion reporting toolset that I am familiar with, plain as day. The configuring Financial Reporting section is all of the classics that I have seen for years before, Hyperion Financial Reporting (HFR) Studio, BI Publisher, Smart View, words like Workspace.

Now, being a Smart View kind of guy. I had to see or try to see if I could see this for myself. We have an Oracle Fusion Cloud ERP, so why not try.

I already have Smart View installed, latest version Now what do I need? The Configure Smart Client View for Users says that I should be able to take the Workspace URL that ends in /workspace/index.jsp and replace that ending with what I know to be the common Smart View suffix of /workspace/SmartViewProviders

And, there you have it. Open the Smart View Panel. Click on the Shared Connections. After the login. The Panel choices look like this..

I am going to pick my friend Oracle Essbase. And this is what I see..

And sorry for the blur but I have to make sure to protect the innocent.

This is only the first post of many on this topic as I have only scratched the surface.

Hint: If you now know that the GL Balances are in an Essbase cube. And you have many of the same reporting tools to use. What other shared bits are there between this Cloud ERP and the EPM world.. stay tuned!


  1. Awesome article. It is so detailed and well formatted, i enjoyed reading it as well as get
    some new information too.For more details about oracle fusion SCM training please check our website.

    Oracle Fusion SCM Online Training

  2. You really did a great job. I found your blog very interesting and very informative. I think your blog is great information source & I like your way of writing and explaining the topics. Keep it up.
    Oracle Fusion Financial Training

  3. I read your article its really interesting. The way you started was catchy and more informative. The rappo you used while delivering the content holds the best part of the article. While in my search along with your content I found an institute which delivers the best core part in oracle fusion financials training