Forum Discussion

rakeshsaini's avatar
rakeshsaini
Icon for Helper II rankHelper II
9 years ago

ORACLE HFM to PowerBI Integration

Hello PowerBI Team ,   We Need to Create a PowerBI Reports using 'ORACLE HFM' Data Source. So for this We Need to get Data from 'ORACLE HFM' Data Source and Used this Data in to PowerBI Desktop.  ...
General Comment
Need Help
Show and Tell
Tips and Tricks
SandeepKomminen's avatar
SandeepKomminen
Regular Visitor
8 years ago

Interesting HFM. It would be great if you can provide more details about it. Thanks you

  • BPOptimizer's avatar
    BPOptimizer
    New Member
    8 years ago

    I think the proposed way is not the best option, because you would have to rebuilt the whole HFM data model from the the DB. The HFM data model ist quite complex as HFM is ROLAP with predefined metadata including n-dimensions with n-hierarchies and attributes.

    The best solution is, as long as PowerBI does not support HFM API or ADM drivers, run extended analytics extracts from HFM into a SQL db.

    It will offer all the hierarchy model (star schema) and DW extracts. Oracle HFM Extended Analytics

     

    You just have to think about security then, because financial data...companies...group adjustments...users... etc...

    • menatalla's avatar
      menatalla
      Icon for Microsoft Employee rankMicrosoft Employee
      6 years ago

      Are there currently alternatives or the proposed solutions , still hold ?