Using BSP to fech BW query data

[Former Member]

Hi all,

I wanted to create a BSP application which retrieves the data from BW and then it displays the data .

For that i have created a BSP(for selection screen using HTML and java script).

There is a BW query which retrieves the desired data from BW.

Now can anyone please tell me how to get data from that BW QUERY data from BSP??

I think there is a function module RRW3_GET_QUERY_VIEW_DATA for that.

But i dont know how to use that.

Please help me out.

Regards,

Sumanth

[athavanraja · Accepted solution]

/people/durairaj.athavanraja/blog/2005/12/05/execute-bw-query-using-abap-part-iii

[Former Member · Accepted solution]

Hi Durairaj ,

First of all let me tell u, that u r awesome....Your blogs were too good.

Initially i tried to use your function module, but there isnt a class called cl_rsr_query_variables.

So i tried using RRW3_GET_QUERY_VIEW_DATA.

But i am getting a dump saying "Exception condition "NO_APPLICABLE_DATA" raised. ".

Here is the code im using.

zparam-NAME = 'VAR_NAME_1'.

zparam-VALUE = '0RPA_BDD'.

append zparam to zparam2.

zparam-NAME = 'VAR_VALUE_EXT_1'.

zparam-VALUE = '20080220'.

append zparam to zparam2.

CALL FUNCTION 'RRW3_GET_QUERY_VIEW_DATA'

EXPORTING

i_infoprovider = 'ZMC_POS_A'

i_query = 'REP_ZMC_POS_A_001_TEST'

i_t_parameter = zparam2

IMPORTING

e_axis_data = wa_axis_data

e_cell_data = wa_CELL_DATA.

Can you also tell me how to pass to i_t_parameter , if i want to use a date range.

Thanks in advance.

Regards,

Sumanth

[athavanraja · Accepted solution]

how to pass parameter :

its the same as you would pass parameter in the url (for calling the query over web) which is explained here

http://help.sap.com/saphelp_nw04/helpdata/en/07/ff413a3ace7022e10000000a11402f/frameset.htm

Raja

[Former Member · Accepted solution]

Hi Raja,

Thanks for your reply.

My problem is solved now. Thanx for that.

But Now I am facing another problem.

After retrieving data from RRW3_GET_QUERY_VIEW_DATA , i am passing the AXIS and CELL internal tables to

CALL TRANSFORMATION, so as to convert it to XML.and i am successful doing that.

Now i have data in XML format.

and i want to display that using XSL.

Now Where to write that XSL coding??that is in layout section of the page in BSP or anywhere else???

Thanks for solving my previous problem.I will definitely reward points for that.

Regards,

Sumanth

[athavanraja · Accepted solution]

check out my weblog where i have given code on how to massage axisdata, cell data , etc to get them into two dimensional format.

[Former Member · Accepted solution]

Thanx...will try and let you know...

Edited by: robin hood on Feb 28, 2008 4:11 PM

[Former Member · Accepted solution]

Hi Raja,

Sorry to bother you,

Can you please tell me , if i have data in XML and xsl coding,

How to display that in web.That is how to use that in BSP?

I hope my question is clear.

I have seen your blog.But i think u didnt specify that.I am sorry if i missed there.

Regards,

Sumanth

[athavanraja · Accepted solution]

check out demo application in your ssystem

it00/bspext_xslt_response.htm

[Former Member · Accepted solution]

Hi Raja

Thanks for a great post!

I tried following it.

Can you please explain the the structure ZBW_QUERY_OUTPUT_METADATA?

I am fairly new to BW and assigned to the task of executing Query through ABAP..

A reply would be most appreciated.

Thanks

Radhika

[athavanraja]

check this blog

/people/durairaj.athavanraja/blog/2005/12/05/execute-bw-query-using-abap-part-iii