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] Power Point Templates

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Power Point Templates
 Login/Join
 
Member
posted
To anyone who may know why this error occurs:

I am running a procedure where I create a chart and save it and then place that hold chart name on a template that I created and it should open in power point.

This is my error message -

--------------------------------------------------------------------------------

Your request did not return any output to display.
Possible causes:
- No data rows matched the specified selection criteria.
- Output was directed to a destination such as a file or printer.
- An error occurred during the parsing or running of the request.


--------------------------------------------------------------------------------


SRREGDEF RUNNING SR MAIN DEFINE
1
0 NUMBER OF RECORDS IN TABLE= 104766 LINES= 993
0 NUMBER OF RECORDS IN TABLE= 993 LINES= 24
0 NUMBER OF RECORDS IN GRAPH= 24 PLOT POINTS= 6
GIF FILE SAVED ...
0 NUMBER OF RECORDS IN GRAPH= 24 PLOT POINTS= 6
GIF FILE SAVED ...
0 NUMBER OF RECORDS IN GRAPH= 24 PLOT POINTS= 6
GIF FILE SAVED ...
0 NUMBER OF RECORDS IN GRAPH= 24 PLOT POINTS= 6
GIF FILE SAVED ...
0 NUMBER OF RECORDS IN GRAPH= 24 PLOT POINTS= 6
GIF FILE SAVED ...
0 NUMBER OF RECORDS IN GRAPH= 24 PLOT POINTS= 6
GIF FILE SAVED ...
0 NUMBER OF RECORDS IN TABLE= 1 LINES= 1
0 NUMBER OF RECORDS IN TABLE= 1 LINES= 1
0 NUMBER OF RECORDS IN TABLE= 1 LINES= 1
0 NUMBER OF RECORDS IN TABLE= 1 LINES= 1
0 NUMBER OF RECORDS IN TABLE= 1 LINES= 1
(FOC3291) TEMPLATE FILE: Template specification error
(FOC3291) TEMPLATE FILE: Template specification error
(FOC009) INCOMPLETE REQUEST STATEMENT
(FOC3298) ERROR FOUND IN A COMPOUND REPORT
Compound Report is TERMINATING.....
BYPASSING TO END OF COMMAND



The procedure name is - dash_pfe_oe_graph.fex

This is the procedure coding below:

-* File PPTGRAPHTEST.fex
-*runs excel report at closing at region level moobj and oe market and financial folks once monthly used at closing - end of month
-*runs off of the pfehold file
-*JOIN CLEAR

EX PFE_HOLD_FOCUS_12.FEX


SET ALL = ON
SET ASNAMES = ON
TABLE FILE PFEHOLD12
SUM
COMPUTE E/D9SC=EMERGENT/1000;
COMPUTE F/D9SC=FORCED/1000;
COMPUTE P/D9SC=PLANNED/1000;

COMPUTE CPME/D9SC=CTPME/1000;
COMPUTE CPMF/D9SC=CTPMF/1000;
COMPUTE CPMP/D9SC=CTPMP/1000;

COMPUTE SPME/D9SC=STPME/1000;
COMPUTE SPMF/D9SC=STPMF/1000;
COMPUTE SPMP/D9SC=STPMP/1000;

BY FBKYY
-*BY FBK_Q
BY SERVICE_LINE
-*IF MORG EQ 'O251' OR 'O16S'
-*IF OUTAGET1 EQ 'F'
-*IF PL NE 'CT IFO'
ON TABLE HOLD AS GRAPH12
-*ON TABLE PCHOLD FORMAT EXL2K
-*ON TABLE HOLD AS FORCEDGRAPH
END
-RUN

-*---------------------------------------------------------------------------------------------
-*THIS ONE BELOW DOES STEAM AND CT FORCED OUTAGES HISTORICALLY - CHART 1


SET ASNAMES = ON
SET GRAPHSERVURL = ' ';


-*
-*INTERNAL_PROPERTIES$SampleData=false;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$GlobalRecordLimit=500;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$FieldDisplayMode=label;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$PrefixDisplayMode=;OBJECTID=GLOBAL
GRAPH FILE GRAPH12
-* Created by Advanced Graph Assistant
SUM
GRAPH12.E AS 'EMERGENT'
GRAPH12.F AS 'FORCED'
GRAPH12.P AS 'PLANNED'
BY GRAPH12.FBKYY AS 'Fiscal Year - Orders Entered'
ON GRAPH HOLD AS PERFPFEOE FORMAT GIF
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET HAXIS 770
ON GRAPH SET VAXIS 405
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VBRSTK1
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setMarkerDisplay(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setRiserBorderMode(1);
setSeriesDefaultTransparentBorderColor(true);
setUseSeriesBorderDefaults(true);
setLegendDisplay(true);
setTitleString("Historical CT and ST Performance Maintenance\n");
setTextJustHoriz(getTitle(),1);
setFontSizeAbsolute(getTitle(),true);
setFontSize(getTitle(),16);
setSubtitleString("Open Market History - Planned - Forced - Emergent Outages");
setTextJustHoriz(getSubtitle(),1);
setFontSizeAbsolute(getSubtitle(),true);
setFontSize(getSubtitle(),14);
setFontStyle(getSubtitle(),3);
setFootnoteString("File Name: dash_pfe_oe_graph.fex ");
setTextJustHoriz(getFootnote(),2);
setFontSizeAbsolute(getFootnote(),true);
setFontSize(getFootnote(),10);
setLegendTextAutofit(true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setO1LabelAutofit(true);
setPlace(true);
setDisplay(getDataText(),true);
setDataTextRadiusDefault(10);
setZeroValueDataTextDisplay(false);
setStackedDataValueSum(false);
setDisplay(getDataTextStackedTotalOnTop(),true);
setFontName(getDataTextStackedTotalOnTop(),"Arial");
setFontSizeAbsolute(getDataTextStackedTotalOnTop(),true);
setFontSizeInPoints(getDataTextStackedTotalOnTop(),8);
setPlaceResize(getDataText(),1);
setTextRotation(getDataText(),0);
setDataTextPosition(4);
setDisplay(getY1AltFmtFrame(),true);
setLegendPosition(2);
setTextString(getTitle(),"Historical CT and ST Performance Maintenance");
setDisplay(getTitle(),true);
setRiserWidth(85);
setMarkerSizeDefault(20);
setMarkerSizeUnit(800);
setDepthAngle(35);
setDepthRadius(7);
setDisplay(getDataText(4),false);
setTransparentBorderColor(getChartBackground(),true);
setDisplay(getDataText(2),true);
setReverseGroups(false);
setTextFormatPattern(getY1Label(),"#");
setTextFormatPreset(getDataText(0),0);
setTextFormatPreset(getDataText(1),0);
setTextFormatPreset(getDataText(2),0);
setFillColor(getChartBackground(),new Color(255,196,186));
setReverseSeries(true);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getDataText(),"#");
setTextFormatPreset(getDataText(),1);
ENDSTYLE
END
-*---------------------------------------------------------------------------------------------
-*THIS ONE BELOW DOES STEAM AND CT FORCED OUTAGES HISTORICALLY - CHART 2



SET ASNAMES = ON

SET GRAPHSERVURL = ' ';



-*
-*INTERNAL_PROPERTIES$SampleData=false;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$GlobalRecordLimit=500;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$FieldDisplayMode=label;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$PrefixDisplayMode=;OBJECTID=GLOBAL
GRAPH FILE GRAPH12
-* Created by Advanced Graph Assistant
SUM
GRAPH12.CPME AS 'EMERGENT'
GRAPH12.CPMF AS 'FORCED'
GRAPH12.CPMP AS 'PLANNED'
BY GRAPH12.FBKYY AS 'Fiscal Year - Orders Entered'
-*WHERE SERVICE_LINE EQ 'CT FIELD SERVICE' OR ' CT REPAIR'
-*IF MORG EQ 'O16S' OR 'O16R' OR 'O15'
-*IF MORG NE 'O251' OR 'O254' OR 'O253'
-*ON TABLE PCHOLD FORMAT PPT TEMPLATE 'graphtemplate' SLIDENUMBER 2
ON GRAPH HOLD AS CTPFEOE FORMAT GIF
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET HAXIS 770
ON GRAPH SET VAXIS 405
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VBRSTK1
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setMarkerDisplay(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setRiserBorderMode(1);
setSeriesDefaultTransparentBorderColor(true);
setUseSeriesBorderDefaults(true);
setLegendDisplay(true);
setTitleString("Historical CT Performance Maintenance\n");
setTextJustHoriz(getTitle(),1);
setFontSizeAbsolute(getTitle(),true);
setFontSize(getTitle(),16);
setSubtitleString("Open Market History - Planned - Forced - Emergent Outages");
setTextJustHoriz(getSubtitle(),1);
setFontSizeAbsolute(getSubtitle(),true);
setFontSize(getSubtitle(),14);
setFontStyle(getSubtitle(),3);
setFootnoteString("File Name: dash_pfe_oe_graph.fex ");
setTextJustHoriz(getFootnote(),2);
setFontSizeAbsolute(getFootnote(),true);
setFontSize(getFootnote(),10);
setLegendTextAutofit(true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setO1LabelAutofit(true);
setPlace(true);
setDisplay(getDataText(),true);
setDataTextRadiusDefault(10);
setZeroValueDataTextDisplay(false);
setStackedDataValueSum(false);
setDisplay(getDataTextStackedTotalOnTop(),true);
setFontName(getDataTextStackedTotalOnTop(),"Arial");
setFontSizeAbsolute(getDataTextStackedTotalOnTop(),true);
setFontSizeInPoints(getDataTextStackedTotalOnTop(),8);
setPlaceResize(getDataText(),1);
setTextRotation(getDataText(),0);
setDataTextPosition(4);
setDisplay(getY1AltFmtFrame(),true);
setLegendPosition(2);
setTextString(getTitle(),"Historical CT Performance Maintenance");
setDisplay(getTitle(),true);
setRiserWidth(85);
setMarkerSizeDefault(20);
setMarkerSizeUnit(800);
setDepthAngle(35);
setDepthRadius(7);
setDisplay(getDataText(4),false);
setTransparentBorderColor(getChartBackground(),true);
setDisplay(getDataText(2),true);
setReverseGroups(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#");
setTextFormatPreset(getDataText(0),0);
setTextFormatPreset(getDataText(1),0);
setTextFormatPreset(getDataText(2),0);
setFillColor(getChartBackground(),new Color(255,196,186));
setTextFormatPreset(getDataText(),7);
setReverseSeries(true);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getDataText(),"#");
setTextFormatPreset(getDataText(),1);
ENDSTYLE
END

-*---------------------------------------------------------------------------------------------
-*THIS ONE BELOW DOES STEAM AND CT FORCED OUTAGES HISTORICALLY - CHART 3



SET ASNAMES = ON

SET GRAPHSERVURL = ' ';



-*
-*INTERNAL_PROPERTIES$SampleData=false;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$GlobalRecordLimit=500;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$FieldDisplayMode=label;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$PrefixDisplayMode=;OBJECTID=GLOBAL
GRAPH FILE GRAPH12
-* Created by Advanced Graph Assistant
SUM
GRAPH12.SPME AS 'EMERGENT'
GRAPH12.SPMF AS 'FORCED'
GRAPH12.SPMP AS 'PLANNED'
BY GRAPH12.FBKYY AS 'Fiscal Year - Orders Entered'
-*WHERE SERVICE_LINE EQ 'ST FIELD SERVICE' OR ' ST REPAIR'
-*IF MORG EQ 'O251' OR 'O254' OR 'O253'
-*ON TABLE PCHOLD FORMAT PPT TEMPLATE 'graphtemplate' SLIDENUMBER 3
ON GRAPH HOLD AS STPFEOE FORMAT GIF
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET HAXIS 770
ON GRAPH SET VAXIS 405
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VBRSTK1
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setMarkerDisplay(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setRiserBorderMode(1);
setSeriesDefaultTransparentBorderColor(true);
setUseSeriesBorderDefaults(true);
setLegendDisplay(true);
setTitleString("Historical ST Performance Maintenance\n");
setTextJustHoriz(getTitle(),1);
setFontSizeAbsolute(getTitle(),true);
setFontSize(getTitle(),16);
setSubtitleString("Open Market History - Planned - Forced - Emergent Outages");
setTextJustHoriz(getSubtitle(),1);
setFontSizeAbsolute(getSubtitle(),true);
setFontSize(getSubtitle(),14);
setFontStyle(getSubtitle(),3);
setFootnoteString("File Name: dash_pfe_oe_graph.fex ");
setTextJustHoriz(getFootnote(),2);
setFontSizeAbsolute(getFootnote(),true);
setFontSize(getFootnote(),10);
setLegendTextAutofit(true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setO1LabelAutofit(true);
setPlace(true);
setDisplay(getDataText(),true);
setDataTextRadiusDefault(10);
setZeroValueDataTextDisplay(false);
setStackedDataValueSum(false);
setDisplay(getDataTextStackedTotalOnTop(),true);
setFontName(getDataTextStackedTotalOnTop(),"Arial");
setFontSizeAbsolute(getDataTextStackedTotalOnTop(),true);
setFontSizeInPoints(getDataTextStackedTotalOnTop(),8);
setPlaceResize(getDataText(),1);
setTextRotation(getDataText(),0);
setDataTextPosition(4);
setDisplay(getY1AltFmtFrame(),true);
setLegendPosition(2);
setTextString(getTitle(),"Historical ST Performance Maintenance");
setDisplay(getTitle(),true);
setRiserWidth(85);
setMarkerSizeDefault(20);
setMarkerSizeUnit(800);
setDepthAngle(35);
setDepthRadius(7);
setDisplay(getDataText(4),false);
setTransparentBorderColor(getChartBackground(),true);
setDisplay(getDataText(2),true);
setReverseGroups(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#");
setTextFormatPreset(getDataText(0),0);
setTextFormatPreset(getDataText(1),0);
setTextFormatPreset(getDataText(2),0);
setFillColor(getChartBackground(),new Color(255,196,186));
setTextFormatPreset(getDataText(),7);
setReverseSeries(true);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getDataText(),"#");
setTextFormatPreset(getDataText(),1);
ENDSTYLE
END


-*---------------------------------------------------------------------------------------------
-*THIS ONE BELOW DOES STEAM AND CT FORCED OUTAGES HISTORICALLY - CHART 4



SET ASNAMES = ON


SET GRAPHSERVURL = ' ';



-*
-*INTERNAL_PROPERTIES$SampleData=false;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$GlobalRecordLimit=500;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$FieldDisplayMode=label;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$PrefixDisplayMode=;OBJECTID=GLOBAL
GRAPH FILE GRAPH12
-* Created by Advanced Graph Assistant
SUM
COMPUTE E%/D6.1S=100 * ( GRAPH12.E ) / ( GRAPH12.E + GRAPH12.F + GRAPH12.P ) ; AS ' EMERGENT, %'
COMPUTE F%/D6.1S=100 * ( GRAPH12.F ) / ( GRAPH12.E + GRAPH12.F + GRAPH12.P ) ; AS ' FORCED, %'
COMPUTE P%/D6.1S=100 * ( GRAPH12.P ) / ( GRAPH12.E + GRAPH12.F + GRAPH12.P ) ; AS ' PLANNED, %'
BY GRAPH12.FBKYY AS 'Fiscal Year - Orders Entered'
-*ON TABLE PCHOLD FORMAT PPT TEMPLATE 'graphtemplate' SLIDENUMBER 4
ON GRAPH HOLD AS PERFPFEOEPCT FORMAT GIF
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET HAXIS 770
ON GRAPH SET VAXIS 405
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VBRSTK1
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setMarkerDisplay(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setRiserBorderMode(1);
setSeriesDefaultTransparentBorderColor(true);
setUseSeriesBorderDefaults(true);
setLegendDisplay(true);
setTitleString("Historical CT and ST Performance Maintenance\n");
setTextJustHoriz(getTitle(),1);
setFontSizeAbsolute(getTitle(),true);
setFontSize(getTitle(),16);
setSubtitleString("Open Market History - Planned - Forced - Emergent Outages");
setTextJustHoriz(getSubtitle(),1);
setFontSizeAbsolute(getSubtitle(),true);
setFontSize(getSubtitle(),14);
setFontStyle(getSubtitle(),3);
setFootnoteString("File Name: dash_pfe_oe_graph.fex ");
setTextJustHoriz(getFootnote(),2);
setFontSizeAbsolute(getFootnote(),true);
setFontSize(getFootnote(),10);
setLegendTextAutofit(true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setO1LabelAutofit(true);
setPlace(true);
setDisplay(getDataText(),true);
setDataTextRadiusDefault(10);
setZeroValueDataTextDisplay(false);
setStackedDataValueSum(false);
setFontName(getDataTextStackedTotalOnTop(),"Arial");
setFontSizeAbsolute(getDataTextStackedTotalOnTop(),true);
setFontSizeInPoints(getDataTextStackedTotalOnTop(),8);
setPlaceResize(getDataText(),1);
setTextRotation(getDataText(),0);
setDataTextPosition(4);
setDisplay(getY1AltFmtFrame(),true);
setLegendPosition(2);
setTextString(getTitle(),"Historical CT and ST Performance Maintenance");
setDisplay(getTitle(),true);
setRiserWidth(85);
setMarkerSizeDefault(20);
setMarkerSizeUnit(800);
setDepthAngle(35);
setDepthRadius(7);
setDisplay(getDataText(4),false);
setTransparentBorderColor(getChartBackground(),true);
setDisplay(getDataText(2),true);
setReverseGroups(false);
setFillColor(getChartBackground(),new Color(255,196,186));
setReverseSeries(true);
setDisplay(getDataTextStackedTotalOnTop(),false);
setScaleMaxAuto(getY1Axis(),false);
setScaleMax(getY1Axis(),100.0);
setLogScaleBase(getY1Axis(),10.0);
setScaleMinAuto(getY1Axis(),false);
setScaleMin(getY1Axis(),0.0);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#");
setTextFormatPattern(getDataText(1),"#");
setTextFormatPreset(getDataText(2),2);
setTextFormatPreset(getDataText(1),2);
setTextFormatPreset(getDataText(0),2);
setTextFormatPattern(getDataText(0),"%");
setTextFormatPattern(getDataText(2),"%");
setTextFormatPreset(getDataText(),-1);
setTextFormatPattern(getDataText(),"#.#");
setReverseSeries(true);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getDataText(),"#");
setTextFormatPreset(getDataText(),1);
ENDSTYLE
END
-*---------------------------------------------------------------------------------------------
-*THIS ONE BELOW DOES STEAM AND CT FORCED OUTAGES HISTORICALLY - CHART 5



SET ASNAMES = ON



SET GRAPHSERVURL = ' ';


-*
-*INTERNAL_PROPERTIES$SampleData=false;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$GlobalRecordLimit=500;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$FieldDisplayMode=label;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$PrefixDisplayMode=;OBJECTID=GLOBAL
GRAPH FILE GRAPH12
-* Created by Advanced Graph Assistant
SUM
COMPUTE E%/D6.1S=100 * ( GRAPH12.CPME ) / ( GRAPH12.CPME + GRAPH12.CPMF + GRAPH12.CPMP ) ; AS ' EMERGENT, %'
COMPUTE F%/D6.1S=100 * ( GRAPH12.CPMF) / ( GRAPH12.CPME + GRAPH12.CPMF + GRAPH12.CPMP ) ; AS ' FORCED, %'
COMPUTE P%/D6.1S=100 * ( GRAPH12.CPMP ) / ( GRAPH12.CPME + GRAPH12.CPMF + GRAPH12.CPMP ) ; AS ' PLANNED, %'
BY GRAPH12.FBKYY AS 'Fiscal Year - Orders Entered'
-*IF MORG EQ 'O16S' OR 'O16R' OR 'O15'
-*ON TABLE PCHOLD FORMAT PPT TEMPLATE 'graphtemplate' SLIDENUMBER 5
ON GRAPH HOLD AS CTPFEOEPCT FORMAT GIF
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET HAXIS 770
ON GRAPH SET VAXIS 405
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VBRSTK1
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setMarkerDisplay(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setRiserBorderMode(1);
setSeriesDefaultTransparentBorderColor(true);
setUseSeriesBorderDefaults(true);
setLegendDisplay(true);
setTitleString("Historical CT Performance Maintenance\n");
setTextJustHoriz(getTitle(),1);
setFontSizeAbsolute(getTitle(),true);
setFontSize(getTitle(),16);
setSubtitleString("Open Market History - Planned - Forced - Emergent Outages");
setTextJustHoriz(getSubtitle(),1);
setFontSizeAbsolute(getSubtitle(),true);
setFontSize(getSubtitle(),14);
setFontStyle(getSubtitle(),3);
setFootnoteString("File Name: dash_pfe_oe_graph.fex ");
setTextJustHoriz(getFootnote(),2);
setFontSizeAbsolute(getFootnote(),true);
setFontSize(getFootnote(),10);
setLegendTextAutofit(true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setO1LabelAutofit(true);
setPlace(true);
setDisplay(getDataText(),true);
setDataTextRadiusDefault(10);
setZeroValueDataTextDisplay(false);
setStackedDataValueSum(false);
setFontName(getDataTextStackedTotalOnTop(),"Arial");
setFontSizeAbsolute(getDataTextStackedTotalOnTop(),true);
setFontSizeInPoints(getDataTextStackedTotalOnTop(),8);
setPlaceResize(getDataText(),1);
setTextRotation(getDataText(),0);
setDataTextPosition(4);
setDisplay(getY1AltFmtFrame(),true);
setLegendPosition(2);
setTextString(getTitle(),"Historical CT Performance Maintenance");
setDisplay(getTitle(),true);
setRiserWidth(85);
setMarkerSizeDefault(20);
setMarkerSizeUnit(800);
setDepthAngle(35);
setDepthRadius(7);
setDisplay(getDataText(4),false);
setTransparentBorderColor(getChartBackground(),true);
setDisplay(getDataText(2),true);
setReverseGroups(false);
setFillColor(getChartBackground(),new Color(255,196,186));
setReverseSeries(true);
setDisplay(getDataTextStackedTotalOnTop(),false);
setScaleMaxAuto(getY1Axis(),false);
setScaleMax(getY1Axis(),100.0);
setLogScaleBase(getY1Axis(),10.0);
setScaleMinAuto(getY1Axis(),false);
setScaleMin(getY1Axis(),0.0);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#");
setTextFormatPattern(getDataText(1),"#");
setTextFormatPreset(getDataText(2),2);
setTextFormatPreset(getDataText(1),2);
setTextFormatPreset(getDataText(0),2);
setTextFormatPattern(getDataText(0),"%");
setTextFormatPattern(getDataText(2),"%");
setTextFormatPreset(getDataText(),-1);
setTextFormatPattern(getDataText(),"#.#");
setReverseSeries(true);
ENDSTYLE
END
-*---------------------------------------------------------------------------------------------
-*THIS ONE BELOW DOES STEAM AND CT FORCED OUTAGES HISTORICALLY - CHART 6


SET ASNAMES = ON


SET GRAPHSERVURL = ' ';



-*
-*INTERNAL_PROPERTIES$SampleData=false;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$GlobalRecordLimit=500;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$FieldDisplayMode=label;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$PrefixDisplayMode=;OBJECTID=GLOBAL
GRAPH FILE GRAPH12
-* Created by Advanced Graph Assistant
SUM
COMPUTE E%/D6.1S=100 * ( GRAPH12.SPME ) / ( GRAPH12.SPME + GRAPH12.SPMF + GRAPH12.SPMP ) ; AS ' EMERGENT, %'
COMPUTE F%/D6.1S=100 * ( GRAPH12.SPMF) / ( GRAPH12.SPME + GRAPH12.SPMF + GRAPH12.SPMP ) ; AS ' FORCED, %'
COMPUTE P%/D6.1S=100 * ( GRAPH12.SPMP ) / ( GRAPH12.SPME + GRAPH12.SPMF + GRAPH12.SPMP ) ; AS ' PLANNED, %'
BY GRAPH12.FBKYY AS 'Fiscal Year - Orders Entered'
-*IF MORG EQ 'O251' OR 'O254' OR 'O253'
-*ON TABLE PCHOLD FORMAT PPT TEMPLATE 'graphtemplate' SLIDENUMBER 6
ON GRAPH HOLD AS STPFEOEPCT FORMAT GIF
-*ON TABLE SET COMPOUND CLOSE
ON TABLE SET HTMLCSS ON
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET HAXIS 770
ON GRAPH SET VAXIS 405
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VBRSTK1
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setMarkerDisplay(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setRiserBorderMode(1);
setSeriesDefaultTransparentBorderColor(true);
setUseSeriesBorderDefaults(true);
setLegendDisplay(true);
setTitleString("Historical ST Performance Maintenance\n");
setTextJustHoriz(getTitle(),1);
setFontSizeAbsolute(getTitle(),true);
setFontSize(getTitle(),16);
setSubtitleString("By Profit Center - Open Market Only - Planned - Forced - Emergent Outages");
setTextJustHoriz(getSubtitle(),1);
setFontSizeAbsolute(getSubtitle(),true);
setFontSize(getSubtitle(),14);
setFontStyle(getSubtitle(),3);
setFootnoteString("File Name: dash_pfe_oe_graph.fex ");
setTextJustHoriz(getFootnote(),2);
setFontSizeAbsolute(getFootnote(),true);
setFontSize(getFootnote(),10);
setLegendTextAutofit(true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setO1LabelAutofit(true);
setPlace(true);
setDisplay(getDataText(),true);
setDataTextRadiusDefault(10);
setZeroValueDataTextDisplay(false);
setStackedDataValueSum(false);
setFontName(getDataTextStackedTotalOnTop(),"Arial");
setFontSizeAbsolute(getDataTextStackedTotalOnTop(),true);
setFontSizeInPoints(getDataTextStackedTotalOnTop(),8);
setPlaceResize(getDataText(),1);
setTextRotation(getDataText(),0);
setDataTextPosition(4);
setDisplay(getY1AltFmtFrame(),true);
setLegendPosition(2);
setTextString(getTitle(),"Historical ST Performance Maintenance");
setDisplay(getTitle(),true);
setRiserWidth(85);
setMarkerSizeDefault(20);
setMarkerSizeUnit(800);
setDepthAngle(35);
setDepthRadius(7);
setDisplay(getDataText(4),false);
setTransparentBorderColor(getChartBackground(),true);
setDisplay(getDataText(2),true);
setReverseGroups(false);
setFillColor(getChartBackground(),new Color(255,196,186));
setReverseSeries(true);
setDisplay(getDataTextStackedTotalOnTop(),false);
setScaleMaxAuto(getY1Axis(),false);
setScaleMax(getY1Axis(),100.0);
setLogScaleBase(getY1Axis(),10.0);
setScaleMinAuto(getY1Axis(),false);
setScaleMin(getY1Axis(),0.0);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#");
setTextFormatPattern(getDataText(1),"#");
setTextFormatPreset(getDataText(2),2);
setTextFormatPreset(getDataText(1),2);
setTextFormatPreset(getDataText(0),2);
setTextFormatPattern(getDataText(0),"%");
setTextFormatPattern(getDataText(2),"%");
setTextFormatPreset(getDataText(),-1);
setTextFormatPattern(getDataText(),"#.#");
setReverseSeries(true);
ENDSTYLE
END
-*******************************************************************
SET COMPOUND='OPEN'
TABLE FILE GRAPH12
SUM
E NOPRINT
BY FBKYY NOPRINT
WHERE RECORDLIMIT EQ 1
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PPT TEMPLATE 'pfegraphtemplate' SLIDENUMBER 1
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
$
TYPE=REPORT,
IMAGE=PERFPFEOE.GIF,
POSITION=(0.527778 1.694444),
SIZE=(9.083333 5.152778),
$
ENDSTYLE
END
-********************************************************************
SET COMPOUND='BREAK'
TABLE FILE GRAPH12
SUM
E NOPRINT
BY FBKYY NOPRINT
WHERE RECORDLIMIT EQ 1
ON TABLE PCHOLD FORMAT PPT TEMPLATE 'pfegraphtemplate' SLIDENUMBER 1
ON TABLE SET STYLE *
TYPE=REPORT,
IMAGE=CTPFEOE.GIF,
POSITION=(0.527778 1.694444),
SIZE=(9.083333 5.152778),
$
ENDSTYLE
END
-**********************************************************************
SET COMPOUND='BREAK'
TABLE FILE GRAPH12
SUM
E NOPRINT
BY FBKYY NOPRINT
WHERE RECORDLIMIT EQ 1
ON TABLE PCHOLD FORMAT PPT TEMPLATE 'pfegraphtemplate' SLIDENUMBER 1
ON TABLE SET STYLE *
TYPE=REPORT,
IMAGE=STPFEOE.GIF,
POSITION=(0.527778 1.694444),
SIZE=(9.083333 5.152778),
$
ENDSTYLE
END
-***********************************************************************
SET COMPOUND='BREAK'
TABLE FILE GRAPH12
SUM
E NOPRINT
BY FBKYY NOPRINT
WHERE RECORDLIMIT EQ 1
ON TABLE PCHOLD FORMAT PPT TEMPLATE 'pfegraphtemplate' SLIDENUMBER 1
ON TABLE SET STYLE *
TYPE=REPORT,
IMAGE=PERFPFEOEPCT.GIF,
POSITION=(0.527778 1.694444),
SIZE=(9.083333 5.152778),
$
ENDSTYLE
END
-*************************************************************************
SET COMPOUND='BREAK'
TABLE FILE GRAPH12
SUM
E NOPRINT
BY FBKYY NOPRINT
WHERE RECORDLIMIT EQ 1
ON TABLE PCHOLD FORMAT PPT TEMPLATE 'pfegraphtemplate' SLIDENUMBER 1
ON TABLE SET STYLE *
TYPE=REPORT,
IMAGE=CTPFEOEPCT.GIF,
POSITION=(0.527778 1.694444),
SIZE=(9.083333 5.152778),
$
ENDSTYLE
END
-************************************************************************
SET COMPOUND='NOBREAK'
TABLE FILE GRAPH12
SUM
E NOPRINT
BY FBKYY NOPRINT
WHERE RECORDLIMIT EQ 1
ON TABLE PCHOLD FORMAT PPT TEMPLATE 'pfegraphtemplate' SLIDENUMBER 1
ON TABLE SET COMPOUND CLOSE
ON TABLE SET STYLE *
TYPE=REPORT,
IMAGE=STPFEOEPCT.GIF,
POSITION=(0.527778 1.694444),
SIZE=(9.083333 5.152778),
$
ENDSTYLE
END


Can anyone help me on why maybe how to create a template?

thanks alot

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


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 2 | Registered: April 27, 2011Report This Post
Expert
posted Hide Post
Hi Colleen,

Please open a case with Customer Support Services so that we have someone dedicated to look into the files for you. Please call 1-800-736-6130, or access online at InfoResponse.

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
 
Posts: 1948 | Location: New York | Registered: November 16, 2004Report This Post
Virtuoso
posted Hide Post
You may have an issue with your template, too, but I don't see a CLOSE for your compound report. I believe that last SET COMPOUND statement should be SET COMPOUND=CLOSE. I also haven't seen single quotes used in the SET COMPOUND statement before. You might try removing them.


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Report 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] Power Point Templates

Copyright © 1996-2020 Information Builders