2

I am developing a report in Power BI using Oracle Smart View from HFM data.

Currently the report is generated using Excel and the Smart View plugin.

The thought is to run an Excel macro manually and populate a csv which can be pulled into a DWH and report off this.

Is it possible to pull the HFM data straight into Power BI? I am not sure how Smart View works. I would prefer to go straight to the HFM Db, but was told that is not possible.

Community
  • 1
  • 1
Ian Cockcroft
  • 131
  • 1
  • 5
  • How does the "excel macro" do it? I'm guessing Excel requires a plugin. – Nick.Mc Nov 06 '17 at 13:59
  • Does this help? http://poweronbi.com/2016/04/from-hyperion-planning-or-hyperion-financial-management-to-power-bi/ . Looks like your data source might just be an Oracle database. – Nick.Mc Nov 06 '17 at 14:02
  • Hi Nick, yes, smartview is an excel plug in from oracle. HFM is an oracle solution as far as I know. – Ian Cockcroft Nov 07 '17 at 09:00
  • 1
    You're best of getting direct access to the Oracle source and connecting to that in Power BI. But then you need to understand the tables and relationships – Nick.Mc Nov 07 '17 at 09:03
  • 1
    yes, i was hoping to do it that way. but corporate politics and policy are getting in the way. thanks for your help – Ian Cockcroft Nov 07 '17 at 09:24
  • You can now connect PowerBI and use native MDX. The May 2019 release should have what you need: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2019-feature-summary/#essbase – Marcelo May 20 '19 at 18:42

0 Answers0