Skip to Content
avatar image
Former Member

How to connect HYPERION with SAP BW?

Hi Guys,

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

Regards

Vic

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 24, 2007 at 10:11 AM

    Victor,

    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,

    Gili

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 24, 2007 at 03:08 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 24, 2007 at 04:10 PM

    Gilad has answered the mechanism of integration.

    Reg your other questin of what cubes to actvate depends on what kind of data do you wish to send to Hyperion. If it is Financial consolidation data search for cubes startig with 0SEM* in the content.

    Ravi Thothadri

    Add comment
    10|10000 characters needed characters exceeded