cancel
Showing results for 
Search instead for 
Did you mean: 

pop up message in bex query designer..!!

Former Member
0 Kudos

hi guys

i want to display pop up error message while user execute query and they selected wrong value in selection screen.

i want to throw them pop message saying that they selected worng value. is that can be done in Bex designer?

Accepted Solutions (1)

Accepted Solutions (1)

chemicala_srimallikarjuna
Active Contributor
0 Kudos

Hi,

Here is example ,If user choose wrong Cost Center ,it will throw up error message .You need to write a code in I_Step = 2 for the query.

The Sample code :

DATA: LI_VAR like rrrangeexit,

wa_t_var_range like LI_VAR,

count type i value 0.

IF i_s_rkb1d-infocube EQ 'Ur Cube Name'.

IF I_STEP = 2.

LOOP AT i_t_var_range into wa_t_var_range where vnam = 'Cost Centre Varaible'

<write condition to check write cost center>

If correct.

exit.

else.

CALL FUNCTION 'RRMS_MESSAGE_HANDLING'

EXPORTING

I_CLASS = 'RSBBS'

I_TYPE = 'E'

I_NUMBER = '000'

I_MSGV1 = 'Enter Correct Cost Center.

raise again.

endif.

endif.

endloop.

Regards

CSM Reddy

Former Member
0 Kudos

thanks both. i am confused with I_STEP here..is it going to be I_STEP = 3 or 2?

chemicala_srimallikarjuna
Active Contributor
0 Kudos

Hi,

Here is the information abt I_step:( BEX Variables)

Step 1 (I_STEP = 1) is called before the processing of the variable pop-up and gets called for every variable of the processing type u201Ccustomer exitu201D. You can use this step to fill your variable with a default or proposal value.

Step 2 (I_STEP = 2) is called after processing of the variable pop-up. This step is called only for those variables that are not marked as u201Cready for inputu201D and are set to u201Cmandatory variable entryu201D.

Step 3 (I_STEP = 3) is called after all variable processing and gets called only once and not per variable. Here you can validate the user entries.

Step 0 (I_STEP = 0) is called for variables which are used in authorizations objects.

Regards

CSM Reddy

sureshsharma_sharma
Participant
0 Kudos

CSM and Arun,

I have tried to use the code you provided and it works.

BUT when I use it without 'Raise exception' statement it displays the message and continues to process the query and even displays the result.

When I use the statement 'Raise exception' I am thrown out of of the portal with a short dump stating the exception and message.

Same happens when you execute it using RSRT without a portal,

We are on BI 7.0 latest patch.

I will wait for what you guys say before I ask OSS.

You guys have been a great help. Thanks!

Suresh

Answers (1)

Answers (1)

former_member184494
Active Contributor
0 Kudos

You cannot display a popup but you can pass messages back to the user informing the same and sending them back to the login screen. This is done by a customer exit written under i_step=3 and you can raise a message within the customer exit and return the user to the variable input screen.