Open Hub Destination Business Scenario!

[Former Member]

Hi 

I am new to SAP BW. when ever i find forums about open hub destination i come to know only about what is OHD and its use. Thats fine.

But I am little bit confused where we really come across this and let me know the exact business scenario in real time?

THanx in AdVnce!

[Former Member]

Hi,

I will share a scenario in which we have used OHD for one of our clients.

Client had all the data in BI, whereas for APO planning purpose they were using different front end tool, which is based on Oracle.

So to send data to that tool, we placed all our data in OHD (which will be daily update) and those people will be extracting the data from the OHD tables.

This is because, for some reason they cannot extract data from star schema table, but they can extract it only from nomalized table. So we have place it in OHD in which the data will be stored in the format of flat table.

In this way, OHD was required for business scenario.

Hope this helps.

Thanks.

[Former Member]

Hi Friend,

Current system does not have company code not even coming from ECC, how to rectify this if you know the company code value? And how to updated into all relevant providers?

For the above scenerio, we can generate the excel files with Open hub option. In this we need to be hardcoded value for Company code in the transformation between DSO to Open Hub.

If once generate the files then re-load files into now relevant providers.

Hope it gives idea about Open hub usage.

Thanks,

Ram

1.  

[Former Member]

Hi Venkat,

Open Hub Destionation can be used to save data files for Archiving as well.

Abhiroop

[Former Member]

This message was moderated.

[Former Member]

when you want to use data outside BI some third party tool for further processing then you use open hub to send data outside bw.

Generally we dum data in flat file format (XL CSV) @ application server and then third party tool will pick data from there for further processing.

few nice docs are availeble link below.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/501f0425-350f-2d10-bfba-a2280f288...

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/5092a542-350f-2d10-50bd-fc8cb3902...

I hope this will help you.

Thx

AM

[Former Member]

Hi Venkateswarlu,

As said by Chandra, Open hub destination is used to export data from SAP BW to non-SAP systems like flat file or database tables.

for Configuring SAP BW Open Hub Destination, you can refer to:

http://wiki.sdn.sap.com/wiki/display/EIM/Configuring+SAP+BW+Open+Hub+Destination

http://scn.sap.com/community/data-warehousing/blog/2011/12/17/bw730exporting-hierarchy-using-open-hu...

Regards,

Harish.

[Former Member]

Hi,

When ever we want to move data from sap bi to flatfile, table we use open hub destinations. Here BI is the source system and flatfile or table are the destinations.

Where as Extraction is used to pull data into BI from different source system.

Check these doucments....

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/501f0425-350f-2d10-bfba-a2280f288...

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/5092a542-350f-2d10-50bd-fc8cb3902...

Regards,

Aravind.

[former_member186082]

Hi Venkateswarlu,

Sometimes requirement comes in such a way that we have to load the to a file or a table. In that case we go for OHDs.

Data from InfoCubes, DataStore Objects, InfoObjects (attributes or texts), and InfoSets can be loaded to Database tables (in the database for the BI system) and flat files

Regards

Chandu

[Former Member]

Hi Chandra,

Thanx for response. But what is the use of that requirement?

I mean, after loading data into either database tables or flat files from BI system then what is next step with them?

[former_member186082]

OHD come to picture when we want to export data to Non-SAP systems using APIs and a third-party tool