Using BAPIs and JCo to get BW data

63 Views

I am trying to get data out of SAP BW's InfoProvider (especially InfoCubes) and have read the weblog of Prakash Singh but I haven't really found a solution.

I know that I have to use JCo and BAPIs and I also know the BAPIs I have to use (thanks to Prakash) but I don't really know how to use them in a standalone Java-Application.

For example: I have a function

JCO.Function function = this.createFunction("BAPI_MDDATASET_CREATE_OBJECT");

What can I do with this function? Am I able to execute a MDX statement on this function or something similar?

function.getTableParameterList().getField(j).getTable().getName() returns "BAPI6111MDX" which seems to have something to do with MDX 😊

Maybe someone can tell me how I can use the BAPIs Prakash mentioned:

1. BAPI_MDDATASET_CREATE_OBJECT

2. BAPI_MDDATASET_SELECT_DATA

3. BAPI_MDDATASET_GET_STREAMINFO

4. BAPI_MDDATASET_GET_AXIS_INFO

5. BAPI_MDDATASET_GET_AXIS_DATA

6. BAPI_MDDATASET_GET_CELL_DATA

7. BAPI_MDDATASET_DELETE_OBJECT

He uses Dynpage, I like to do it in a standalone Java-Application...

Any help appreciated!

Message was edited by: Markus Bertelt