Bex selection screen does not appear when running workbook via RRMX.

[Former Member]

Hi Experts,

I have following problem: When I run a BEx workbook from a user menu (trans. RRMX), I get no selection screen, but just the workbook with text: "no data found". When I press the refresh button (variable change button), the selection screen appears and after that the data are visible in the workbook. When I run the underlying query the selection screen appears normally. With some other workbooks with selections I do not have such a problem.

Anybody can give me a hint how to get the selection screen diplayed? We are on BI 7.1, Bex SP 10, patch 1.

Thank you,

Michal

[Former Member · Accepted solution]

Hi,

Open the workbook and goto workbook setting from the analyzer design toolbar. Goto variables tab and uncheck the option, 'process variable on refresh'. This will fix this issue.

Rgds,

Hari

[Former Member]

Hi,

Check if the variables are personliazed by you. If yes renove from there.

In workbook settings select the appropriate option from variable tab for variable screen.

I hope it will help.

Thanks,

S

[Former Member]

Dear Michal,

Your Question:

Anybody can give me a hint how to get the selection screen diplayed? We are on BI 7.1, Bex SP 10, patch 1.

Answer:

Open the workbook and goto workbook setting from the analyzer design toolbar.

Check the Refresh workbook on check box.

So every time the selection screen will be appear after exectuion of the workbook.

Thanks & Regards,

Praveen.K

[Former Member]

Thank you all,

the problem is solved with setting "Refresh workbook on open".

Michal

[Former Member]

Thank you all,

the problem is solved with setting "Refresh workbook on open".

Michal

[former_member189638]

Once you have executed the workbook, click on the Olap Functions of Active Cell from the menu toolbar which is on top (seventh icon from left) and select Properties.

Goto Interact Tab and untick Save and Reuse variable Values checkbox.

[Former Member]

Hi Michal

check the workbook options, there you should have the options to choose always process variables when launching workbook.

Boujema

[Former Member]

check if you have personalized the variables. when you do a variable change button to bring up the variable screen