詳細:
-*NoTrace
SET GRAPHENGINE=GRAPH53
-INCLUDE mrheader
-* mr header include start
-* mr as NOT html
-SET &FOCEXURL=/ibi_apps/rs?IBIF_webapp=/ibi_apps&IBIC_server=EDASERVE&IBIAPP_app=uriage& | 'IBIMR_drill=IBFS,RUNFEX,IBIF_ex,true' | '&';
SET FOCEXURL='/ibi_apps/rs?IBIF_webapp=/ibi_apps&IBIC_server=EDASERVE&IBIAPP_app=uriage&IBIMR_drill=IBFS,RUNFEX,IBIF_ex,true&'
-* mr header include end
-*
SET HTMLEMBEDIMG=ON
-INCLUDE 地域別分類利益比率
ENGINE INT CACHE SET ON
SET PAGE-NUM=NOLEAD
SET HTMLENCODE=OFF
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 uriage/受注ビュー
-* Created by Info Assist for Graph
SUM 受注ビュー.受注明細.PROFIT_AMOUNT
BY 受注ビュー.REGION.REGION
BY 受注ビュー.MAJOR_CLASS_NAME.MAJOR_CLASS_NAME
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET UNITS PIXELS
ON GRAPH SET HAXIS 770.0
ON GRAPH SET VAXIS 405.0
ON GRAPH SET LOOKGRAPH PIE
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_JS
"injectedRevision" : "$Revision: 1.2 $",
"dataSetLimits": {"enabled": true},
"catchErrors" : true
*END
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setCurveFitEquationDisplay(false);
setPlace(true);
setPieFeelerTextDisplay(1);
*END
-INCLUDE __c/Warm
$ Copyright (c) 1996-2021 TIBCO Software Inc. All Rights Reserved.
-* $Revision: 1.33 $
*TABLE_STYLE
TYPE=REPORT,
GRID=OFF,
FONT='IBIDefault',
SIZE=9,
STYLE=NORMAL,
SQUEEZE=ON,
COLOR=RGB(20 20 20),
PAGECOLOR='WHITE',
BORDER-COLOR=RGB(219 219 219),
TITLELINE=SKIP,
HYPERLINK-COLOR=RGB(51 102 255),
$
TYPE=REPORT,GRAPHCOLOR='SILVER',GRAPHCOLORNEG='RED',GRAPHWIDTH=.18,$
TYPE=REPORT,
OBJECT=MENU,
SIZE=9,
COLOR=RGB(#6B6B6B),
BACKCOLOR=RGB(#F8F8F8),
HOVER-COLOR=RGB(#495263),
HOVER-BACKCOLOR=RGB(#DFDFDF),
$
TYPE=DATA,
TOPGAP=0.05,
BOTTOMGAP=0.05,
BORDER-TOP=LIGHT,
BORDER-TOP-COLOR=RGB(219 219 219),
BORDER-BOTTOM=LIGHT,
BORDER-BOTTOM-COLOR=RGB(219 219 219),
$
TYPE=TITLE,
STYLE=-UNDERLINE + BOLD,
BORDER-BOTTOM=LIGHT,
BORDER-BOTTOM-COLOR=RGB(219 219 219),
$
TYPE=DATA,
COLUMN=ROWTOTAL(*),
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=ROWTOTAL(*),
STYLE=-UNDERLINE +BOLD,
$
TYPE=TABHEADING,
SIZE=14,
JUSTIFY=LEFT,
STYLE=BOLD,
COLOR=RGB(75 75 75),
$
TYPE=TABFOOTING,
SIZE=10,
COLOR=RGB(75 75 75),
$
TYPE=HEADING,
JUSTIFY=LEFT,
SIZE=12,
STYLE=BOLD,
COLOR=RGB(75 75 75),
$
TYPE=FOOTING,
SIZE=10,
COLOR=RGB(75 75 75),
$
TYPE=SUBHEAD,
BACKCOLOR=RGB(246 246 246),
BORDER-TOP=LIGHT,
BORDER-TOP-COLOR=RGB(219 219 219),
$
TYPE=SUBHEAD,
BY=1,
BORDER-TOP=LIGHT,
BORDER-TOP-COLOR=RGB(102 102 102),
$
TYPE=SUBHEAD,
OBJECT=FIELD,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=9,
BORDER-TOP=LIGHT,
BORDER-TOP-COLOR=RGB(219 219 219),
$
TYPE=SUBFOOT,
OBJECT=FIELD,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
STYLE=BOLD,
BORDER-TOP=LIGHT,
BORDER-TOP-COLOR=RGB(219 219 219),
$
TYPE=ACROSSVALUE,
BACKCOLOR='NONE',
STYLE=NORMAL,
JUSTIFY=CENTER,
$
TYPE=ACROSSTITLE,
ACROSSTITLE=SIDE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
STYLE=BOLD,
BORDER-TOP=LIGHT,
BORDER-TOP-COLOR=RGB(102 102 102),
$
-*ACTIVE Specific
TYPE=REPORT,OBJECT=CURRENT-ROW,HOVER-BACKCOLOR=rgb(243 243 243), BACKCOLOR=rgb(215 215 215),$
TYPE=REPORT, CALC-LOCATION=TOP, $
TYPE=REPORT, ARICONSET=BLUE, ARSTYLESET=bipib,$
TYPE=REPORT, OBJECT=CALC-AREA, COLOR=RGB(0 0 0), $
TYPE=REPORT, OBJECT=STATUS-AREA, COLOR=RGB(51 51 51), BACKCOLOR=RGB(255 255 255), JUSTIFY=LEFT, PAGE-LOCATION=BOTTOM,$
TYPE=REPORT,ARGRAPHENGINE=JSCHART,$
*GRAPH_SCRIPT
setFillColor(getSeries(0),new Color(#5388be));
setFillColor(getSeries(1),new Color(#9ed675));
setFillColor(getSeries(2),new Color(#4fa03d));
setFillColor(getSeries(3),new Color(#fcce58));
setFillColor(getSeries(4),new Color(#e1542b));
setFillColor(getSeries(5),new Color(#efcca2));
setSeriesLooping(6);
setColorMode(4);
setAutoColorLerpFactor(0.8);
setTransparentBorderColor(getChartBackground(),true);
setTransparentBorderColor(getSeries(*), true);
setTransparentBorderColor(getFrame(),true);
setTransparentBorderColor(getSeries(0),true);
setTransparentBorderColor(getSeries(1),true);
setTransparentBorderColor(getSeries(2),true);
setTransparentBorderColor(getSeries(3),true);
setTransparentBorderColor(getSeries(4),true);
setTransparentBorderColor(getSeries(5),true);
setTransparentBorderColor(getSeries(6),true);
setTransparentBorderColor(getSeries(7),true);
setTransparentBorderColor(getSeries(8),true);
setTransparentBorderColor(getSeries(9),true);
setTransparentBorderColor(getSeries(10),true);
setTransparentBorderColor(getSeries(11),true);
setTransparentBorderColor(getSeries(12),true);
setTransparentBorderColor(getSeries(13),true);
setTransparentBorderColor(getSeries(14),true);
setTransparentBorderColor(getSeries(15),true);
setTransparentBorderColor(getSeries(16),true);
setTransparentBorderColor(getSeries(17),true);
setX1MajorTickDisplay (true);
setTickLength (getX1MajorTick(), 200);
setBorderColor(getX1MajorTick(),new Color(192,192,192));
setTickStyle(getX1MajorTick(),3);
setLegendPosition(2);
setSmoothLines(false);
setFillColor(getO1Label(),new Color(128,128,128));
setDisplay(getO1MajorGrid(),false);
setBorderColor(getO1MajorGrid(),new Color(128,128,128));
setFillColor(getO1MajorGrid(),new Color(128,128,128));
setAltFmtFrameNumColors(getO1AltFmtFrame(),5);
setFontName(getO1Title(),"IBIDefault");
setFontSizeAbsolute(getO1Title(), true);
setFontSizeInPoints(getO1Title(), 10);
setPlaceResize(getO1Title(), 0);
setFillColor(getO1Title(),new Color(128,128,128));
setTickLength (getY1MajorTick(), 200);
setBorderColor(getY1AxisLine(),new Color(192,192,192));
setFillColor(getY1AxisLine(),new Color(192,192,192));
setLineWidth(getY1AxisLine(),1);
setDisplay(getY1ZeroLine(),true);
setBorderColor(getY1ZeroLine(),new Color(192,192,192));
setLineWidth(getY1ZeroLine(),1);
setFillColor(getY1Label(),new Color(128,128,128));
setBorderColor(getY1MajorGrid(),new Color(128,128,128));
setFillColor(getY1MajorGrid(),new Color(128,128,128));
setAltFmtFrameNumColors(getY1AltFmtFrame(),5);
setScaleMustIncludeZero(getY1Axis(),true);
setFontSizeAbsolute(getY1Title(), true);
setFontSizeInPoints(getY1Title(), 10);
setPlaceResize(getY1Title(), 0);
setFillColor(getY1Title(),new Color(128,128,128));
setFontName(getY1Title(),"IBIDefault");
setFontName(getY1Label(),"IBIDefault");
setFontSizeAbsolute(getY1Label(), true);
setFontSizeInPoints(getY1Label(), 9);
setPlaceResize(getY1Label(), 0);
setBorderColor(getY1MajorTick(),new Color(192,192,192));
setDisplay(getY1MajorTick(),true);
setTickStyle(getY1MajorTick(),3);
setDisplay(getY1MajorGrid(),false);
setFontName(getX1Title(),"IBIDefault");
setFontSizeAbsolute(getX1Title(), true);
setFontSizeInPoints(getX1Title(), 10);
setPlaceResize(getX1Title(), 0);
setFillColor(getX1Title(),new Color(128,128,128));
setTickLength (getY2MajorTick(), 200);
setBorderColor(getY2AxisLine(),new Color(88,88,88));
setFillColor(getY2AxisLine(),new Color(88,88,88));
setLineWidth(getY2AxisLine(),1);
setDisplay(getY2ZeroLine(),true);
setBorderColor(getY2ZeroLine(),new Color(88,88,88));
setLineWidth(getY2ZeroLine(),1);
setFillColor(getY2Label(),new Color(64,64,64));
setBorderColor(getY2MajorGrid(),new Color(64,64,64));
setFillColor(getY2MajorGrid(),new Color(64,64,64));
setAltFmtFrameNumColors(getY2AltFmtFrame(),5);
setScaleMustIncludeZero(getY2Axis(),true);
setFontSizeAbsolute(getY2Title(), true);
setFontSizeInPoints(getY2Title(), 10);
setPlaceResize(getY2Title(), 0);
setFillColor(getY2Title(),new Color(64,64,64));
setFontName(getY2Title(),"IBIDefault");
setFontName(getY2Label(),"IBIDefault");
setFontSizeAbsolute(getY2Label(), true);
setFontSizeInPoints(getY2Label(), 9);
setPlaceResize(getY2Label(), 0);
setBorderColor(getY2MajorTick(),new Color(88,88,88));
setDisplay(getY2MajorTick(),true);
setTickStyle(getY2MajorTick(),3);
setDisplay(getY2MajorGrid(),false);
setFontName(getX1Title(),"IBIDefault");
setFontSizeAbsolute(getX1Title(), true);
setFontSizeInPoints(getX1Title(), 10);
setPlaceResize(getX1Title(), 0);
setFillColor(getX1Title(),new Color(128,128,128));
setFontName(getO1Label(),"IBIDefault");
setFontSizeAbsolute(getO1Label(), true);
setFontSizeInPoints(getO1Label(), 9);
setPlaceResize(getO1Label(), 0);
setFontName(getLegendText(),"IBIDefault");
setFillColor(getLegendText(),new Color(80,80,80));
setSquareMarkers(true);
setUseSeriesShapes(true);
setMarkerShape(getSeries(*),0);
setPieFeelerTextDisplay(0);
setFontName(getPieRingLabel(),"IBIDefault");
setFontSizeAbsolute(getPieRingLabel(),true);
setAutofit(getPieRingLabel(),false);
setFontSizeInPoints(getPieRingLabel(),28);
setPlaceResize(getPieRingLabel(),0);
setDisplay(getX1MajorGrid(),false);
setBorderColor(getO1AxisLine(),new Color(192,192,192));
setLineWidth(getO1AxisLine(),1);
setBorderColor(getX1AxisLine(),new Color(192,192,192));
setLineWidth(getX1AxisLine(),1);
setScaleMustIncludeZero(getX1Axis(),true);
setBorderColor(getO1MajorTick(),new Color(192,192,192));
setDisplay(getO1MajorTick(),false);
setTickStyle(getO1MajorTick(),3);
setTransparentFillColor(getFrame(),true);
setPieRingSize(64);
setDisplay(getQuadrantLine(),false);
setFillColor(getX1Label(),new Color(128,128,128));
setFontName(getX1Label(),"IBIDefault");
setFontSizeAbsolute(getX1Label(), true);
setFontSizeInPoints(getX1Label(), 9);
setPlaceResize(getX1Label(), 0);
setPlaceTruncateCount(getLegendText(), 15);
setZeroValueDataTextDisplay(false);
*GRAPH_JS
"fill": {
"color": "transparent"
},
"border": {
"width": 1,
"color": "transparent",
"dash": ""
},
"blaProperties": {
"areaFillEffect": "70%",
"barGroupGapWidth": "0.4"
},
"bubbleMarker": {
"maxSize": "11%"
},
"pieProperties": {
"holeSize": 0,
"totalLabel": {
"visible": "auto",
"font": "10pt Sans-Serif",
"color": "#505050"
}
},
"gaugeProperties": {
"totalLabel": {
"color": "#505050"
},
"secondaryRingFillColor": "#e5e5e5",
"startAngle": 270,
"endAngle": 270,
"axisWidth": "25%",
"outerBorder": {
"fill": {
"color": "transparent"
},
"width": "6%"
}
},
"series": [
{
"series": "all",
"dataLabels": {
"visible": "auto",
"font": "7.5pt Sans-Serif",
"color": "auto"
},
"color": null,
"border": {
"width": 3
},
"marker": {
"visible": false,
"size": 10,
"border": {
"width": 2
},
"shape": "circle",
"fillEffect": "seriesAuto"
}
},
{
"series": 0,
"color": "#5388be"
},
{
"series": 1,
"color": "#9ed675"
},
{
"series": 2,
"color": "#4fa03d"
},
{
"series": 3,
"color": "#FCCE58"
},
{
"series": 4,
"color": "#e1542b"
},
{
"series": 5,
"color": "#efcca2"
}
],
"legend": {
"visible": "auto",
"lineStyle": {
"width": 1,
"color": "transparent"
},
"title": {
"visible": false,
"font": "10pt Sans-Serif",
"color": "#505050"
},
"labels": {
"font": "7.5pt Sans-Serif",
"color": "#505050"
},
"shadow": false,
"position": "auto",
"backgroundcolor": "transparent",
"scroll": {
"enabled": true,
"handle": {
"color": "#D1D1D1",
"hoverColor": "#B3B3B3"
}
},
"dock": {
"enabled": true,
"button": {
"color": "#D1D1D1",
"hoverColor": "#B3B3B3"
}
}
},
"colorScale": {
"title": {
"text": "",
"visible": true
},
"colors": [
"#D73027",
"#FDAE61",
"#FFFFBF",
"#A6D96A",
"#1A9850"
],
"labels": {
"visible": true,
"font": "7.5pt Sans-Serif",
"color": "#505050"
},
"majorGrid": {
"visible": true,
"aboveRisers": true,
"lineStyle": {
"width": 1,
"color": "rgba(255, 255, 255, 0.3)"
},
"ticks": {
"length": 5,
"visible": false,
"style": "outer",
"lineStyle": {
"width": 1,
"color": "#BABABA"
}
}
}
},
"xaxis": {
"mustIncludeZero": true,
"title": {
"visible": true,
"font": "10pt Sans-Serif",
"color": "#505050"
},
"labels": {
"visible": true,
"font": "9pt Sans-Serif",
"color": "#505050",
"excludeMin": false,
"nestingConcatSymbol": " : ",
"rotation": null
},
"labelLayout": {
"stagger": false,
"skip": "auto",
"scroll": "auto",
"truncate": "auto"
},
"bodyLineStyle": {
"width": 1,
"color": "#BABABA",
"dash": ""
},
"baseLineStyle": {
"width": 1,
"color": "#BABABA",
"dash": ""
},
"majorGrid": {
"visible": false,
"aboveRisers": false,
"lineStyle": {
"width": 1,
"color": "#EEEEEE",
"dash": ""
},
"ticks": {
"length": 5,
"visible": false,
"style": "inner",
"lineStyle": {
"width": 1,
"color": "#BABABA"
}
}
},
"minorGrid": {
"visible": false,
"count": null,
"lineStyle": {
"width": 1,
"color": "#EEEEEE",
"dash": ""
},
"ticks": {
"length": 5,
"visible": false,
"style": "inner",
"lineStyle": {
"width": 1,
"color": "#BABABA"
}
}
}
},
"yaxis": {
"mustIncludeZero": true,
"title": {
"visible": true,
"font": "10pt Sans-Serif",
"color": "#505050"
},
"labels": {
"visible": true,
"font": "9pt Sans-Serif",
"color": "#505050",
"excludeMin": false,
"rotation": null
},
"bodyLineStyle": {
"width": 1,
"color": "#BABABA",
"dash": ""
},
"baseLineStyle": {
"width": 1,
"color": "#BABABA",
"dash": ""
},
"minorGrid": {
"visible": false,
"count": null,
"lineStyle": {
"width": 1,
"color": "#EEEEEE",
"dash": ""
},
"ticks": {
"length": 5,
"style": "outer",
"visible": false,
"lineStyle": {
"width": 1,
"color": "#BABABA"
}
}
},
"majorGrid": {
"visible": false,
"aboveRisers": false,
"lineStyle": {
"width": 1,
"color": "#EEEEEE",
"dash": ""
},
"ticks": {
"length": 5,
"visible": true,
"style": "outer",
"lineStyle": {
"width": 1,
"color": "#BABABA"
}
}
}
},
"y2axis": {
"mustIncludeZero": true,
"title": {
"visible": true,
"font": "10pt Sans-Serif",
"color": "#505050"
},
"labels": {
"visible": true,
"font": "9pt Sans-Serif",
"color": "#505050",
"excludeMin": false,
"rotation": null
},
"bodyLineStyle": {
"width": 1,
"color": "#BABABA",
"dash": ""
},
"baseLineStyle": {
"width": 1,
"color": "#BABABA",
"dash": ""
},
"minorGrid": {
"visible": false,
"count": null,
"lineStyle": {
"width": 1,
"color": "#EEEEEE",
"dash": ""
},
"ticks": {
"length": 5,
"style": "outer",
"visible": false,
"lineStyle": {
"width": 1,
"color": "#BABABA"
}
}
},
"majorGrid": {
"visible": false,
"aboveRisers": false,
"lineStyle": {
"width": 1,
"color": "#EEEEEE",
"dash": ""
},
"ticks": {
"length": 5,
"visible": true,
"style": "outer",
"lineStyle": {
"width": 1,
"color": "#BABABA"
}
}
}
},
"zaxis": {
"title": {
"text": "",
"visible": true,
"font": "10pt Sans-Serif",
"color": "#505050"
},
"labels": {
"visible": true,
"font": "9pt Sans-Serif",
"color": "#505050",
"excludeMin": false,
"excludeMax": "auto",
"rotation": null
},
"majorGrid": {
"visible": false,
"ticks": {
"visible": false
}
}
},
"mouseOverIndicator": {
"color": "transparent",
"border": {
"width": 2,
"color": "#303030"
},
"marker": {
"color": "rgba(255, 255, 0, 0.88)",
"size": 8,
"shape": "circle",
"rotation": 0,
"position": "top",
"border": {
"width": 0,
"color": "rgba(26, 26, 26, 0.9)",
"dash": ""
}
}
},
"matrixProperties": {
"rowLabels": {
"color": "#505050",
"font": "8pt Sans-Serif"
},
"colLabels": {
"color": "#505050",
"font": "8pt Sans-Serif"
},
"rowHeader": {
"color": "#505050",
"font": "10pt Sans-Serif"
},
"colHeader": {
"color": "#505050",
"font": "10pt Sans-Serif"
},
"cellBorder": {
"width": 1,
"color": "#AAAAAA"
}
},
"dataSelection": {
"unselectedColor": "85%",
"selectionRect": {
"fill": "rgba(120, 120, 180, 0.45)",
"border": {
"width": 1,
"color": "rgba(120, 120, 205, 0.8)"
}
}
},
"tagcloudProperties": {
"engine": "new",
"font": "14pt Sans-serif"
},
"morphAnimation": {
"duration": 1000
},
"dataGridProperties": {
"colHeader": {
"sorting": {
"enabled": true
},
"resize": {
"enabled": true
}
}
},
"riserCycleEndLightness": 0.8,
"riserBevel": "none",
"showNullGroups": false,
"narrativeText": {
"label": {
"font": "11pt Arial",
"color": "#000000",
"align": "left"
},
"backgroundColor": "#FFFFFF",
"border": {
"width": 0,
"color": "#000000",
"dash": ""
}
},
"extensions": {
"com.esri.map": {
"baseLayer": {
"basemap": "gray"
}
}
}
*END
TYPE=REPORT, TITLETEXT='地域別分類利益比率', $
TYPE=DATA, COLUMN=N1, BUCKET=column, $
TYPE=DATA, COLUMN=N2, BUCKET=color, $
TYPE=DATA, COLUMN=N3, BUCKET=measure, $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
*GRAPH_JS_FINAL
"pieProperties": {
"holeSize": "65%"
},
"agnosticSettings": {
"chartTypeFullName": "Pie_Ring"
}
*END
ENDSTYLE
END
-RUN
(FOC1261) 物理インターフェースがありません。SUFFIX SQLHYPG, モジュール名:JDBHYPG
(FOC1262) ネイティブエラーメッセージ:
(FOC1260) /home/webfocus/ibi/srv90/home/bin/libjdbhypg.so: cannot open shared object file: No such file or directory
(FOC1263) SUFFIX SQLHYPG の現行環境変数 :
(FOC1260) CLASSPATH : NOT SET
(FOC1260) PATH : /home/webfocus/ibi/srv90/home/bin
(FOC1260) /home/webfocus/ibi/srv90/home/etc/python/bin
(FOC1260) /home/webfocus/ibi/java/jdk8u322-b06/bin/
(FOC1260) /home/webfocus/ibi/java/jdk8u322-b06
(FOC1260) /home/webfocus/bin
(FOC1260) /usr/bin
(FOC1260) /bin
(FOC1260) /home/webfocus/.local/bin ---- NOT FOUND
(FOC1260) /home/webfocus/bin
(FOC1260) LD_LIBRARY_PATH : /home/webfocus/ibi/srv90/home/etc/python/lib
(FOC1260) /home/webfocus/ibi/java/jdk8u322-b06/jre/lib/amd64/server
(FOC1260) /home/webfocus/ibi/srv90/home/bin
(FOC1260) /lib
(FOC1260) /usr/lib
(FOC1400) SQLコード : -1 (HEX: FFFFFFFF)
(FOC1488) SQL インターフェースがインストールされていません
(FOC1500) : Physical interface not found for SUFFIX=SQLHYPG . Module name: JDBHYPG
(FOC1479) SQL データベースへの接続エラー