Skip to Content
avatar image
Former Member

Open Hub Destination export to database table

Hi Experts,

I would like to create a multi source universe between SAP and non-SAP system. As we know the Jco connection to create a relational connection to access infocube data is not that great. I'm thinking or may be wrong in my approach that I would like to create a open hub destination of type database table on top of the infocube so that I'll have a new OHD table (/BIC/OH*) is created in BW database. Here comes my question that, can I query this new table in BW database via universe by creating a relational connection to the BW database server ?


Please let me know your thoughts and suggestions!


Thanks,

Abhi

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Jun 20, 2014 at 09:28 AM

    Hi


    I would like to create a multi-source universe between SAP and non-SAP system.


    Yes...In IDT...To build a universe on SAP NetWeaver BW, you must create a multisource-enabled data foundation based on a secured relational connection to SAP NetWeaver BW. Then build the business layer on this data foundation.


    I would like to create an open hub destination of type database table on top of the infocube so that I'll have a new OHD table (/BIC/OH*) is created in BW database.


    Creating universe on top of OHD tables is new idea, but while creating universe in IDT, we can able to select only below info providers.

    • Info Object
    • Info Cube
    • DSO
    • Multi Providers
    • Virtual Info providers

    So we are not able to create universe on top of OHD tables. Please find the below screenshot.



    Here comes my question that, can I query this new table in BW database via universe by creating a relational connection to the BW database server ?


    No.....In 4.0 IDT, OHD tables is not one of the info provider to select while creating universe. So it’s not possible.




    PLEASE mark the blog helpful & answered


    1.png (75.9 kB)
    Add comment
    10|10000 characters needed characters exceeded