Manoj Chaurasia Posted January 18, 2021 Share Posted January 18, 2021 Hi Benjamin This is a post that was in Focal Point a while back by NYCBabak that answers this question. Designer page as well as Autoprompt automatically chain parameters if they are in the same hierarchy. For instance, if your master file has a Dimension View Folder of Geography in which youve defined COUNTRY-> STATE->CITY as a hierarchy, then when you create a report with COUNTERY, STATE and CITY as parameters, Designer will chain them together. To my knowledge there isnt any other way to chain parameters in the designer. Link to comment Share on other sites More sharing options...
David Beagan Posted January 18, 2021 Share Posted January 18, 2021 And you dont necessarily need to have the hierarchy encoded in the master file. As I posted in focal point Chained controls in Designer You can accomplish the chaining in Designer entirely from what is encoded in the fex: -DEFAULT &aregion = '_FOC_NULL'; -DEFAULT &ast = '_FOC_NULL'; -DEFAULT &acity = '_FOC_NULL'; TABLE FILE ibisamp/ggsales SUM UNITS BY REGION BY ST BY CITY BY DATE ACROSS PCD WHERE ( REGION EQ &aregion.(FIND REGION IN GGSALES|FORMAT=A11).Region.QUOTEDSTRING ) AND ( ST EQ &ast.(FIND ST IN GGSALES|FORMAT=A02,WITHIN=aregion).State code.QUOTEDSTRING ) AND ( CITY EQ &acity.(FIND CITY IN GGSALES|FORMAT=A20,WITHIN=ast).City.QUOTEDSTRING ); ON TABLE SET STYLE * INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty, $ ENDSTYLE END Link to comment Share on other sites More sharing options...
Ben Maxwell Posted January 18, 2021 Author Share Posted January 18, 2021 My simple question is can you chain controls in WebFocus 8.206 when building a Page in the Designer tool i.e. I would like to chain my filters for Company --> Division --> Cost Center. Right now when I bring in to the controls I am unable to view an option to chain my selections. If I would build a similar report in a HTML Page I would have no issues with chaining. If this cant be done in 8.206 can it be done in 8.207 Link to comment Share on other sites More sharing options...
Charles Morris 2 Posted January 19, 2021 Share Posted January 19, 2021 David, thats another great technique - one of my pet peeves with Designer has been the limitations of chaining vs using external procedures in App Studio but this provides some flexibility Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now