Migrating Hyperion Data into an SQL Data Warehouse
I'm new to the forum and would like to hear others experience with what I am trying to do.
I would like to migrate Hyperion Essbase data into our SQL 2008 data warehouse. Currently, our BI system only reports information down to a gross margin level. I would like to include all our operating expenses which live in Hyperion Essbase. Also,we have a number of Powerpivot reports, and if there was a way for Powerpivot to see and import Hyperion data, we would not need to actually upload the information into our SQL database.
I've done a bit of research and it seems like