It gets even better, when variables are used in the BEx query, the selections made at runtime are also propagated to the WebI LOVs.
Here's an example:
- I created a BEx query with on year / period and added a static filter on 2011 to the query.
- Then I created a WebI report on top of the BEx query and created a prompt on year / period
- When this report is executed, the prompt windows is presented and the LOV only shows values for 2011
- Then I replace the static filter in the BEx query with a variable
- and go to the Query Panel in the WebI report. There is now a small button where I can set the BEx variables
- I select 2011 and remove the Set as prompt selection, which means that this variable / prompt will not be refreshed when the report is refreshed
- When the report is executed, the prompt window is presented and the year prompt is fixed on 2011 and greyed out
- and when the LOV for year / period is presented, again only values for 2011 are displayed
If I hadn't switched of the Set as prompt en the Set Variable windows the BEx variable would still be active when the report is executed. Even the year selection made during runtime is propagated to the year / period LOV.