Wrong sequence of the Mandatory variable in the BEX selection screen

[Former Member]

Hi Experts,

I have below issue in Bex query designer:

In one of the reports , a Mandatory variable 'Reporting month'  is arranged to place it in last most in the variable sequence in Query Designer.

However, when the report is executed, the variable is getting displayed at the top (first place) in selection screen of the report which is strange.

If someone has faced this issue, please suggest the possible solution and the root cause for the same.

Thanks & regards

Lakshmi Mensagi

[Former Member · Accepted solution]

HI Lakshmi,

this is the wrong forum, you probably want to post here:

Regards,
George

[Former Member · Accepted solution]

Hi George,

Thanks for the right pointer.

Regards

Lakshmi

[former_member199945]

check the same query in RSRT either you are getting or not?

& also check oss notes :

Note 588398 (This is 3.x version search relevant oss  note if you are using latest versions 7.0/7.3/7.4)

Note 1643585

[Former Member]

Hi Seshu,

Thanks for your reply;  I have already checked in RSRT  and the variable still appears wrongly in variable Pop-up during query execution there(at the top).

Also, the variable 'Reporting month' is not used in Currency or Unit Translation factors.

Thanks

Lakshmi