Pass Parameters to Bex Query through BIApplicationFrame from WDDOMODIFYVIEW

[Former Member]

I am successfully calling a BW Bex Query through a Web Dynpro view using the BIApplicationFrame. However I am having a problem when passing parameters through the bi application frame method handler execute_command option.

I am using BEx Query Designer 3.5

BI Application Frame is named: ZBIQUERY

There is only one selection parameter in the Bex Query: technical name = ZTEST

It is a mandatory,Multiple Single Value, Characteristic value field with no default value.

Is there any way to see error message from the execute_command statement below or to verify the parameter names and values in the Bex Query?

Here is the method code:

method WDDOMODIFYVIEW .

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( 'ZBIQUERY' ).

wd_this->m_method_handler ?= wd_this->m_appl_frame->_method_handler.

endif.

refresh lt_parameters.

add_parameter 'CMD' 'PROCESS_VARIABLES'.

add_parameter 'SUBCMD' 'VAR_SUBMIT'.

add_parameter 'VAR_NAME' 'ZTEST'.

+add_parameter 'VAR_VALUE_EXT' '210'. +

wd_this->m_method_handler->execute_command( lt_parameters ).

endmethod.

Let me know if any other information is required

[Former Member]

Hi,

I am trying to do the same thing but values are not getting populated on screen. Below is my code.

Could you please let em know the solution.

DATA:

lr_bi_appl_frame TYPE REF TO cl_wd_biapplication_frame.

IF first_time = abap_true.

lr_bi_appl_frame ?= view->get_element( 'BF_QUERY' ).

wd_this->m_bi_method_handler ?= lr_bi_appl_frame->_method_handler.

ENDIF.

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.

REFRESH lt_parameters.

add_parameter 'CMD' 'PROCESS_VARIABLES'.

add_parameter 'SUBCMD' 'VAR_SUBMIT'.

add_parameter 'VAR_NAME_1' 'ZACC_TYP'.

add_parameter 'VAR_OPERATOR_1' 'EQ'.

add_parameter 'VAR_SIGN_1' 'I'.

add_parameter 'VAR_VALUE_EXT_1' 'IS'. " Value for my select-option

wd_this->m_bi_method_handler->execute_command( lt_parameters ).

[Former Member]

The following version of the method code successfully submitted the parameter to the BEx report.

method WDDOMODIFYVIEW .

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( 'ZBIQUERY' ).

wd_this->m_method_handler ?= wd_this->m_appl_frame->_method_handler.

endif.

refresh lt_parameters.

add_parameter 'CMD' 'PROCESS_VARIABLES'.

add_parameter 'SUBCMD' 'VAR_SUBMIT'.

add_parameter 'VAR_NAME_1' 'ZTEST'. " Name of my select-option

add_parameter 'VAR_OPERATOR_1' 'EQ'.

add_parameter 'VAR_SIGN_1' 'I'.

add_parameter 'VAR_VALUE_EXT_1' '210'. " Value for my select-option

wd_this->m_method_handler->execute_command( lt_parameters ).

endmethod.