Open Hub queries

[#1]

Hallo Experts,

I would like to get some help on questions related to Open Hub for BW30.

May I know:

1. From the OpenHub Model (Execution-Time), the Data Packages are IN & OUT. Are these what are referred to as Structures /BIC/CY<> and /BIC/CZ<> ?

2. What is the practical way commonly used to manage the flatfiles for Open Hub given that names cannot be changed.

3. What situation will cause the fields of an infoprovider to not appear in the Selection tab of infospoke? I cannot see the fields nor set them there.

4. Can DBConnect be used to transfer OpenHub table to external DW/Datamarts?

regards,

Mirella

[Former Member]

In reference to your question #2, my client had a requirement to be able to specify the filename & path.

I was able to accomplish this by modifying the standard ABAP classes being called by the InfoSpoke processing to allow for user entry on these fields.

Of course, this enhancement will not be supported by SAP but if you need this functionality, I have created a power point listing out the individual steps and all the custom code involved

[Former Member]

Hi,

what is the difference between your solution and the one in the howto paper?

kind reg.

michael

[Former Member]

Hi, Michael -

I apologize for taking so long to respond - I hadn't bothered to check if there was a response. I believe your question is asking the difference between the solution to use literal filename vs. logical. If this is the question, the difference is that the literal filename will open up the file name/path parameter on the infospoke screen and allow a user to directly specify a custom entry rather than the alternative to set it up using tables. I originally started by implementing the logical filename/path;however, my client did not want to have to maintain the table which required user access. I hope that answers your questions - feel free to contact me if you have further questions/comments Thanks!

[Former Member]

Hello,

(1) I do not know...

(2) Please have a look into the how to paper: https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sapportals.km.docs/documents/a1-8-4/how to extract data with open hub to a logical filename.zip

(3) which infoprovider do you mean?

(4) no

hope this helps

kind reg,

michael

ps. please do not forget to give points.

[Former Member]

Dear Michael,

Appreciate your help.

3) Infoprovider I had problem with not seeing any infoobject in the selection tab is a basic cube.

Have a nice day.

• If anyone knows what the Data packages are on the DDIC level, kindly let me know. Thanks in advance.

kr,

Mirella

[Former Member]

Hi Mirella,

I beleive that tables RSBSTEPIDLOG & RSBDATAPID (Open hub: Data Package Log for a Request) is what you need.

Best regards,

Eugene