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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at firstname.lastname@example.org and provide your corporate email address, company, and name.
we added widgets as well as HTML to Page Designer (8.2.04). The Page is in a Portal. The HTML gives an error when running the Page. It says: "This HTML page is designed to work inside of the BI Portal. Please add this HTML page to a BI Portal page and try again." But it is already in a Portal!
Anybody a solution?
Regards RonThis message has been edited. Last edited by: FP Mod Chuck,
If I understand you correctly, You have built an HTML filter panel and put that in a page using the new WF Page Designer. You've then put that page from the Page Designer inside a portal. Is this correct?
If so, then the problem that you are having is that the filter panel thinks that it is inside a page, not a portal.
The filter panel needs to be added directly to a portal to be used, along with the reports/charts that you want controlled by the filter panel. This VIDEO shows how.
If you are wanting to use the Page Designer, then there is no need for a filter panel created in the HTML canvas. The page designer will read your unresolved parameters and create its own filters. You can then add that page to a portal and it works fine. The key to using the Page Designer, is in the setting up of your parameters in the report. For example, using the code below, create a fex and save it off. then in the page designer, drag and drop that fex into a new page. It takes a few seconds, but you will soon see in the upper right of the Page Designer heading, a filter icon with a red circle with the number 9 in it. This means that the page designer has 9 unresolved parameters that it will create filters for. Just click on that and the filter bar is created with chaining where requested in the code. You can further customize the controls with a limited number of options. This VIDEO demonstrates all of this.
TABLE FILE wf_retail
"Product Models sold between &TIME_DATE_FROM and &TIME_DATE_TO in &BUSINESS_REGION &BUSINESS_SUB_REGION where:"
"Cost of Goods is above &COGS_US"
"Gross Profit is above &GROSS_PROFIT_US"
SUM WF_RETAIL.WF_RETAIL_SALES.COGS_US WF_RETAIL.WF_RETAIL_SALES.GROSS_PROFIT_US
-** 1ST CHAINED GROUPING **
-*Single Select Dynamic List (7 values)
WHERE WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY EQ '&PRODUCT_CATEGORY.(FIND WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY IN WF_RETAIL |FORMAT=A40V).Product Category:.';
-*Chained Multi-select Select Dynamic List (fewer than 10 values for PRODUCT_CATEGORY value)
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,WITHIN=PRODUCT_CATEGORY)).Product Subcategory:.;
-*Chained Multi-select Dynamic List (All Values and # of values dependent on chained selection.
-*Selecting Product Category (Media Player) and Product Subcategory (Blu Ray) more than 25 values.
-*Product Category (Media Player) and Product Subcategory (DVD Players) more than 10 values and fewer than 25 values.
WHERE WF_RETAIL.WF_RETAIL_PRODUCT.MODEL EQ &MODEL.(OR(FIND WF_RETAIL.WF_RETAIL_PRODUCT.MODEL IN WF_RETAIL|FORMAT=A50V,WITHIN=PRODUCT_SUBCATEG)).Product Model:.;
-** 2ND CHAINED GROUPING **
-* Single Multiselect Static List (4 values)
WHERE WF_RETAIL.WF_RETAIL_GEOGRAPHY_STORE.BUSINESS_REGION EQ '&BUSINESS_REGION.(FIND WF_RETAIL.WF_RETAIL_GEOGRAPHY_STORE.BUSINESS_REGION IN WF_RETAIL|FORMAT=A15V).Business Region:.';
-* Chained Single Dynamic List (10 or fewer values for each Business Region selection)
WHERE WF_RETAIL.WF_RETAIL_GEOGRAPHY_STORE.BUSINESS_SUB_REGION EQ '&BUSINESS_SUB_REGION.(FIND WF_RETAIL.WF_RETAIL_GEOGRAPHY_STORE.BUSINESS_SUB_REGION IN WF_RETAIL |FORMAT=A25V,WITHIN=BUSINESS_REGION).Business Sub Region:.';
-** NOT CHAINED GROUPING **
-*Dynamic Single Select List (Over 25 values)
WHERE WF_RETAIL.WF_RETAIL_SALES.COGS_US GT '&COGS_US.(FIND WF_RETAIL.WF_RETAIL_SALES.COGS_US IN WF_RETAIL |FORMAT=D20.2M).Cost of Goods above:.';
-*Simple Prompt (Enter numeric value)
WHERE WF_RETAIL.WF_RETAIL_SALES.GROSS_PROFIT_US GT &GROSS_PROFIT_US.(|FORMAT=D20.2M).Gross Profit above:.QUOTEDSTRING;
-*Simple Prompt - Calendar (Select date value)
WHERE WF_RETAIL.WF_RETAIL_TIME_SALES.TIME_DATE GE &TIME_DATE_FROM.(|FORMAT=YYMD).Date Range of Sale From:.QUOTEDSTRING;
WHERE WF_RETAIL.WF_RETAIL_TIME_SALES.TIME_DATE LE &TIME_DATE_TO.(|FORMAT=YYMD).Date Range of Sale To:.QUOTEDSTRING;
ON TABLE SET STYLE *
Posts: 608 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015