How to connect HYPERION with SAP BW?
Our client wants to use HYPERION to consolidate financial data from BW. They told me that there is an easy way to connect these two systems. That it is completely a natural, no need of ABAP developments. What is that standard connection? Is there a manual on how to do the connection between SAP BW and HYPERION?
We are using SAP R/3 for the back-office, BW for the data warehousing and HYPERION for the consolidation. What Infocube should I need to activate in BW?
Thanks a lot
I see two main options:
1. Use the Open Hub mechanism to export the BI data into a file or database table and have Hyperion grab it from there.
2. Create a quey with all data you need, then release it for OLE DB and have Hyperion connecting to that query directly using OLE DB.
Hope it helps,