on 10-04-2011 3:04 PM
Hello,
I'm interested in knowing how to integrate BeX Queries in WD Abap.
Assuming that i know the name of the BW Query, how do I get to call the Query passing the appropriate parameters (typically a select-option), and display the result in a Web Dynpro View?
By looking on the SDN, I found out that the right UIElement is BIApplicationFrame, but I cannot manage to display anything, even following the [example in this thread|http://forums.sdn.sap.com/thread.jspa?messageID=5272710#5272710].
Fact is, I barely know how to open the BeX Designer, so I have to follow a trial-and-error approach.
On the BIApplicationFrame UIElement, i set the properties:
dataProviderStateName: ZEQU_TESTQUERY (I also tried prepending the Infoarea name)
dataProviderStateType: Query
server: host.name:8010 (i assumed it's the same as the web dynpro abap)
Then on the WDDOMODIFYVIEW i wrote the following coding:
DATA: lt_parameters TYPE if_wd_bi_applframe_method_hndl=>tt_name_value,
ls_parameters TYPE if_wd_bi_applframe_method_hndl=>t_name_value.
DEFINE add_parameter.
clear ls_parameters.
ls_parameters-name = &1.
ls_parameters-value = &2.
append ls_parameters to lt_parameters.
END-OF-DEFINITION.
IF first_time = abap_true.
wd_this->m_appl_frame ?= view->get_element( 'BIAF_QUERY' ).
wd_this->m_method_handler ?= wd_this->m_appl_frame->_method_handler.
ENDIF.
REFRESH lt_parameters.
add_parameter 'CMD' 'PROCESS_VARIABLES'. " This is for Execute button
add_parameter 'SUBCMD' 'VAR_SUBMIT'. " This one also for Execute Button
wd_this->m_method_handler->execute_command( lt_parameters ).
When testing the WDA, the Element remains blank although the Web Browser displays some messages in the status bar that hint to the WDA connecting with something.
I only got the port number wrong, problem solved.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Giuseppe ,
I think the host name should be your BW server name and not the webdynpro server name.
BR, Saravanan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.