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] Multiselect on a detailed and drilldown report

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Multiselect on a detailed and drilldown report
 Login/Join
 
Platinum Member
posted
Hi Everyone,

I have created a report(Report1) which will drill down to a detailed report(Report2).It works fine.Now, I am trying to include a multiselect dropdown to both the reports. My idea is to have a multiselect dropdown which can be used to filter these two reports and also the drilldown should still work. Expected flow of usage is, user will run the Report1 and when the column value like 'Computers' in PRODUCT_CATEGORY or PRODUCT_SUBCATEG is clicked it will take the user to the drilldown report(Report2). Drilldown report should obviously filter based on the value that is clicked. Drilldown report should also have an option to filter on the PRODUCT_CATEGORY, PRODUCT_SUBCATEG and Sale,Date after it is loaded. Is it possible to do it within a report(fex) itself? Please provide your inputs if it is doable.Thank you very much in advance.

Kind Regards

Report 1

  

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_lite
SUM WF_RETAIL_LITE.WF_RETAIL_SALES.REVENUE_US
WF_RETAIL_LITE.WF_RETAIL_SALES.GROSS_PROFIT_US
BY WF_RETAIL_LITE.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY
BY WF_RETAIL_LITE.WF_RETAIL_PRODUCT.PRODUCT_SUBCATEG
WHERE WF_RETAIL_LITE.WF_RETAIL_TIME_SALES.TIME_DATE GE '20161224';
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, $
TYPE=DATA, COLUMN=N1, ALT='Drill down report', TARGET='_blank', FOCEXEC=IBFS:/WFC/Repository/metrics_sample/report2.fex(PRODUCT_CATEGORY=WF_RETAIL_LITE.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY), $
TYPE=DATA, COLUMN=N2, ALT='Drill down report', TARGET='_blank', FOCEXEC=IBFS:/WFC/Repository/metrics_sample/report2.fex(PRODUCT_SUBCATEG=WF_RETAIL_LITE.WF_RETAIL_PRODUCT.PRODUCT_SUBCATEG), $
ENDSTYLE
END

-RUN


For multiselect dropdown I will use the below in where condition

WHERE PRODUCT_CATEGORY EQ '&PRODUCT_CATEGORY.(FIND WF_RETAIL_LITE.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY,WF_RETAIL_LITE.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY IN WF_RETAIL_LITE).Product Category.';

WHERE PRODUCT_SUBCATEG EQ '&PRODUCT_SUBCATEG.(FIND WF_RETAIL_LITE.WF_RETAIL_PRODUCT.PRODUCT_SUBCATEG,WF_RETAIL_LITE.WF_RETAIL_PRODUCT.PRODUCT_SUBCATEG IN WF_RETAIL_LITE).Product Sub Category.';

Report 2(Drilldown Report)

 
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_lite
SUM WF_RETAIL_LITE.WF_RETAIL_SALES.REVENUE_US
WF_RETAIL_LITE.WF_RETAIL_SALES.COGS_US
WF_RETAIL_LITE.WF_RETAIL_SALES.GROSS_PROFIT_US
BY WF_RETAIL_LITE.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY
BY WF_RETAIL_LITE.WF_RETAIL_PRODUCT.PRODUCT_SUBCATEG
WHERE WF_RETAIL_LITE.WF_RETAIL_TIME_SALES.TIME_DATE GE '20161224';
WHERE WF_RETAIL_LITE.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY EQ &PRODUCT_CATEGORY.(|FORMAT=A40V).Product Category:.QUOTEDSTRING;
WHERE WF_RETAIL_LITE.WF_RETAIL_PRODUCT.PRODUCT_SUBCATEG EQ &PRODUCT_SUBCATEG.(|FORMAT=A50V).Product Subcategory:.QUOTEDSTRING;
ON TABLE PCHOLD FORMAT HTML
ON TABLE NOTOTAL
ON TABLE SET CACHELINES 100
ON TABLE SET STYLE *
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, SUMMARY=&WF_SUMMARY.QUOTEDSTRING, $
ENDSTYLE
END

-RUN
 

This message has been edited. Last edited by: FP Mod Chuck,
 
Posts: 106 | Registered: June 26, 2018Report This Post
Virtuoso
posted Hide Post
BI Dev

Drill downs are not multi select you would have to create a html form with drop downs that allow mulit-select to run report 1 and then the drill down is what it is you click on a value and it sends that as the parameter to report 2


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
Platinum Member
posted Hide Post
Hi Chuck,

Thanks for your response. That is what I thought, just wanted to see if it is doable from report itself.


Webfocus 8105/8202
Windows
All Outputs
 
Posts: 106 | Registered: June 26, 2018Report 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] Multiselect on a detailed and drilldown report

Copyright © 1996-2020 Information Builders