Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Issue with cascading filters in InfoAssist+

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Issue with cascading filters in InfoAssist+
 Login/Join
 
Platinum Member
posted
In InfoAssist+, I have series of filters and they are chained. Normally, a child filter control looks at all the parent control values in the chain before populating. However, in InfoAssist+, a child control is only looking at its immediate parent and not all the parents in the chain hierarchy. Is there a way to force it to apply all the parent values? Please let me know.

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8207.11
App Studio 8207
 
Posts: 146 | Registered: January 06, 2009Report This Post
Virtuoso
posted Hide Post
WFConsultant

If you create a document with Active Report as the output IA+ will allow you to insert dropdown boxes or Lists which you can cascade and all these controls work as you wish. I don't think filters behave that way.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Virtuoso
posted Hide Post
Are your parameters Multi Select or single Select?


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
Platinum Member
posted Hide Post
quote:
Originally posted by BabakNYC:
Are your parameters Multi Select or single Select?


I am using multi select controls.


WebFOCUS 8207.11
App Studio 8207
 
Posts: 146 | Registered: January 06, 2009Report This Post
Virtuoso
posted Hide Post
Using IB sample table that has a hierarchy for Product Category/subcategory/model, I created this example in InfoAssist:

  
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



When I pick a Product and go to Model, only those Models that belong to the Product show up, even though I'm not selecting a Subcategory. Is this the behavior you're not seeing?


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
Platinum Member
posted Hide Post
quote:
If you create a document with Active Report as the output IA+ will allow ...


Thanks for your suggestion. It is true that the document adds cascading filters. However, documents are not great for large reports. It adds lot of overheads to the report. Unfortunately, I am dealing with large a report.


WebFOCUS 8207.11
App Studio 8207
 
Posts: 146 | Registered: January 06, 2009Report This Post
Platinum Member
posted Hide Post
quote:
Originally posted by BabakNYC:
Using IB sample table that has a hierarchy for Product Category/subcategory/model, I created this example in InfoAssist:


The cascading works great if the data is not repeating in the parent control. For example, in the following metrics the Sub Category value, Professional, is repeating for Camcorder and Computers. So, when you choose the value, Professional, in the Sub Category then the Model values belonging to Camcorder and Computers will show up as they both have same Sub Category, Professional. Essentially, InfoAssist is looking at immediate parent control value. Not the entire chain.

Category | Sub Category | Model
---------------------------------------
Camcorder | Professional | Canon XHA1S
Camcorder | Professional | JVC GYHD200U
Camcorder | Standard | Canon FS300
Camcorder | Standard | JVC GZHD620B


Computers | Professional | Dell Latitude
Computers | Professional | Dell Inspiron
Computers | Tablet | MicroSoft Surface
Computers | Tablet | Apple iPad


WebFOCUS 8207.11
App Studio 8207
 
Posts: 146 | Registered: January 06, 2009Report This Post
Virtuoso
posted Hide Post
I can see your point. However, what would you rather see happen when you pick professional in Subcategory?


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
Platinum Member
posted Hide Post
quote:
Originally posted by BabakNYC:
I can see your point. However, what would you rather see happen when you pick professional in Subcategory?


For Category = Computers and Sub Category = Professional, I am expected to see only Dell Latitude and Dell Inspiron in Model. Instead, I am seeing 4 records in Models.

1. Canon XHA1S
2. JVC GYHD200U
3. Dell Latitude
4. Dell Inspiron


WebFOCUS 8207.11
App Studio 8207
 
Posts: 146 | Registered: January 06, 2009Report This Post
Virtuoso
posted Hide Post
WFDeveloper

I would agree with you and I think you should open a case and report this as a problem.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Issue with cascading filters in InfoAssist+

Copyright © 1996-2020 Information Builders