Reply
Frequent Visitor
Posts: 11
Registered: ‎10-10-2016

Anyone know of a Hyperion (or Essbase) template?

Hi,

 

I´m curious if anyone can share experience of getting at Hyperion/Essbase data in the abscense of a connector? The two options I can think of right now are: Excel with the SmartView Add-in -> Power BI (not great, but doable) or ODBC. Any suggestions would be appreciated.

 

Thanks in advance.

 

R.

Frequent Visitor
Posts: 3
Registered: ‎03-06-2017

Re: Anyone know of a Hyperion (or Essbase) template?

Hi, I'm interested in this too. Did you find a solution?

Moderator
Posts: 41
Registered: ‎01-14-2016

Re: Anyone know of a Hyperion (or Essbase) template?

Hi,

 

We don't have plans for a solution template on top of Essbase. The purpose of solution templates is to create an end-to-end solution on a popular application like Dynamics 365 or Salesforce. Essbase is an OLAP server that Oracle uses to host some of their products. So it's not a natural fit.

 

You can vote for Power BI & essbase integration here.

 

Regards,

Richard

Frequent Visitor
Posts: 9
Registered: ‎08-17-2017

Re: Anyone know of a Hyperion (or Essbase) template?

This tutorial covers creating a free-from grid in Smart View by using an Hyperion Essbase data source. Get the resource link here: http://www.oracle.com/technetwork/middleware/smart-view-for-office/tutorials/sv11-084338.html

Frequent Visitor
Posts: 6
Registered: ‎03-22-2018

Re: Anyone know of a Hyperion (or Essbase) template?

I posted the Power Query Excel workbook workaround a couple of years ago. We've now created a full-fledged, supported Power BI to Essbase connector: https://casabasesoftware.com/introducing-the-power-bi-casabase-connector-for-oracle-essbase/

 

Let us know if you're interested.

 

Harry Gates
Casabase Software

 

P.S. I heard from a Microsoft source yesterday that an official Essbase data connector is on their release radar within the next 6 months. Unless they've already started, I think that's an unrealistic timeline. A couple of years is more likely.