Workaround:
Make sure persistence is turned off for VARIABLE NAME=&&ID_PRODUCTFEX see the attached image
From:
wf_retail_product.mas:
VARIABLE NAME=&&ID_PRODUCT, PROMPT='Select Product Name', USAGE=I9,
SELECT=MULTI, SELECTOP=OR,
ACCEPT=SYNONYM (ID_PRODUCT AS PRODUCT_NAME IN WFRETAIL82/DIMENSIONS/WF_RETAIL_PRODUCT), $
VARIABLE NAME=&&ID_PRODUCTFEX, PROMPT='Select Product Name via FEX', USAGE=I9,
To:
wf_retail_product.mas:
VARIABLE NAME=&&ID_PRODUCT, PROMPT='Select Product Name', USAGE=I9,
SELECT=MULTI, SELECTOP=OR,
ACCEPT=SYNONYM (ID_PRODUCT AS PRODUCT_NAME IN WFRETAIL82/DIMENSIONS/WF_RETAIL_PRODUCT), PERSISTENT=OFF, $
VARIABLE NAME=&&ID_PRODUCTFEX, PROMPT='Select Product Name via FEX', USAGE=I9,
Repro Steps:
- Log in to WebFOCUS.
- Go to Administration console > Parameter Prompting > Default Auto Prompt Template >set to 'Responsive' rather than 'Designer> Save and clear cache.
- Go to Server Console > go to wf_retail folder> Dimension > Right click and open wf_retail_product.mas > Make sure persistence is turned off for VARIABLE NAME=&&ID_PRODUCTFEX ( see the attached image Persistent uncheck for wf_retail_product.png) > Apply > Save and close.
- Go to wf_retail folder> Right click and open wf_retail_lite.mas
- Click View icon from top right > and select Show “Table/Column”.
- Expand Product Dimension> Drag and drop Product, Filter,Via Fex > to the Filter’s and Variables in Business View. (See image Wf_retial_lite) > Save and close. Attached is screenshot "step6_screenshot for reference.PNG" for reference.
- Go to Workspaces > Create a new designer using wf_retial_lite.mas
- Add any two files> Click Variables tab > add Product Filter Via Fex to Filter toolbar.
- Click Product Filter Via Fex select False > Save and close.
- Create a new Page > Blank template > Add the visualization to the page.
- Add all Filters to the Page.
See the screenshots