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.