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
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 ?