Question:
Hi,
I am trying to access BW data from java server pages using JCO(Java Connector Object) for SAP.
I need to execute the BW query in my Java server page. I need to use
BW OLAP BAPI for that.
Could you please give me the details about that.
I would appreciate if you give me the sample code or documentation on that.
Thanks,
nsudha75
Answer:
Have u tried these..
MDDataProviderBW Multi-dimensional Provider for BW Metadata and Master Data
MDDataSetBW Multidimensional Resulting Qty
TDDataProviderBW Tabular Provider for InfoSet Data
Answer:
hi,
I am using MDDataSetBW bapi. i have used BAPI_MDDATASET_CREATE_OBJECT for executing the MDX query (putting into command_text input parameters). This returns DatasetId for subsequent data retrival using BAPI_MDDATASET_GET_FS_DATA /BAPI_MDDATASET_GET_CELL_DATA.
But for the above functions, we need to pass 3 import parameters.
one is DatasetId, Other two are start and end cell information.
I don't know how to find the start and end cell info.
pl suggest me..
thanks.
nsudha75
Answer:
if your data target is a ODS.. try this..
BAPI_ODSO_READ_DATA
I will try to find the info you want for the other BAPI
Answer:
I suggest you just give up this effort in trying to program in OLAP BAPI. I attempted almost to build a JSP page sometime back firstly even simple ops the performance was so bad. Secondly, practically SAP must have provided some working samples on the OLAP BAPI. I logged a call guess I was told by somebody in Germany to ask my local SAP consultant for OLAP BAPI samples. The local SAP consultant did not even know what OLAP BAPI was and why it must be used he was asking me why I cannot use ITS for reporting. You can see the ignorance of the people supporting the product and a poor quality product that even lacks samples. Being so frustrated I gave up. Same story with the staging BAPIs as well.
I spoke to a reporting vendor from Business Objects the information I got none of the major reporting vendors are using the OLAP BAPIs I guess it is still not prime time.
I hope it is enough info for you not to waste time on this venture unless you are getting paid to waste time.
Cheers
Gill
Answer:
can't agree enough with the previous post..
Answer:
So does it mean if that if you do not agree you are getting some samples on this from SAP can you let us know all of us please where we can get this download from.
Thanks
Answer:
I don't know much thinks about java and so on, but my question is the following : if you have an its/was installed with some bw queries developed within bw available there, isn't it possible to have a look at the source code of those pages and try to understand there how it works ?
Ch
_________________
_
There are only 10 types of people in the world :
those who understand binary and those who don't.
Answer:
Unfortunately,., these pages genrated by BW for WAS and ITS do not use any OLAP BAPIS .. or provide any information about calling this query from a 3rd party system...
Answer:
Hi,
I have done it using VB, which I find much better environment than Java, but it is a matter of preference. If you set StartRow and EndRow as 0 it will return all elements. Before displaying data you need also to find out how many elements are in rows. This can be found in AxisInfo column coordinates.
If you have any other question please send me the email to adam.koszlajda@codec.pl
Wish you luck,
_________________
----------------------
Adam Koszlajda
Codec Systems
www.codec.pl
Answer:
Hi,
Have you looked at using XML for Analysis API? There is a How to guide on SAP Net that uses Java code ... it's called "How to Execute an XML/A Query and read the result.."