Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Dynamic Filters in Reporting Object with Filter Panel on Portal in 8204
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Dynamic Filters in Reporting Object with Filter Panel on Portal in 8204
 Login/Join
 
Platinum Member
posted
FocalPoint Forum Community:

As always, thank you in advance for any advice or guidance you can provide me. This community has been wonderful to me, and I appreciate it.

My latest challenge is to create a portal using

Chapter 8: Enhancing Portals Using Interactive Features and Coding Techniques in the manual titled Business Intelligence Portal Release 8.2 Version 04.

The portal works beautifully overall. I followed the directions to create a reporting object, its accompanying filter panel, and then I combined them in the filter panel.

The one glitch I'm experiencing has to do with the dynamic filters I've established.

 TABLE FILE CAR
BY  CAR.ORIGIN.COUNTRY
BY  CAR.COMP.CAR
BY  CAR.CARREC.MODEL
BY  CAR.BODY.BODYTYPE
WHERE ( CAR.ORIGIN.COUNTRY EQ &COUNTRY.(FIND CAR.ORIGIN.COUNTRY IN car|FORMAT=A10).COUNTRY:.QUOTEDSTRING ) 
WHERE ( CAR.COMP.CAR EQ &CAR.(FIND CAR.COMP.CAR IN car|FORMAT=A16).CAR:.QUOTEDSTRING ) 
WHERE ( CAR.CARREC.MODEL EQ &MODEL.(FIND CAR.CARREC.MODEL IN car|FORMAT=A24).MODEL:.QUOTEDSTRING )
WHERE ( CAR.BODY.BODYTYPE EQ &BODYTYPE.(FIND CAR.BODY.BODYTYPE IN car|FORMAT=A12).BODYTYPE:.QUOTEDSTRING );
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/warm.sty,
$
ENDSTYLE
END 


In the filter panel, I chained all four filters together. That way, when one changes, they all update appropriately.

They are all optional, dynamic filters. None are multiselect.

They all work great except one.

If someone selects the model first, the report headings show without data.

If someone selects the model, the other data around it should populate the report.

To liken it to a country, region, store example, if someone chooses the store first, the country and region should update, but they don't.

Does anyone have any suggestions?

I apologize if this seems like a mundane question. I've looked in several manuals, and I've tried various combinations of dynamic and static parameters, all with varying degrees of success. I think I am missing something obvious. This is my first foray into reporting objects.

Thank you again for any advice, even if it's to direct me to a manual or post. I might have overlooked something.

This message has been edited. Last edited by: JulieA,


WebFocus 8.2.04
WebFocus 8.2.04

 
Posts: 154 | Registered: September 18, 2015Reply With QuoteReport This Post
Virtuoso
posted Hide Post
You need to see this as a Hierarchy between Country - > Car - > Model - > BodyType.
Chaining the control together will insure that from the selection you made, the following criteria will update accordingly : from left to right and will never update from right to left.

In other words, a parent selection will update downward its child but a child selection will not update its parent backward. Always in the "- >" direction never in the opposite direction.

If you want to have the Country and Car list updated according to selected Model you will need to go with js (or jquery) recursively.
I don't think that it will be possible with a RO or dynamic filter built that way. You will need to code.


WF versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2231 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Are you using the Page Designer to assemble your content and generate the parameters? You may want to use the WITHIN= in your WHERE test and try putting your code in a Page. Allowing the Page to generate the parameters makes this a little easier to deal with and picking a value in any of the parameters cascades to the available values in the others. Create this example and put it in a Page. When you get prompted to create the parameters you'll see 4 parameters that are inter-related.
 
-DEFAULT &COUNTRY=_FOC_NULL;
-DEFAULT &CAR=_FOC_NULL;
-DEFAULT &MODEL=_FOC_NULL;
-DEFAULT &BODYTYPE=_FOC_NULL;
TABLE FILE CAR
BY  CAR.ORIGIN.COUNTRY
BY  CAR.COMP.CAR
BY  CAR.CARREC.MODEL
BY  CAR.BODY.BODYTYPE
WHERE ( CAR.ORIGIN.COUNTRY EQ &COUNTRY.(FIND CAR.ORIGIN.COUNTRY IN car|FORMAT=A10).COUNTRY:.QUOTEDSTRING ) 
WHERE ( CAR.COMP.CAR EQ &CAR.(FIND CAR.COMP.CAR IN car|FORMAT=A16,WITHIN=COUNTRY).CAR:.QUOTEDSTRING ) 
WHERE ( CAR.CARREC.MODEL EQ &MODEL.(FIND CAR.CARREC.MODEL IN car|FORMAT=A24,WITHIN=CAR).MODEL:.QUOTEDSTRING )
WHERE ( CAR.BODY.BODYTYPE EQ &BODYTYPE.(FIND CAR.BODY.BODYTYPE IN car|FORMAT=A12, WITHIN=CAR).BODYTYPE:.QUOTEDSTRING );
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/warm.sty,
$
ENDSTYLE
END  


WebFOCUS 8206, Unix, Windows
 
Posts: 1713 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Platinum Member
posted Hide Post
The use of WITHIN might have done it. I understand the example, and I'm going to try it with my own data now. I'll post any additional questions next week.

Thanks.


WebFocus 8.2.04
WebFocus 8.2.04

 
Posts: 154 | Registered: September 18, 2015Reply With QuoteReport This Post
Platinum Member
posted Hide Post
The use of WITHIN works inside my reporting object and with my filter panel. Thank you so much, BabakNYC. I appreciate learning about WITHIN and its usage.


WebFocus 8.2.04
WebFocus 8.2.04

 
Posts: 154 | Registered: September 18, 2015Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Dynamic Filters in Reporting Object with Filter Panel on Portal in 8204

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.