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] EMBEDHEADING?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] EMBEDHEADING?
 Login/Join
 
Expert
posted
Is there a known issue with EMBEDHEADING? Or, perhaps, an additional counter-part to this setting which counter acts the ill affects shown in the below image?

I need to have a link in the heading of a chart without scrollbars. This fex, of a production version, not the CAR file, will reside in a portal. The scrollbar renders it unacceptable.

Is there a 'counter-part' to it that would produce the HEADING as seen in the image on the right while not displaying the scrollbars?

The below image shows it set to ON and OFF. both are unacceptable.


Link to image.


Sorry, the image shows the incorrect % Profit. The code below has been modified to display the correct % Profit.
So, ignore the Profit in the images as they do not affect the issue with the HEADING and Scrollbar.

The Code: Run it with &EmbedHeading -SET to ON and OFF to see for yourself.
-SET &EmbedHeading = ON ;
-SET &EmbedHeading = OFF ;
-SET &ECHO = ALL;
ENGINE INT CACHE SET ON
SET PAGE-NUM=NOLEAD
-DEFAULTH &WF_HTMLENCODE=ON;
SET HTMLENCODE=&WF_HTMLENCODE
SET ARGRAPHENGINE=JSCHART
-DEFAULTH &WF_EMPTYREPORT=ON;
SET EMPTYREPORT=&WF_EMPTYREPORT
SET EMBEDHEADING=&EmbedHeading.EVAL
-*SET GRAPHDEFAULT=OFF
-DEFAULTH &WF_STYLE_UNITS='PIXELS';
-DEFAULTH &WF_STYLE_HEIGHT='405.0';
-DEFAULTH &WF_STYLE_WIDTH='770.0';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
GRAPH FILE CAR
HEADING
" <0>Max<0> CAR: Dealer Cost, Retail Cost, and Percent of Profit: EmbedHeading = &EmbedHeading"
SUM DCOST/D12.2M AS 'Dealer'
    RCOST/D12.2M AS 'Retail'
-* Code Correction:
COMPUTE PCT_PROFIT/D12.2% = ((RCOST - DCOST) / DCOST ) * 100 ; AS 'Profit'
BY MODEL
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET GRWIDTH 1
ON GRAPH SET AUTOFIT ON
ON GRAPH SET UNITS &WF_STYLE_UNITS
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET LOOKGRAPH VBAR2AX
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setPlace(true);
setCurveFitEquationDisplay(false);
*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/combine_templates/ENWarm.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $

TYPE=HEADING, LINE=1, JUSTIFY=LEFT, FONT='ARIAL', SIZE=9, COLOR=RGB(0 0 0), $

TYPE=HEADING, LINE=1, ITEM=2, ALT='Maximize', STYLE=BOLD, TARGET='_blank', HYPERLINK-COLOR=RGB(1 1 1),
     FOCEXEC=IBFS:/WFC/Repository/Finance/Portal_Pages/Executive/Charts/EMBEDHEADING_Sample.fex, $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDisplay(getY1MajorGrid(),false);
setSeriesType(0,1);
setSeriesType(1,1);
setSeriesType(2,2);
setDisplay(getLegendArea(),true);
setLegendPosition(2);

setMarkerShape(getAllSeries(),2);
setMarkerSizeDefault ( 50 );

setMarkerShape(getAllSeries(),13);
setMarkerShape(getSeries(0),3);
setMarkerShape(getSeries(1),13);
setMarkerShape(getSeries(2),2);

setFillColor(getSeries(1),new Color(39,107,175));
setTransparentBorderColor(getSeries(1), true);
setFillColor(getSeries(0),new Color(155,216,119));
setTransparentBorderColor(getSeries(0), true);
setFillColor(getSeries(2),new Color(0,0,0));
setTransparentBorderColor(getSeries(2), true);

setLabelStagger(getO1Label(),false);
setConnectLineMarkers(true);
setTextFormatPreset(getY1Label(),15);
setTextRotation(getO1Label(),3);
setTextFormatPreset(getY2Label(),28);
setAxisAssignment( $0, 0);
setAxisAssignment( $1, 0);
setAxisAssignment( $2, 1);
*GRAPH_JS_FINAL
"xaxis": {
    "title": {
        "visible": false
    }
},
"pieProperties": {
    "holeSize": "0%"
},
"agnosticSettings": {
    "chartTypeFullName": "Bar_Clustered_Dual_Axis"
}
*END
ENDSTYLE
END

As always, Thanks.
Doug
Using 8202M, Thinking about 8203M...

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




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Expert
posted Hide Post
Smiler I got it to work using a sample fex in the GUI.
Frowner But don't really understand how it's working.

Any explanations or directions to associated information are welcome.
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Expert
posted Hide Post
What did you do ?

I'm intrigued.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Member
posted Hide Post
We had that problem.
The reason is that by not indicating the "EMBEDHEADING" is adding the size of the graph plus the size of the header, which generates the scrollbar.

In your case I would have considered several options:
- Using HTML indicate: overflow-y: hidden;
- Change the height of the graph (this does not work in all cases, because in some places it takes into account the height of the FEX to put the HTML size).
- Put it with EMBEBED + link via HTML "floating" with HTML code. Remember that you can dynamically generate that link using a webfocus variable.


WebFOCUS 8

Windows, All Outputs
 
Posts: 7 | Registered: April 20, 2018Report This Post
Expert
posted Hide Post
MMoreno: This needs to be, and can be, done within a single fex. I know that We can do that in WebFOCUS!.

Waz: I created a very basic GRAPH in text with the heading that I wanted and an associated drilldown. Ran it. Opened it in the GUI. Saved/Exited. It was fine.
Starting/Base Fex - Pre-GUI
 
GRAPH FILE CAR
HEADING
" <0>Max<0> CAR: Dealer Cost, Retail Cost, and Percent of Profit (Pre-GUI)"
SUM DCOST/D12.2M AS 'Dealer'
    RCOST/D12.2M AS 'Retail'
COMPUTE PCT_PROFIT/D12.2% = ((RCOST - DCOST) / DCOST ) * 100 ; AS 'Profit'
BY MODEL
ON GRAPH SET STYLE *
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/combine_templates/ENWarm.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $

TYPE=HEADING, LINE=1, JUSTIFY=LEFT, FONT='ARIAL', SIZE=9, COLOR=RGB(0 0 0), $

TYPE=HEADING, LINE=1, ITEM=2, ALT='Maximize', STYLE=BOLD, TARGET='_blank', HYPERLINK-COLOR=RGB(1 1 1),
     FOCEXEC=IBFS:/WFC/Repository/Finance/Portal_Pages/Executive/Charts/CAR_File_FP_Base.fex, $
ENDSTYLE
END

Starting/Base Fex - Post-GUI
-TYPE *** CAR_File_FP_Base (Post-GUI) ***
-SET &ECHO = ALL ;
-*IA_GRAPH_BEGIN
-*Do not delete or modify the comments below
*-INTERNAL_COMMENT 
-**** I removed these lines for brevity ***
-*Do not delete or modify the comments above
ENGINE INT CACHE SET ON
SET PAGE-NUM=NOLEAD
SET ARGRAPHENGINE=JSCHART
SET EMBEDHEADING=ON
SET GRAPHDEFAULT=OFF
-DEFAULTH &WF_STYLE_UNITS='PIXELS';
-DEFAULTH &WF_STYLE_HEIGHT='405.0';
-DEFAULTH &WF_STYLE_WIDTH='770.0';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
GRAPH FILE CAR
-* Created by Info Assist for Graph
SUM CAR.BODY.RETAIL_COST/D12.2M AS 'Retail'
CAR.BODY.DEALER_COST/D12.2M AS 'Dealer'
COMPUTE PCT_PROFIT/D12.2%=( ( RCOST - DCOST )/DCOST ) * 100 ; AS 'Profit'
BY CAR.CARREC.MODEL
HEADING
" <0>Max<0> CAR: Dealer Cost, Retail Cost, and Percent of Profit (Post-GUI)"
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET AUTOFIT ON
ON GRAPH SET GRWIDTH 1
ON GRAPH SET UNITS &WF_STYLE_UNITS
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET LOOKGRAPH BAR
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setPlace(true);
setCurveFitEquationDisplay(false);
*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
TYPE=HEADING, LINE=1, JUSTIFY=LEFT, FONT='ARIAL', SIZE=9, COLOR=RGB(0 0 0), $
TYPE=HEADING, LINE=1, ITEM=2, ALT='Maximize', STYLE=BOLD, TARGET='_blank', HYPERLINK-COLOR=RGB(1 1 1), FOCEXEC=IBFS:/WFC/Repository/Finance/Portal_Pages/Executive/Charts/CAR_File_Base_GUIed.fex, $
TYPE=DATA, COLUMN=N1, BUCKET=x-axis, $
TYPE=DATA, COLUMN=N2, BUCKET=y-axis, $
TYPE=DATA, COLUMN=N3, BUCKET=y-axis, $
TYPE=DATA, COLUMN=N4, BUCKET=y-axis, $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
*END
ENDSTYLE
END
-RUN

-*IA_GRAPH_FINISH


I really done want to do this each time I need this functionality. However, I do keep one as a base and plagiarize as needed.

~ Doug
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Expert
posted Hide Post
I guess you haven't spotted what made it work ?
The difference between your old one and the GUI massaged new one.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Expert
posted Hide Post
I Do see the big difference between the Pre-GUI an Post-GUI versions. But, what is it, exactly, that makes it happen? Confused
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 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] EMBEDHEADING?

Copyright © 1996-2020 Information Builders