Designer: Page filter does not work as expected using procedure with the accept list feature of the MFD

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

Issue/Introduction

Designer: Page filter does not work as expected using procedure with the accept list feature of the MFD

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:

  1.  Log in to WebFOCUS.
  2.  Go to Administration console > Parameter Prompting > Default Auto Prompt Template >set to 'Responsive' rather than 'Designer> Save and clear cache.
  3.  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.
  4.  Go to wf_retail folder> Right click and open wf_retail_lite.mas
  5.  Click View icon from top right > and select Show “Table/Column”.
  6.  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.
  7.  Go to Workspaces > Create a new designer using wf_retial_lite.mas
  8.  Add any two files> Click Variables tab > add Product Filter Via Fex to Filter toolbar.
  9.  Click Product Filter Via Fex select False > Save and close.
  10.  Create a new Page > Blank template > Add the visualization to the page.
  11.  Add all Filters to the Page.


See the screenshots

Attachments

Designer: Page filter does not work as expected using procedure with the accept list feature of the MFD get_app