BAPI to read cube data

[Former Member]

Hi friends !

Could you please give me the std BAPI names to read data from an infocube (that returns a list of all records, or as a DB aggregation in some way, contained in a cube) ?

Bye,

Roberto

[Former Member · Accepted solution]

Hi Roberto,

which one do you want? BAPI object MDDataSetBW gives you the data if you are able to use MDX to extract the data. TDDataProviderBW gives you tabular data which might help in your case. Both objects contain a multitude of methods to get your values but are quite difficult to handle.

If you use BPS you could use API_SEMBPS_GETDATA to get cube data.

My personal favorite is RSDRI_INFOPROV_READ. It also has a huge interface but with a bit of trial and error it's more or less straight to use.

Note that this function module isn't officially released but it's the internally used interface.

If you have any questions about the interface feel free to ask.

Best regards

Dirk

[Former Member · Accepted solution]

Hi Dirk,

thanks for all these information...

I need to link BW data (stored in several cubes) to Hyperion Financial Management...the adapter provided by Hyperion in H.Application Link for BW allows extraction via BAPI and/or RFC call...

I wonder which type of tool it's better to use for this purpose and, above all, which type of method allows to test extracted data quality/layout.

Let me know what are your thoughts...

Thanks in advance, Dirk !

Bye,

Roberto

[Former Member · Accepted solution]

You could use either RSDRI_INFOPROV_READ_RFC or use the standard methods via BAPI object MDDataSetBW. Other ideas are to use Open Hub and write your own RFC to read the db table. The BAPI is the official way but as I said it's a bit difficult to use. It has the advantage to not only extract cube data but also extract query results so if your data is in multiple cubes you might want to use XML/A on queries on multiproviders. The XML/A statement is normally the way to handle this situation.

Best regards

Dirk

[Former Member · Accepted solution]

Dirk,

I think I'll use RSDRI_INFOPROV_READ_RFC FM...but (as I was afraid of) all parameters descriptions are in german and it's a real difficult undertaking to understand something...

however, I wonder if there is some way to test the output of this FM, considering that:

- at this moment I'm not able to create the RFC connection...

- ...so, I think it's not possible to download the output on local on my machine

- I can use RSDRI_INFOPROV_READ for this purpose...

- ...but it isn't possible to run this FM on test mode (by SE37)

Could you please give me some suggestion (insert RSDRI_INFOPROV_READ in an ABAP pgm to see the result of the extraction ?) and some explanation on parameters that I have to use (especially about tables section) ?

Dirk, do what you can and thanks in advance !

Grateful,

Roberto

[Former Member · Accepted solution]

Roberto,

What you can do is wrap the FM call into a report and call it. To understand further the input and output parameters go to listcube and put a /h into the toolbar to go into debugging mode. Once in debugging mode create a breakpoint on the FM RSDRI_INFOPROV_READ. You can then look at the contents of what is in the input parameters and mimic them in your report.

Hope this helps.

Cheers,

Scott

[Former Member · Accepted solution]

Dirk (or better Mike Eacrett from SAP),

just another question...

but RSDRI_INFOPROV_READ_RFC is a component of Open Hub Service ?

Do I need an additional license to use this RFC FM ?

Or to use std BAPIs as MDDataSetBW or MDDataSetBW ?

[Former Member · Accepted solution]

Extracting data from SAP BW by any means requires additional licensing, ok, but if my customer has already paid for Hyperion Adapter for SAP BW (I think that Hyperion, in his turn, have paid to SAP a sort of fee in order to develop this kind of technology), is it possible that additional (and not so slight!) costs are required ?

I think that if this is true, my client will reject any vendor offering and he will choose (with the same economical effort!) to pay for all his life a good programmer that will extract all needed data through a completely custom solution directly from R/3 !

I know that this is a commercial issue (and my customer will further investigate), but I wonder if someone, in the meanwhile, can enlightened me about this !

Bye,

Roberto

[Former Member · Accepted solution]

Hi Roberto,

I would really wonder if Hyperion pays licenses to SAP for this extractor. But I'm currently in the same situation. I would talk to the sales representative and explain the situation.

BTW do you work for a bank currently? If yes you can mail me, I would like to discuss these things not here in the forum.

Best regards

Dirk

[Former Member · Accepted solution]

Hi Dirk,

I'm not engaged in a bank project...however I will inform you about any news (from some Hyperion/SAP rep.) on this topic...

Bye,

Roberto

[former_member189012]

Hello,

we try to get access to data of our infocubes from a web dynpro application. Therefore we tried to use the function module 'RSDRI_INFOPROV_READ_RFC' to get access.

Unfortuantely when we establish the context mapping between the function module attributes of the controller and the view, we get following error after the deployment to the WEB AS:

'com.sap.dictionary.runtime.DdException: Type com.sap.rfc.types.Rs_Bool does not exist' If we connect a standard BAPI it works, but no BAPI can get the information we need from the infocubes.

Is there a possibility to get this function module work with java web dynpro jco connection?

Best Regards

Frank

[Former Member]

Roberto,

Here's an excerpt from SAP Open Hub KNC. Mike and Dirk may have additional insights.

The Open Hub Service is one tool among other functions to accomplish this task. Additionally, DataBrowser functionality (ListCube transaction) or CRM interfaces can also be used to export data, and many other options are possible.

Extracting data from SAP BW by any means requires additional licensing!

For additional pricing information please contact your SAP representative.

Manish

[Former Member]

With BW 3.5 there is also the additional possibility of using APD to aggregate/transform the data in the cube/query and write it to a transactional ODS. For further information on APD functionality refer:

http://help.sap.com/saphelp_nw04/helpdata/en/49/7e960481916448b20134d471d36a6b/content.htm

[Former Member]

Have you looked at RSDRI_INFOPROV_READ_RFC? This is RFC-enabled versus RSDRI_INFOPROV_READ and it does work in SE37 for single test.

[former_member181887]

Hi Roberto,

Another option if you are on SAP BW 3.5 is to use the Web Service to call a query and deliver the results to your application/program.

Just another option,

Mike.

[Former Member]

Scott,

this is a good suggestion (and you confirm my thoughts) !!!

Thanks a lot !

Mike, Manish,

sorry if I don't specified that my BW release is a 3.1/3.3(Add-On)...however your help is welcome anyway.

Bye,

Roberto