詳細:
-*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 SQUEEZE=ON
SET HTMLENCODE=ON
SET HTMLCSS=ON
SET EMPTYREPORT=ON
-DEFAULTH &WF_SUMMARY='Summary';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
TABLE FILE uriage/受注ビュー
SUM 受注ビュー.受注明細.SALES_AMOUNT
受注ビュー.受注明細.PROFIT_AMOUNT
受注ビュー.受注明細.COST
COMPUTE 受注ビュー.受注明細.利益率;
BY 受注ビュー.時間軸.ORDER_YEAR_YYYY
BY 受注ビュー.MAJOR_CLASS_NAME.MAJOR_CLASS_NAME
ON TABLE PCHOLD FORMAT AHTML
ON TABLE NOTOTAL
ON TABLE SET CACHELINES 100
ON TABLE SET GRWIDTH 1
ON TABLE SET AUTOFIT OFF
ON TABLE SET STYLE *
-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='分類別集計表', SUMMARY='Summary', HFREEZE=OFF, LINES-PER-PAGE=30, ARGRAPHENGINE=JSCHART, $
TYPE=DATA, COLUMN=N6, GRAPHTYPE=DATA, $
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 データベースへの接続エラー