詳細:
-*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 COMPUTE 受注ビュー.受注明細.利益率;
BY 受注ビュー.REGION.REGION NOPRINT
WHERE 受注ビュー.時間軸.ORDER_YEAR_YYYY EQ 2013;
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET GRWIDTH 1
ON GRAPH SET AUTOFIT ON
ON GRAPH SET UNITS PIXELS
ON GRAPH SET HAXIS 770.0
ON GRAPH SET VAXIS 405.0
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 1
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 0
ON GRAPH SET LOOKGRAPH GAUGE1
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_JS
"injectedRevision" : "$Revision: 1.2 $",
"dataSetLimits": {"enabled": true},
"catchErrors" : true
*END
*GRAPH_SCRIPT
setPlace(true);
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setCurveFitEquationDisplay(false);
*END
-INCLUDE __c/ashisuto_template_ia_multi
*TABLE_STYLE
WRAP=OFF,
$
TYPE=REPORT,
TOPGAP=0.08,
RIGHTGAP=0.15,
BOTTOMGAP=0.08,
LEFTGAP=0.15,
FONT='MEIRYO',
SIZE=9,
COLOR=RGB(80 80 80),
BORDER-COLOR=RGB(236 236 236),
STYLE=NORMAL,
$
TYPE=TITLE,
STYLE=BOLD,
BORDER=1,
BORDER-BOTTOM=1,
BORDER-RIGHT=0,
BORDER-LEFT=0,
BACKCOLOR=RGB(250 250 250),
$
TYPE=DATA,
BORDER=1,
BORDER-BOTTOM=1,
BORDER-RIGHT=0,
BORDER-LEFT=0,
-*BACKCOLOR=(RGB(255 255 255) RGB(250 250 250)),
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
BORDER=1,
BORDER-BOTTOM=1,
BORDER-RIGHT=0,
BORDER-LEFT=0,
BACKCOLOR=RGB(250 250 250),
$
TYPE=ACROSSVALUE,
BORDER=1,
BORDER-BOTTOM=1,
BORDER-RIGHT=0,
BORDER-LEFT=0,
$
-*ACTIVE Specific
TYPE=REPORT,
OBJECT=MENU,
COLOR='RGB(44 62 80)',
-*HOVER-COLOR=RGB(51 51 51),
BACKCOLOR=RGB(236 240 241),
HOVER-BACKCOLOR='RGB(189 195 199)',
BORDER-COLOR='RGB(255 255 255)',
$
TYPE=REPORT,
OBJECT=STATUS-AREA,
JUSTIFY=LEFT,
PAGE-LOCATION=TOP,
COLOR='RGB(44 62 80)',
BORDER=0,
BACKCOLOR=RGB(236 240 241),
$
TYPE=REPORT,
ARGRAPHENGINE=JSCHART,
$
TYPE=REPORT,
ARICONSET=Blue,
ARSTYLESET=default,
$
TYPE=REPORT,
OBJECT=CURRENT-ROW,
HOVER-BACKCOLOR=RGB(243 243 243),
BACKCOLOR=RGB(255 246 127),
$
*GRAPH_SCRIPT
setSeriesLooping(8);
setColorMode(4);
setAutoColorLerpFactor(0.7);
//setPieRingSize(76);
*GRAPH_JS
chartsPerRow: 4,
series: [
{series:'all',
marker: {
visible: true,
shape:'circle',
size: 10,
fillEffect: 'seriesAuto',
border: {width: 1}
}
},
{series: 0, color: 'rgba( 24,127,196,1.0)'},
{series: 1, color: 'rgba(170,207, 82,1.0)'},
{series: 2, color: 'rgba(234, 85, 50,1.0)'},
{series: 3, color: 'rgba( 0,175,236,1.0)'},
{series: 4, color: 'rgba( 0,169, 95,1.0)'},
{series: 5, color: 'rgba(246,173, 60,1.0)'},
{series: 6, color: 'rgba( 77, 67,152,1.0)'},
{series: 7, color: 'rgba(166, 74,151,1.0)'},
],
dataLabels: {
position: 'insidetop',
visible: true,
font: '10pt Meiryo',
color: 'rgba(255,255,255,1.0)'
},
blaProperties: {
stackTotalLabel: {
visible: true,
font: '10pt Meiryo',
color: 'rgba(80,80,80,1.0)'
},
barGroupGapWidth: 0.5,
lineConnection: 'curved'
},
pieProperties: {
holeSize: '50%',
totalLabel: {
font: '10pt Meiryo',
color: 'rgba(80,80,80,1.0)'
},
label: {
font: '10pt Meiryo',
color: 'rgba(80,80,80,1.0)'
},
otherSlice: {
threshold: '5%'
},
},
interaction:{
click: 'otherSliceDrillDown'
},
bubbleMarker: {
maxSize: '12%'
},
treemapProperties: {
scaleCellFonts: true,
header: {
height: undefined,
fill: 'lightgrey',
border: {
width: 1,
color: 'white',
dash: ''
},
label: {
visible: true,
font: '10pt Meiryo',
color: 'rgba(80,80,80,1.0)'
}
},
cellBorder: {
width: 1,
color: 'white',
dash: '',
outerCellWidth: 1
}
},
trendline: {
enabled: true,
mode: 'linear',
line: {width: 1, color: '#F93F17',dash: '1 3'},
equationLabel: {
visible: true,
font: '9pt Meiryo',
color: 'rgba(80,80,80,1.0)',
mode:'r'
}
},
title: {
font: '10pt Meiryo',
color: 'rgba(80,80,80,1.0)'
},
subtitle: {
font: '10pt Meiryo',
color: 'rgba(80,80,80,1.0)'
},
legend: {
labels: {
font: '7pt Meiryo',
color: 'rgba(80,80,80,1.0)'
},
backgroundcolor: "transparent"
},
chartFrame: {
fill: {
color: 'rgba(255,255,255,1.0)'
},
border: {
width: 0,
color: 'rgba(236,236,236,1.0)',
dash: ''
}
},
border: {
width: 0,
color: 'rgba(236,236,236,1.0)',
dash: ''
},
mouseOverIndicator: {
enabled: true,
color: 'rgba(0,0,0,0.2)',
border: {
width: 1,
color: 'rgba(255,207,2,0.6)'
},
marker: {
color: 'rgba(255, 243, 63, 0.6)',
size: 15,
shape: 'circle',
rotation: 0,
position: 'top',
border: {
width: 0,
color: 'transparent',
dash: ''
}
}
},
introAnimation: {
enabled: true,
duration: 1400
},
xaxis: {
title: {
font: '10pt Meiryo',
color: 'rgba(80,80,80,1.0)',
},
labels: {
font: '10pt Meiryo',
color: 'rgba(80,80,80,1.0)',
excludeMin: false,
excludeMax: false,
rotation: 45
},
majorGrid: {
visible: false,
ticks: {
length: 1,
visible: true,
style: 'inner',
lineStyle: {
width: 1,
color: 'rgba(236,236,236,1.0)'
}
},
},
},
yaxis: {
/*
colorScale: {
colors: [ 'rgba(249,63,23,1.0)', 'rgba(255,207,2,1.0)', 'rgba(70,198,70,1.0)' ]
},
*/
title: {
font: '10pt Meiryo',
color: 'rgba(80,80,80,1.0)',
},
labels: {
font: '10pt Meiryo',
color: 'rgba(80,80,80,1.0)',
excludeMin: false,
excludeMax: false,
rotation: undefined
},
majorGrid: {
lineStyle: {
width: 1,
color: 'rgba(236,236,236,1.0)'
},
ticks: {
length: 1,
visible: true,
style: 'inner',
lineStyle: {
width: 1,
color: 'rgba(236,236,236,1.0)'
}
},
},
},
y2axis: {
title: {
font: '10pt Meiryo',
color: 'rgba(80,80,80,1.0)',
},
labels: {
font: '10pt Meiryo',
color: 'rgba(80,80,80,1.0)',
excludeMin: false,
excludeMax: false,
rotation: undefined
},
majorGrid: {
lineStyle: {
width: 1,
color: 'rgba(236,236,236,1.0)'
},
ticks: {
length: 1,
visible: true,
style: 'inner',
lineStyle: {
width: 1,
color: 'rgba(236,236,236,1.0)'
}
},
},
},
gaugeProperties: {
startAngle: 135,
endAngle: 45,
secondaryNeedlesAsMarkers: false,
groupLabel: {
visible: false,
font: '10pt Meiryo',
color: 'rgba(80,80,80,1.0)'
},
totalLabel: {
visible: 'auto',
font: '12pt Meiryo',
color: 'rgba(80,80,80,1.0)',
numberFormat: 'auto'
},
fill: {
color: 'transparent'
},
needleBase: {
size: '5%',
color: 'rgba(24,127,196,1)',
border: {
width: 0,
color: 'transparent',
dash: ''
}
},
axisWidth: '8%',
axisTickLength: '20%',
axisMinorTickLength: '0%',
outerBorder: {
width: '7%',
fill: {
color: 'transparent'
},
border: {
width: 0,
color: 'transparent',
dash: ''
}
}
},
htmlToolTip: {
enabled: true,
snap: false,
sticky: true,
fill: 'linear-gradient(to bottom, rgba(250,250,250,0.98) 8%, rgba(230,230,230,0.98) 95%)',
border: {
width: 1, color: 'rgba(150,150,150,0.95)'
},
style: {
font: '9pt Meiryo',
color: 'rgba(80,80,80,1.0)',
cursor: 'default',
boxShadow: '0px 3px 4px 0px rgba(50, 50, 50, 0.66)',
borderWidth: '1px',
padding: '6px 7px 7px 8px',
filter: "progid:DXImageTransform.Microsoft.gradient( startColorstr='#FAFAFA', endColorstr='#D2D2D2', GradientType=0)",
'borderRadius': 0
}
}
*END
TYPE=REPORT, TITLETEXT='地域別利益率', $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
setBorderColor(getGaugeBand2(),new Color(255,128,0));
setFillColor(getGaugeBand2(),new Color(255,128,0));
setDisplay(getGaugeBand4(),false);
setDisplay(getGaugeBand5(),false);
setScaleMinAuto(getY1Axis(),false);
setScaleMaxAuto(getY1Axis(),false);
setScaleMax(getY1Axis(),50.0);
setBorderColor(getGaugeBand1(),new Color(250,63,30));
setFillColor(getGaugeBand1(),new Color(250,63,30));
setGaugeBandMax(getGaugeBand1(),10.0);
setBorderColor(getGaugeBand3(),new Color(255,235,28));
setFillColor(getGaugeBand3(),new Color(255,235,28));
setBorderColor(getGaugeBand4(),new Color(171,240,69));
setFillColor(getGaugeBand4(),new Color(171,240,69));
setGaugeBandMax(getGaugeBand2(),40.0);
setGaugeBandMax(getGaugeBand4(),100.0);
setBorderColor(getGaugeBand5(),new Color(170,240,69));
setFillColor(getGaugeBand5(),new Color(170,240,69));
setGaugeBandMin(getGaugeBand4(),40.0);
setGaugeBandMin(getGaugeBand3(),30.0);
setGaugeBandMax(getGaugeBand3(),40.0);
*GRAPH_JS_FINAL
"pieProperties": {
"holeSize": "0%"
},
"agnosticSettings": {
"chartTypeFullName": "Special_Gauges"
}
*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 データベースへの接続エラー