Open Hub Destination export to database table

[Former Member]

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 

[former_member4998]

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