How to create Cascading filter in WebFOCUS Designer? I used below code but didn't work. Thank you in advance!

[Srilatha Amiti]

ENGINE INT CACHE SET ON

SET PAGE-NUM=NOLEAD

SET SQUEEZE=ON

-DEFAULTH &WF_HTMLENCODE=ON;

SET HTMLENCODE=&WF_HTMLENCODE

SET HTMLCSS=ON

-DEFAULTH &WF_EMPTYREPORT=ON;

SET EMPTYREPORT=&WF_EMPTYREPORT

-DEFAULTH &WF_SUMMARY='Summary';

-DEFAULTH &WF_TITLE='WebFOCUS Report';

TABLE FILE WF_RETAIL

SUM WF_RETAIL.WF_RETAIL_SALES.COGS_US

WF_RETAIL.WF_RETAIL_SALES.GROSS_PROFIT_US

WF_RETAIL.WF_RETAIL_SALES.REVENUE_US

BY WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY

BY WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_SUBCATEG

BY WF_RETAIL.WF_RETAIL_PRODUCT.MODEL

WHERE WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY EQ &PRODUCT_CATEGORY.(OR(FIND WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY IN WF_RETAIL |FORMAT=A40V,SORT=ASCENDING)).Product Category:.;

WHERE WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_SUBCATEG EQ &PRODUCT_SUBCATEG.(OR(FIND WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_SUBCATEG IN WF_RETAIL |FORMAT=A50V,SORT=ASCENDING ,WITHIN=PRODUCT_CATEGORY)).Product Subcategory:.;

WHERE WF_RETAIL.WF_RETAIL_PRODUCT.MODEL EQ &MODEL.(OR(FIND WF_RETAIL.WF_RETAIL_PRODUCT.MODEL IN WF_RETAIL |FORMAT=A50V,SORT=ASCENDING ,WITHIN=PRODUCT_SUBCATEG)).Product Model:.;

ON TABLE PCHOLD FORMAT HTML

ON TABLE NOTOTAL

ON TABLE SET CACHELINES 100

ON TABLE SET GRWIDTH 1

ON TABLE SET STYLE *

INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$

TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, SUMMARY=&WF_SUMMARY.QUOTEDSTRING, ORIENTATION=LANDSCAPE, $

ENDSTYLE

END

-RUN

[Patrick Huebgen]

Which version of WebFOCUS - there are some more options innewer versions

[Srilatha Amiti]

I am using 9.2.0

[Patrick Huebgen]

Try

WHERE wf_retail.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY EQ &DF_WH_PRODUCT_CATEGORY.(OR(FIND wf_retail.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY IN retail_samples/wf_retail |FORMAT=A40V,COMPARATOR=EQ,SORT=ASCENDING,FIELDNAME=wf_retail.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY)).Produkt Kategorie.;

WHERE wf_retail.WF_RETAIL_PRODUCT.PRODUCT_SUBCATEG EQ &DF_WH_PRODUCT_SUBCATEG.(OR(FIND wf_retail.WF_RETAIL_PRODUCT.PRODUCT_SUBCATEG IN retail_samples/wf_retail |FORMAT=A50V,COMPARATOR=EQ,SORT=ASCENDING,FIELDNAME=wf_retail.WF_RETAIL_PRODUCT.PRODUCT_SUBCATEG,WITHIN=DF_WH_PRODUCT_CATEGORY)).Produkt Unterkategorie.;

[Srilatha Amiti]

Thank you so much for the reply, Patrick. It is working report level, but not for dashboard. I am attaching the screenshot (left side is report level & Right side of the screenshot is Dashboard).

[Patrick Huebgen]

Do you have a hirarchy defined in your master file and what does Designer Show in - Filter - there shhould be a hirarchy as well

[David Beagan]

Srilatha Amiti, I ran the wf_retail code example you provided in WebFOCUS 9.1.0. It worked at the report level (Autoprompt) and it worked in Designer. Did the wf_retail code example work for you in Designer?

[Srilatha Amiti]

No David. It is working for me Report level, but not in Dashboard level.

[Srilatha Amiti]

Patrick, could you please help me how i can define hierarchy in your master file please.

[David Beagan]

I asked because you showed an image comparing the run for the report level to the run for the Designer level. But that image looks different than what you would get from runninng the code you poasted.

Your code for the wf_retail example works fine for me in Designer 9.1.0, but not for you in 9.2.0. That seems like a bug and you would open a case with ibi.

Here is the simpest example I could come up with based on the car file. Does it work in Designer for you?

TABLE FILE CARPRINT LENGTH BY COUNTRY BY CAR WHERE COUNTRY EQ '&COUNTRY.(FIND COUNTRY IN CAR).'WHERE CAR EQ '&CAR.(FIND CAR IN CAR| WITHIN=COUNTRY).'END

And the list gets filtered in Designer:

 

[Srilatha Amiti]

You are right. It could be a bug in 9.2.0 version. I used the same logic what you and Patrick used but didn't work for me in dashboard level.

[David Beagan]

As far as know, the chaining can be accomplished by coding the WITHIN keywords in the variable, as you have done in your example.

I think the hierarchy in the Master file is for use by GUI tools to write code to do the chaining.

[Patrick Huebgen]

Yes chaining is only extra - please check my channel there are some sessions on metadata

did you checked the screenshot - and do you see the hierarchy in Designer as shown on my screen?

[Patrick Huebgen]

I was using 9.20 without a problem - my sample was created in 9.21 - I can check in 9.20.

do you have any Hotfixes applied?

[Srilatha Amiti]

No Patrick.

[Srilatha Amiti]

Sure, i will check your channel. Yes, i did.

[Srilatha Amiti]

Patrick, I see what you mean. I am not seeing this for my existing dashboard, but when i recreate the dashboard i am able to see the link between Region and Office name. Attaching the screenshots below. Thank you so much for helping me.

[Srilatha Amiti]

Thank you, David for helping me. Now i am able to see cascading filters once i recreate the dashboard.

[Patrick Huebgen]

Ah - now I see what happened - filters will not refresh in dashboard - no need to recreate it - just remove the report and add it again to force the refresh

[Srilatha Amiti]

Perfect... I removed the report and added it again. It is working for me now. Thank you, Patrick. I really appreciate it.