Designer: Page filter does not work as expected using procedure with the accept list feature of the MFD
book
Article ID: KB0070602
calendar_today
Updated On:
Products
Versions
ibi WebFOCUS
WebFOCUS 9.x
Description
Designer procedure using the accept list feature of master files filter options does not work
Resolution
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
Issue/Introduction
Designer: Page filter does not work as expected using procedure with the accept list feature of the MFD
Attachments
Designer: Page filter does not work as expected using procedure with the accept list feature of the MFDget_app