{ "version": "5.8.0", "sources": [{ "id": "FILM_F_MAJOR", "modelType": "dwtable", "path": "tbl", "filter": [{ "exp": "RELEASE_DATE.YEAR='2015'" }], "customFields": [{ "hidden": true, "name": "FILM_ID1" }, { "name": "CALCULATOR_4", "exp": "COUNT(FILM_ID)", "type": "calc", "comment": "电影数量" }, { "name": "CALCULATOR_5", "exp": "REVENUE / SUM(REVENUE)", "type": "calc", "comment": "票房占比（按类别）", "dataType": "number" }, { "name": "CALCULATOR_6", "exp": "RANK(SUM(REVENUE), 'desc', GENRES_ID)", "type": "calc", "comment": "类别排名", "dataType": "int" }, { "name": "CALCULATOR_2", "exp": "case WHEN BUDGET <= 60000000 THEN '低于6千万' WHEN BUDGET > 60000000 AND BUDGET <= 120000000 THEN '6千万~1.2亿' WHEN BUDGET > 120000000 AND BUDGET <= 180000000 THEN '1.2亿~1.8亿' WHEN BUDGET > 180000000 AND BUDGET <= 240000000 THEN '1.8亿~2.4亿' WHEN BUDGET > 240000000 THEN '高于2.4亿' END", "len": 38, "dim": true, "calcBins": { "section": [{ "end": 60000000, "name": "低于6千万", "includeMax": true }, { "start": 60000000, "end": 120000000, "name": "6千万~1.2亿", "includeMax": true }, { "start": 120000000, "end": 180000000, "name": "1.2亿~1.8亿", "includeMax": true }, { "start": 180000000, "end": 240000000, "name": "1.8亿~2.4亿", "includeMax": true }, { "start": 240000000, "name": "高于2.4亿", "includeMax": false }], "targetField": "BUDGET" }, "type": "bin", "comment": "预算分段", "dataType": "string" }, { "name": "CALCULATOR_3", "exp": "case WHEN BUDGET <= 60000000 THEN '1' WHEN BUDGET > 60000000 AND BUDGET <= 120000000 THEN '2' WHEN BUDGET > 120000000 AND BUDGET <= 180000000 THEN '3' WHEN BUDGET > 180000000 AND BUDGET <= 240000000 THEN '4' WHEN BUDGET > 240000000 THEN '5' END", "len": 38, "dim": true, "calcBins": { "section": [{ "end": 60000000, "name": "1", "includeMax": true }, { "start": 60000000, "end": 120000000, "name": "2", "includeMax": true }, { "start": 120000000, "end": 180000000, "name": "3", "includeMax": true }, { "start": 180000000, "end": 240000000, "name": "4", "includeMax": true }, { "start": 240000000, "name": "5", "includeMax": false }], "targetField": "BUDGET" }, "type": "bin", "comment": "预算排名", "dataType": "string" }, { "name": "CALCULATOR_1", "exp": "case WHEN RUNTIME <= 80 THEN '低于80分钟' WHEN RUNTIME > 80 AND RUNTIME <= 100 THEN '80~100分钟' WHEN RUNTIME > 100 AND RUNTIME <= 120 THEN '100分钟~120分钟' WHEN RUNTIME > 120 THEN '高于120分钟' END", "len": 38, "dim": true, "calcBins": { "section": [{ "end": 80, "name": "低于80分钟", "includeMax": true }, { "start": 80, "end": 100, "name": "80~100分钟", "includeMax": true }, { "start": 100, "end": 120, "name": "100分钟~120分钟", "includeMax": true }, { "start": 120, "name": "高于120分钟", "includeMax": false }], "targetField": "RUNTIME" }, "type": "bin", "comment": "时长分段", "dataType": "string" }, { "name": "CALCULATOR_7", "exp": "case WHEN RUNTIME <= 80 THEN '1' WHEN RUNTIME > 80 AND RUNTIME <= 100 THEN '2' WHEN RUNTIME > 100 AND RUNTIME <= 120 THEN '3' WHEN RUNTIME > 120 THEN '4' END", "len": 38, "dim": true, "calcBins": { "section": [{ "end": 80, "name": "1", "includeMax": true }, { "start": 80, "end": 100, "name": "2", "includeMax": true }, { "start": 100, "end": 120, "name": "3", "includeMax": true }, { "start": 120, "name": "4", "includeMax": false }], "targetField": "RUNTIME" }, "type": "bin", "comment": "时长排名", "dataType": "string" }, { "hidden": true, "name": "POSTER_HIGHER1" }, { "hidden": true, "name": "POSTER_WIDER1" }] }, { "id": "GGDYXXB", "name": "各国电影信息表", "modelType": "dataflow", "content": "tbl1", "filter": [{ "exp": "RELEASE_DATE.YEAR='2015'" }], "customFields": [{ "hidden": true, "name": "FILM_ID1" }] }, { "id": "M111", "name": "各类别电影数据", "modelType": "dataflow", "content": "tbl2", "params": [{ "name": "param1", "value": "2016" }] }, { "id": "FILM_F_MAJOR1", "modelType": "dwtable", "path": "tbl1", "filter": [{ "field": "CALCULATOR_1", "operator": "<=", "value": "5" }, { "field": "RELEASE_DATE", "operator": "=", "value": "2015" }], "customFields": [{ "name": "CALCULATOR_1", "exp": "RANK(REVENUE, 'desc')", "type": "calc", "comment": "票房排名", "dataType": "int" }] }], "settings": { "theme": "golden" }, "devices": [{ "deviceType": "pc", "width": 1920, "height": 1080 }], "body": { "canvas": { "id": "canvas", "type": "canvas", "layoutType": "ppt", "designWidth": 1920, "designHeight": 1080, "children": [{ "id": "text1", "type": "text", "fill": { "type": "image", "image": { "path": "png" }, "mode": "contain" }, "value": "电 影 各 项 指 标 发 展 情 况", "textAlign": "center", "s": "h1", "left": 0, "top": 0, "width": 1920, "height": 112 }, { "id": "group1", "type": "group", "designWidth": 351.9904116977288, "designHeight": 935.9870557919339, "left": 0, "top": 143.98561754659318, "width": 351.9904116977288, "height": 935.9870557919339, "children": [{ "id": "backgroundBlock1", "type": "backgroundBlock", "imageSliceFill": { "image": "png1", "clip": "212 0 63 38" }, "left": 0, "top": 0, "width": 351.9904116977288, "height": 935.9870557919339 }, { "id": "pie1", "type": "pie", "showLegend": false, "left": 15.99328818841014, "top": 8.008150056930532, "width": 335.99712350931867, "height": 303.9875352070474, "measure": [{ "id": "compField1", "name": "区域占比(计数(电影ID))", "exp": "WINDOW_WEIGHT(COUNT(FILM_F_MAJOR.FILM_ID))", "role": "measure", "caption": "占比", "labelFont": { "size": "fontSize", "color": "#C1B876" }, "insideRadius": 60, "outsideRadius": 75, "minAngle": 2, "marks": [{ "id": "compField2", "type": "color", "name": "预算分段", "exp": "FILM_F_MAJOR.CALCULATOR_2", "role": "dimension" }] }], "title": { "value": "不同预算区间占比", "font": { "size": "fontSize" }, "textAlign": "left", "prefixIcon": "png2", "prefixIconSize": "iconSizeXL" }, "legend": { "position": "right" } }, { "id": "hbar1", "type": "hbar", "left": 15.99328818841014, "top": 311.995685263978, "width": 335.99712350931867, "height": 303.9875352070474, "x": [{ "id": "compField1", "name": "总计(票房) / 100000000", "exp": "SUM(FILM_F_MAJOR.REVENUE) / 100000000", "role": "measure", "caption": "票房（亿元）", "labelVisible": true, "labelFont": { "color": "#9B9CAA" }, "fill": "linear-gradient(180, #E3DCA3 0,#C1B876 0.22340425531914893,#654C20/0 1)", "width": 10, "borderRadius": "20 20 inherit inherit" }], "y": [{ "id": "compField2", "name": "预算分段", "exp": "FILM_F_MAJOR.CALCULATOR_2", "role": "dimension" }], "categoryAxis1": { "lineStyle": "none" }, "valueAxis1": { "labelVisible": false, "splitLineStyle": "none" }, "valueAxis2": { "labelVisible": false, "splitLineStyle": "none" }, "title": { "value": "不同预算区间电影平均票房（亿元）", "font": { "size": "fontSize" }, "prefixIcon": "png2", "prefixIconSize": "iconSizeXL" } }, { "id": "title1", "type": "title", "padding": "paddingXS", "value": "不同预算区间的电影评分", "font": { "size": "fontSize" }, "textAlign": "left", "prefixIcon": "png2", "prefixIconSize": "iconSizeXL", "left": 15.99328818841014, "top": 616.0062323964763, "width": 335.99712350931867, "height": 39.99472643375083 }, { "id": "queryFloatPanel1", "type": "queryFloatPanel", "layoutType": "card", "flexDirection": "column", "spanCount": 5, "gap": 4, "overflow": "hidden", "left": 15.99328818841014, "top": 656.0009588302271, "width": 335.99712350931867, "height": 255.98465871636606, "field": [{ "id": "compField1", "name": "预算分段", "exp": "FILM_F_MAJOR.CALCULATOR_2", "role": "dimension" }], "panel": { "layoutType": "tile", "children": [{ "id": "text2", "type": "text", "value": "${FILM_F_MAJOR.CALCULATOR_2}", "left": 0, "top": 0, "width": 3, "height": 6 }, { "id": "iconBar1", "type": "iconBar", "total": "10", "labelValue": "

${iconBar1.compField1}

", "left": 3, "top": 0, "width": 9, "height": 6, "measure": [{ "id": "compField1", "name": "平均值(评分)", "exp": "AVG(FILM_F_MAJOR.VOTE_AVERAGE)", "role": "measure", "caption": "平均评分" }] }] } }] }, { "id": "group2", "type": "group", "designWidth": 335.9971235093187, "designHeight": 935.9870557919339, "left": 1584.0028764906815, "top": 143.98561754659318, "width": 335.9971235093187, "height": 935.9870557919339, "children": [{ "id": "backgroundBlock3", "type": "backgroundBlock", "imageSliceFill": { "image": "png3", "clip": "216 76 84 0" }, "left": 0, "top": 0, "width": 335.99712350931867, "height": 935.9870557919339 }, { "id": "hbar3", "type": "hbar", "fill": "none", "padding": "paddingNone paddingXS", "barLayout": "overlap", "s": "dash-golden-chart", "left": 0, "top": 0, "width": 319.98082339545755, "height": 303.9875352070474, "x": [{ "id": "compField2", "name": "计数(电影ID)", "exp": "COUNT(FILM_F_MAJOR.FILM_ID)", "role": "measure", "caption": "数量", "labelVisible": true, "labelValue": "

${compField1}

", "labelPosition": "bottomRight", "labelFont": { "family": "arial, helvetica, sans-serif", "size": 12, "color": "colorTextTertiary" }, "fill": "linear-gradient(180, #E3DCA3 0.0967741935483871,#C1B876 0.25806451612903225,#654C20 1)", "width": 10, "background": "#FFFFFF/15", "borderRadius": 20 }, { "id": "compField3", "name": "1", "exp": "1", "role": "measure", "caption": "占比", "labelVisible": true, "labelFont": { "family": "arial, helvetica, sans-serif", "size": 12, "color": "colorTextTertiary" }, "fill": "#000000/23", "tooltip": { "contentType": "richtext", "richtext": "

时长分段: ${compField1}

占比: ${compField4}

" }, "targetAxis": "valueAxis2", "width": 10, "borderRadius": 20, "marks": [{ "id": "compField4", "type": "label", "name": "区域占比(电影ID)", "exp": "WINDOW_WEIGHT(COUNT(FILM_F_MAJOR.FILM_ID))", "role": "measure", "caption": "占比", "displayFormat": "percentage" }], "displayFormat": "percentage" }], "y": [{ "id": "compField1", "name": "CALCULATOR_1", "exp": "FILM_F_MAJOR.CALCULATOR_1", "role": "dimension", "sorts": { "type": "field", "fieldSorts": [{ "sortBy": "FILM_F_MAJOR.CALCULATOR_7", "direction": "asc", "aggregation": "MAX" }] } }], "categoryAxis1": { "lineStyle": "none", "labelVisible": false, "axisPosition": "left" }, "valueAxis1": { "labelVisible": false, "splitLineStyle": "none" }, "valueAxis2": { "labelVisible": false, "splitLineStyle": "none" }, "legend": { "display": "custom", "displayRange": [] }, "title": { "value": "不同时长电影数量占比", "font": { "size": "fontSize" }, "prefixIcon": "png2", "prefixIconSize": "iconSizeXL" } }, { "id": "bar1", "type": "bar", "fill": "none", "padding": "0 paddingXS", "s": "dash-golden-chart", "left": 0, "top": 304.01054713249835, "width": 319.98082339545755, "height": 303.9875352070474, "x": [{ "id": "compField1", "name": "CALCULATOR_1", "exp": "FILM_F_MAJOR.CALCULATOR_1", "role": "dimension" }], "y": [{ "id": "compField2", "name": "平均值(票房)/100000000", "exp": "AVG(FILM_F_MAJOR.REVENUE) / 100000000", "role": "measure", "caption": "票房（亿元）", "fill": "linear-gradient(180, #D5BE8F 0,#C1A876 0.23118279569892472,#C7856B/0 1)", "width": 10, "borderRadius": "20 20 0 0" }], "valueAxis1": { "labelVisible": false, "splitLineStyle": "none" }, "title": { "value": "不同时长电影的平均票房（亿元）", "font": { "size": "fontSize" }, "prefixIcon": "png2", "prefixIconSize": "iconSizeXL" } }, { "id": "panel7", "type": "panel", "fill": "none", "layoutType": "tile", "showTitle": true, "s": "dash-golden-panel", "cellGap": 5, "left": 0, "top": 607.9980823395458, "width": 319.98082339545755, "height": 295.97938515011685, "children": [{ "id": "kpi7", "type": "kpi", "fieldFilters": [{ "field": "FILM_F_MAJOR.RUNTIME", "filterClauses": [{ "operator": ">=", "value": "120" }] }], "s": "dash-golden-kpi", "left": 0, "top": 0, "width": 5, "height": 4, "measure": [{ "id": "compField1", "name": "平均值(评分)", "exp": "AVG(FILM_F_MAJOR.VOTE_AVERAGE)", "role": "measure", "caption": "平均评分", "visible": true, "valueFont": { "family": "艺黑数字体", "size": 35 } }] }, { "id": "iconBar2", "type": "iconBar", "icon": "$ICON:/5439", "total": "10", "labelValue": "

高于120分钟

", "fieldFilters": [{ "field": "FILM_F_MAJOR.RUNTIME", "havingClauses": [{ "operator": ">=", "value": "120" }] }], "labelPosition": "progressBottom", "s": "dash-golden-style", "left": 0, "top": 2, "width": 5, "height": 3, "measure": [{ "id": "compField1", "name": "平均值(评分)", "exp": "AVG(FILM_F_MAJOR.VOTE_AVERAGE)", "role": "measure", "caption": "平均评分" }], "progress": { "iconSize": 12 } }, { "id": "hbar2", "type": "hbar", "fill": "none", "padding": "0 paddingXS", "showTitle": false, "barLayout": "overlap", "s": "dash-golden-chart", "left": 5, "top": 0, "width": 7, "height": 6, "x": [{ "id": "compField2", "name": "平均值(评分)", "exp": "avg(FILM_F_MAJOR.VOTE_AVERAGE)", "role": "measure", "caption": "平均评分", "labelVisible": true, "labelValue": "

${compField1}

", "labelPosition": "bottomRight", "labelFont": { "family": "arial, helvetica, sans-serif", "size": 12, "color": "colorTextTertiary" }, "fill": "linear-gradient(180, #E3DCA3 0,#C1B876 0.5,#654C20/38 1)", "width": 10, "borderRadius": 20 }, { "id": "compField3", "name": "1", "exp": "1", "role": "measure", "caption": "评分", "labelVisible": true, "labelFont": { "family": "arial, helvetica, sans-serif", "size": 12, "color": "colorTextTertiary" }, "fill": "none", "tooltip": { "contentType": "richtext", "richtext": "

时长分段: ${compField1}

占比: ${compField4}

" }, "targetAxis": "valueAxis2", "width": 10, "borderRadius": "20 20 0 0", "marks": [{ "id": "compField4", "type": "label", "name": "平均值(评分)", "exp": "AVG(FILM_F_MAJOR.VOTE_AVERAGE)", "role": "measure", "caption": "评价评分" }], "displayFormat": "percentage" }], "y": [{ "id": "compField1", "name": "CALCULATOR_1", "exp": "FILM_F_MAJOR.CALCULATOR_1", "role": "dimension", "sorts": { "type": "field", "fieldSorts": [{ "sortBy": "FILM_F_MAJOR.CALCULATOR_7", "direction": "asc", "aggregation": "MAX" }] } }], "categoryAxis1": { "lineStyle": "none", "labelVisible": false, "axisPosition": "left" }, "valueAxis1": { "labelVisible": false, "splitLineStyle": "none" }, "valueAxis2": { "labelVisible": false, "splitLineStyle": "none" }, "legend": { "display": "custom", "displayRange": [] }, "title": { "value": "不同时长电影数量占比" } }], "title": { "value": "不同时长电影的平均评分", "font": { "size": "fontSize" }, "prefixIcon": "png2", "prefixIconSize": "iconSizeXL" } }] }, { "id": "image1", "type": "image", "image": { "sourceType": "static", "image": { "path": "png4" }, "mode": "contain" }, "s": "dash-golden-image", "left": 360, "top": 144, "width": 288, "height": 912 }, { "id": "image2", "type": "image", "image": { "sourceType": "static", "image": { "path": "png5", "width": 276, "height": 843 }, "mode": "contain" }, "s": "dash-golden-image", "left": 1288, "top": 144, "width": 288, "height": 912 }, { "id": "panel2", "type": "panel", "layoutType": "tile", "showTitle": true, "s": "dash-golden-panel1211", "rowCount": 30, "colCount": 20, "cellGap": 5, "left": 632, "top": 144, "width": 672, "height": 200, "children": [{ "id": "kpi1", "type": "kpi", "fill": { "type": "image", "image": { "path": "png6", "width": 230, "height": 80 }, "mode": "contain" }, "padding": "5 10 5 50", "verticalAlign": "left", "horizontalAlign": "flex-start", "icon": "png7", "fieldFilters": [{ "field": "GGDYXXB.COUNTRY_ID.NAME_Chinese", "filterClauses": [{ "operator": "=", "value": "中国" }], "role": "dimension" }], "s": "dash-golden-kpi", "left": 0, "top": 0, "width": 6, "height": 14, "measure": [{ "id": "compField1", "name": "总计(票房)/100000000", "exp": "SUM(GGDYXXB.REVENUE) / 100000000", "role": "measure", "caption": "中国", "titleFont": { "color": "#DAB064" }, "valueFont": { "size": 25 } }] }, { "id": "kpi2", "type": "kpi", "fill": { "type": "image", "image": { "path": "png6", "width": 230, "height": 80 }, "mode": "contain" }, "padding": "5 10 5 50", "verticalAlign": "left", "horizontalAlign": "flex-start", "icon": "jpg", "fieldFilters": [{ "field": "GGDYXXB.COUNTRY_ID.NAME_Chinese", "filterClauses": [{ "operator": "=", "value": "美国" }], "role": "dimension" }], "s": "dash-golden-kpi", "left": 0, "top": 15, "width": 6, "height": 15, "measure": [{ "id": "compField1", "name": "总计(票房)/100000000", "exp": "SUM(GGDYXXB.REVENUE) / 100000000", "role": "measure", "caption": "美国", "titleFont": { "color": "#DAB064" }, "valueFont": { "size": 25 } }] }, { "id": "kpi3", "type": "kpi", "fill": { "type": "image", "image": { "path": "png6", "width": 230, "height": 80 }, "mode": "contain" }, "padding": "5 10 5 50", "verticalAlign": "left", "horizontalAlign": "flex-start", "icon": "png8", "fieldFilters": [{ "field": "GGDYXXB.COUNTRY_ID.NAME_Chinese", "filterClauses": [{ "operator": "=", "value": "法国" }], "role": "dimension" }], "s": "dash-golden-kpi", "left": 7, "top": 15, "width": 6, "height": 15, "measure": [{ "id": "compField1", "name": "总计(票房)/100000000", "exp": "SUM(GGDYXXB.REVENUE) / 100000000", "role": "measure", "caption": "法国", "titleFont": { "color": "#DAB064" }, "valueFont": { "size": 25 } }] }, { "id": "kpi4", "type": "kpi", "fill": { "type": "image", "image": { "path": "png6", "width": 230, "height": 80 }, "mode": "contain" }, "padding": "5 10 5 50", "verticalAlign": "left", "horizontalAlign": "flex-start", "icon": "png9", "fieldFilters": [{ "field": "GGDYXXB.COUNTRY_ID.NAME_Chinese", "filterClauses": [{ "operator": "=", "value": "意大利" }], "role": "dimension" }], "s": "dash-golden-kpi", "left": 14, "top": 15, "width": 6, "height": 15, "measure": [{ "id": "compField1", "name": "总计(票房)/100000000", "exp": "SUM(GGDYXXB.REVENUE) / 100000000", "role": "measure", "caption": "意大利", "titleFont": { "color": "#DAB064" }, "valueFont": { "size": 25 } }] }, { "id": "kpi5", "type": "kpi", "fill": { "type": "image", "image": { "path": "png6", "width": 230, "height": 80 }, "mode": "contain" }, "padding": "5 10 5 50", "verticalAlign": "left", "horizontalAlign": "flex-start", "icon": "jpg1", "fieldFilters": [{ "field": "GGDYXXB.COUNTRY_ID.NAME_Chinese", "filterClauses": [{ "operator": "=", "value": "英国" }], "role": "dimension" }], "s": "dash-golden-kpi", "left": 7, "top": 0, "width": 6, "height": 14, "measure": [{ "id": "compField1", "name": "总计(票房)/100000000", "exp": "SUM(GGDYXXB.REVENUE) / 100000000", "role": "measure", "caption": "英国", "titleFont": { "color": "#DAB064" }, "valueFont": { "size": 25 } }] }, { "id": "kpi6", "type": "kpi", "fill": { "type": "image", "image": { "path": "png6", "width": 230, "height": 80 }, "mode": "contain" }, "padding": "5 10 5 50", "verticalAlign": "left", "horizontalAlign": "flex-start", "icon": "jpg2", "fieldFilters": [{ "field": "GGDYXXB.COUNTRY_ID.NAME_Chinese", "filterClauses": [{ "operator": "=", "value": "德国" }], "role": "dimension" }], "s": "dash-golden-kpi", "left": 14, "top": 0, "width": 6, "height": 14, "measure": [{ "id": "compField1", "name": "总计(票房)/100000000", "exp": "SUM(GGDYXXB.REVENUE) / 100000000", "role": "measure", "caption": "德国", "titleFont": { "color": "#DAB064" }, "valueFont": { "size": 25 } }] }], "title": { "value": "常见国家的票房情况（亿元）" } }, { "id": "odometer1", "type": "odometer", "s": "dash-golden-odometer", "left": 504, "top": 368, "width": 968, "height": 152, "measure": [{ "id": "compField1", "name": "总计(票房)/10000000", "exp": "SUM(FILM_F_MAJOR.REVENUE) / 10000000", "role": "measure", "caption": "票房（亿元）" }], "series": { "font": { "family": "庞门正道标题体", "size": 70, "color": "#F1ECBC" }, "symbolFont": { "family": "液晶数字体", "size": 70, "color": "#F1ECBC" } } }, { "id": "panel4", "type": "panel", "layoutType": "tile", "showTitle": true, "s": "dash-golden-panel1211", "rowCount": 30, "colCount": 20, "cellGap": 5, "left": 648, "top": 904, "width": 640, "height": 176, "children": [{ "id": "percentRing5", "type": "percentRing", "fill": { "type": "image", "image": { "path": "png10", "width": 206, "height": 206 }, "mode": "contain" }, "padding": 0, "showTitle": false, "fieldFilters": [{ "role": "measure", "field": "M111.PM", "filterClauses": [{ "operator": "=", "value": "1" }] }], "s": "dash-golden-chart", "left": 0, "top": 1, "width": 4, "height": 16, "measure": [{ "id": "compField1", "name": "总计", "exp": "SUM(M111.REVENUE / M111.REVENUE1)", "role": "measure", "displayFormat": "percentage" }], "series": { "total": "1", "contentType": "richtext", "labelValue": "

${compField1}

", "labelFont": { "family": "艺黑数字体", "size": 16, "color": "colorSeries6" }, "fill": "colorSeries6", "radius": 78, "width": 10, "clockwise": false, "roundCap": true } }, { "id": "text7", "type": "text", "value": "${M111.GENRES_ID.NAME_CHINESE}", "font": { "color": "colorPrimary" }, "textAlign": "center", "s": "dash-golden-text", "left": 0, "top": 16, "width": 4, "height": 6 }, { "id": "percentRing1", "type": "percentRing", "fill": { "type": "image", "image": { "path": "png10", "width": 206, "height": 206 }, "mode": "contain" }, "padding": 0, "showTitle": false, "fieldFilters": [{ "role": "measure", "field": "M111.PM", "filterClauses": [{ "operator": "=", "value": "2" }] }], "s": "dash-golden-chart", "left": 4, "top": 4, "width": 4, "height": 16, "measure": [{ "id": "compField1", "name": "总计", "exp": "SUM(M111.REVENUE / M111.REVENUE1)", "role": "measure", "displayFormat": "percentage" }], "series": { "labelFont": { "family": "艺黑数字体", "size": 16, "color": "colorSeries6" }, "fill": "colorSeries6", "radius": 78, "width": 10, "clockwise": false, "roundCap": true } }, { "id": "percentRing2", "type": "percentRing", "fill": { "type": "image", "image": { "path": "png10", "width": 206, "height": 206 }, "mode": "contain" }, "padding": 0, "showTitle": false, "fieldFilters": [{ "role": "measure", "field": "M111.PM", "filterClauses": [{ "operator": "=", "value": "3" }] }], "s": "dash-golden-chart", "left": 8, "top": 7, "width": 4, "height": 16, "measure": [{ "id": "compField1", "name": "总计", "exp": "SUM(M111.REVENUE / M111.REVENUE1)", "role": "measure", "displayFormat": "percentage" }], "series": { "labelFont": { "family": "艺黑数字体", "size": 16, "color": "colorSeries6" }, "fill": "colorSeries6", "radius": 78, "width": 10, "clockwise": false, "roundCap": true } }, { "id": "percentRing3", "type": "percentRing", "fill": { "type": "image", "image": { "path": "png10", "width": 206, "height": 206 }, "mode": "contain" }, "padding": 0, "showTitle": false, "fieldFilters": [{ "role": "measure", "field": "M111.PM", "filterClauses": [{ "operator": "=", "value": "4" }] }], "s": "dash-golden-chart", "left": 12, "top": 4, "width": 4, "height": 16, "measure": [{ "id": "compField1", "name": "总计", "exp": "SUM(M111.REVENUE / M111.REVENUE1)", "role": "measure", "displayFormat": "percentage" }], "series": { "labelFont": { "family": "艺黑数字体", "size": 16, "color": "colorSeries4" }, "radius": 78, "width": 10, "clockwise": false, "roundCap": true } }, { "id": "percentRing4", "type": "percentRing", "fill": { "type": "image", "image": { "path": "png10", "width": 206, "height": 206 }, "mode": "contain" }, "padding": 0, "showTitle": false, "fieldFilters": [{ "role": "measure", "field": "M111.PM", "filterClauses": [{ "operator": "=", "value": "5" }] }], "s": "dash-golden-chart", "left": 16, "top": 1, "width": 4, "height": 16, "measure": [{ "id": "compField1", "name": "总计", "exp": "SUM(M111.REVENUE / M111.REVENUE1)", "role": "measure", "displayFormat": "percentage" }], "series": { "labelFont": { "family": "艺黑数字体", "size": 16, "color": "colorSeries4" }, "radius": 78, "width": 10, "clockwise": false, "roundCap": true } }, { "id": "text3", "type": "text", "value": "${M111.GENRES_ID.NAME_CHINESE}", "font": { "color": "colorPrimary" }, "textAlign": "center", "s": "dash-golden-text", "left": 4, "top": 19, "width": 4, "height": 6 }, { "id": "text4", "type": "text", "value": "${M111.GENRES_ID.NAME_CHINESE}", "font": { "color": "colorPrimary" }, "textAlign": "center", "s": "dash-golden-text", "left": 8, "top": 22, "width": 4, "height": 6 }, { "id": "text5", "type": "text", "value": "${M111.GENRES_ID.NAME_CHINESE}", "font": { "color": "colorPrimary" }, "textAlign": "center", "s": "dash-golden-text", "left": 12, "top": 19, "width": 4, "height": 6 }, { "id": "text6", "type": "text", "value": "${M111.GENRES_ID.NAME_CHINESE}", "font": { "color": "colorPrimary" }, "textAlign": "center", "s": "dash-golden-text", "left": 16, "top": 16, "width": 4, "height": 6 }], "title": { "fill": { "type": "image", "image": { "path": "png11", "width": 424, "height": 13 }, "mode": "original", "align": "center", "vAlign": "center" }, "value": "票房占比Top5的电影类型", "textAlign": "center" } }] } }, "referenceResources": { "tbl": { "targetType": "METAFILE", "targetPath": "$DATA:/行业/电影模型/fact/FILM_F_GENRES_INFO.tbl", "refType": "link", "srcComponent": "FILM_F_MAJOR", "srcProperty": "path" }, "tbl1": { "targetType": "METAFILE", "targetPath": "$DATA:/行业/电影模型/fact/FILM_F_MAJOR.tbl", "refType": "link", "srcComponent": "FILM_F_MAJOR1", "srcProperty": "path" }, "png": { "targetType": "EXTFILE", "targetPath": "$EXTFILE:/images/succ-images-black/bg_title8.png", "refType": "link", "srcComponent": "text1", "srcProperty": "fill", "subFileType": "images" }, "text": { "targetType": "EXTPOINT", "targetPath": "$EXTPOINT:/component/text", "refType": "link" }, "png1": { "targetType": "EXTFILE", "targetPath": "$EXTFILE:/images/succ-images-black/bg_chart2.png", "refType": "link", "srcComponent": "backgroundBlock1", "srcProperty": "imageSliceFill", "subFileType": "images" }, "backgroundBlock": { "targetType": "EXTPOINT", "targetPath": "$EXTPOINT:/component/backgroundBlock", "refType": "link" }, "png2": { "targetType": "THEMEIMG", "targetPath": "$THEMEIMG:/icons/icon.png", "refType": "link", "subFileType": "icons" }, "componentTitle": { "targetType": "EXTPOINT", "targetPath": "$EXTPOINT:/component/componentTitle", "refType": "link" }, "pie": { "targetType": "EXTPOINT", "targetPath": "$EXTPOINT:/component/pie", "refType": "link" }, "hbar": { "targetType": "EXTPOINT", "targetPath": "$EXTPOINT:/component/hbar", "refType": "link" }, "title": { "targetType": "EXTPOINT", "targetPath": "$EXTPOINT:/component/title", "refType": "link" }, "card": { "targetType": "EXTPOINT", "targetPath": "$EXTPOINT:/componentLayout/card", "refType": "link" }, "iconBar": { "targetType": "EXTPOINT", "targetPath": "$EXTPOINT:/component/iconBar", "refType": "link" }, "queryFloatPanel": { "targetType": "EXTPOINT", "targetPath": "$EXTPOINT:/component/queryFloatPanel", "refType": "link" }, "group": { "targetType": "EXTPOINT", "targetPath": "$EXTPOINT:/component/group", "refType": "link" }, "png3": { "targetType": "EXTFILE", "targetPath": "$EXTFILE:/images/succ-images-black/bg_chart1.png", "refType": "link", "srcComponent": "backgroundBlock3", "srcProperty": "imageSliceFill", "subFileType": "images" }, "bar": { "targetType": "EXTPOINT", "targetPath": "$EXTPOINT:/component/bar", "refType": "link" }, "kpi": { "targetType": "EXTPOINT", "targetPath": "$EXTPOINT:/component/kpi", "refType": "link" }, "panel": { "targetType": "EXTPOINT", "targetPath": "$EXTPOINT:/component/panel", "refType": "link" }, "png4": { "targetType": "INNERIMG", "targetPath": "$INNERIMG:/a830d8e36ed676471d55a7c24d1cb1cf.png", "refType": "link", "srcComponent": "image1", "srcProperty": "image", "subFileType": "images" }, "image": { "targetType": "EXTPOINT", "targetPath": "$EXTPOINT:/component/image", "refType": "link" }, "png5": { "targetType": "INNERIMG", "targetPath": "$INNERIMG:/bd34f8d53fc27e3af17128b5392f79ab.png", "refType": "link", "srcComponent": "image2", "srcProperty": "image", "subFileType": "images" }, "png6": { "targetType": "THEMEIMG", "targetPath": "$THEMEIMG:/images/bg_kpi7.png", "refType": "link", "srcComponent": "kpi1", "srcProperty": "fill", "subFileType": "images" }, "png7": { "targetType": "INNERIMG", "targetPath": "$INNERIMG:/84a92dc1fde763b0c737daa56104d2ac.png", "refType": "link", "subFileType": "icons" }, "jpg": { "targetType": "INNERIMG", "targetPath": "$INNERIMG:/f2df27b14d2c2896378061d7ac090ed5.jpg", "refType": "link", "subFileType": "icons" }, "png8": { "targetType": "INNERIMG", "targetPath": "$INNERIMG:/b57831ea93d9253d3e10757f22b7589b.png", "refType": "link", "subFileType": "icons" }, "png9": { "targetType": "INNERIMG", "targetPath": "$INNERIMG:/070f551fc1fd4f2e49f99dd91300edd8.png", "refType": "link", "subFileType": "icons" }, "jpg1": { "targetType": "INNERIMG", "targetPath": "$INNERIMG:/caaf84a9278d66c1d2bd8ef19bfc8b51.jpg", "refType": "link", "subFileType": "icons" }, "jpg2": { "targetType": "INNERIMG", "targetPath": "$INNERIMG:/d899e47ec950dd1c9a29e659806f71c7.jpg", "refType": "link", "subFileType": "icons" }, "odometer": { "targetType": "EXTPOINT", "targetPath": "$EXTPOINT:/component/odometer", "refType": "link" }, "png10": { "targetType": "INNERIMG", "targetPath": "$INNERIMG:/a69fff3b0c25bce33ecaeb3981556ded.png", "refType": "link", "srcComponent": "percentRing5", "srcProperty": "fill", "subFileType": "images" }, "percentRing": { "targetType": "EXTPOINT", "targetPath": "$EXTPOINT:/component/percentRing", "refType": "link" }, "png11": { "targetType": "THEMEIMG", "targetPath": "$THEMEIMG:/images/bg_title1.png", "refType": "link", "srcComponent": "title", "srcProperty": "fill", "subFileType": "images" } }, "innerResources": { "tbl1": { "type": "tbl", "content": { "version": "5.8.0", "tableType": "DataFlow", "settings": {}, "fields": [{ "name": "COUNTRY_ID", "comment": "国家ID", "dataType": "string", "len": 10, "relTable": "FILM_DIM_COUNTRY" }, { "name": "COUNTRY_NAME", "comment": "国家名称", "dataType": "string", "len": 100 }, { "name": "FILM_ID", "comment": "电影ID", "dataType": "string", "len": 20, "relTable": "FILM_F_MAJOR1" }, { "name": "FILM_ID1", "comment": "电影ID(1)", "dataType": "string", "len": 20, "textField": "TITLE" }, { "name": "TITLE", "comment": "电影标题", "dataType": "string", "len": 100 }, { "name": "STATUS", "comment": "电影状态", "dataType": "string", "len": 20 }, { "name": "HOMEPAGE", "comment": "电影主页", "dataType": "string", "len": 280 }, { "name": "TAGLINE", "comment": "标语", "dataType": "string", "len": 500 }, { "name": "ORIGINAL_LANGUAGE", "comment": "原始语言", "dataType": "string", "len": 100, "relTable": "FILM_DIM_LANGUAGE" }, { "name": "RELEASE_DATE", "comment": "上映时间", "dataType": "date", "valueFormat": "yyyymmdd", "role": "period/date" }, { "name": "POSTER_HIGHER", "comment": "海报(较高)", "dataType": "blob", "dim": true }, { "name": "POSTER_WIDER", "comment": "海报(较宽)", "dataType": "blob", "dim": true }, { "name": "POPULARITY", "comment": "欢迎度", "dataType": "number", "len": 10, "scale": 6 }, { "name": "BUDGET", "comment": "预算", "dataType": "int", "len": 38 }, { "name": "REVENUE", "comment": "票房", "dataType": "int", "len": 38 }, { "name": "RUNTIME", "comment": "电影时长", "dataType": "int", "len": 38 }, { "name": "VOTE_COUNT", "comment": "投票数", "dataType": "int", "len": 38 }, { "name": "VOTE_AVERAGE", "comment": "评分", "dataType": "number", "len": 10, "scale": 5 }, { "name": "OVERVIEW", "comment": "简介", "dataType": "clob" }], "dataFlow": [{ "id": "modeltable1", "type": "ModelTable", "moduleTablePath": "FILM_F_COUNTRY", "devQueryFixedRows": true, "devFixedRowCount": 10000, "fields": [{ "name": "COUNTRY_ID", "comment": "国家ID", "dataType": "string", "len": 10, "relTable": "FILM_DIM_COUNTRY", "folder": "dimensions" }, { "name": "COUNTRY_NAME", "comment": "国家名称", "dataType": "string", "len": 100, "folder": "dimensions" }, { "name": "FILM_ID", "comment": "电影ID", "dataType": "string", "len": 20, "relTable": "FILM_F_MAJOR1", "folder": "dimensions" }], "name": "FILM_F_COUNTRY" }, { "id": "modeltable2", "type": "ModelTable", "moduleTablePath": "FILM_F_MAJOR", "devQueryFixedRows": true, "devFixedRowCount": 10000, "fields": [{ "name": "FILM_ID", "comment": "电影ID", "dataType": "string", "len": 20, "folder": "dimensions", "textField": "TITLE" }, { "name": "TITLE", "comment": "电影标题", "dataType": "string", "len": 100, "folder": "dimensions" }, { "name": "STATUS", "comment": "电影状态", "dataType": "string", "len": 20, "folder": "dimensions" }, { "name": "HOMEPAGE", "comment": "电影主页", "dataType": "string", "len": 280, "folder": "dimensions" }, { "name": "TAGLINE", "comment": "标语", "dataType": "string", "len": 500, "folder": "dimensions" }, { "name": "ORIGINAL_LANGUAGE", "comment": "原始语言", "dataType": "string", "len": 100, "relTable": "FILM_DIM_LANGUAGE", "folder": "dimensions" }, { "name": "RELEASE_DATE", "comment": "上映时间", "dataType": "date", "valueFormat": "yyyymmdd", "role": "period/date", "folder": "dimensions" }, { "name": "POSTER_HIGHER", "comment": "海报（较高）", "dataType": "string", "len": 50, "folder": "dimensions" }, { "name": "POSTER_WIDER", "comment": "海报（较宽）", "dataType": "string", "len": 50, "folder": "dimensions" }, { "name": "POPULARITY", "comment": "欢迎度", "dataType": "number", "len": 10, "scale": 6, "folder": "measures" }, { "name": "BUDGET", "comment": "预算", "dataType": "int", "len": 38, "folder": "measures" }, { "name": "REVENUE", "comment": "票房", "dataType": "int", "len": 38, "folder": "measures" }, { "name": "RUNTIME", "comment": "电影时长", "dataType": "int", "len": 38, "folder": "measures" }, { "name": "VOTE_COUNT", "comment": "投票数", "dataType": "int", "len": 38, "folder": "measures" }, { "name": "VOTE_AVERAGE", "comment": "评分", "dataType": "number", "len": 10, "scale": 5, "folder": "measures" }, { "name": "OVERVIEW", "comment": "简介", "dataType": "clob", "folder": "measures" }], "name": "FILM_F_MAJOR" }, { "id": "join1", "type": "Join", "inputNodes": ["modeltable1", "modeltable2"], "fields": [{ "name": "COUNTRY_ID", "source": "modeltable1.COUNTRY_ID" }, { "name": "COUNTRY_NAME", "source": "modeltable1.COUNTRY_NAME" }, { "name": "FILM_ID", "source": "modeltable1.FILM_ID" }, { "name": "FILM_ID1", "comment": "电影ID(1)", "source": "modeltable2.FILM_ID" }, { "name": "TITLE", "source": "modeltable2.TITLE" }, { "name": "STATUS", "source": "modeltable2.STATUS" }, { "name": "HOMEPAGE", "source": "modeltable2.HOMEPAGE" }, { "name": "TAGLINE", "source": "modeltable2.TAGLINE" }, { "name": "ORIGINAL_LANGUAGE", "source": "modeltable2.ORIGINAL_LANGUAGE" }, { "name": "RELEASE_DATE", "source": "modeltable2.RELEASE_DATE" }, { "name": "POSTER_HIGHER", "source": "modeltable2.POSTER_HIGHER" }, { "name": "POSTER_WIDER", "source": "modeltable2.POSTER_WIDER" }, { "name": "POPULARITY", "source": "modeltable2.POPULARITY" }, { "name": "BUDGET", "source": "modeltable2.BUDGET" }, { "name": "REVENUE", "source": "modeltable2.REVENUE" }, { "name": "RUNTIME", "source": "modeltable2.RUNTIME" }, { "name": "VOTE_COUNT", "source": "modeltable2.VOTE_COUNT" }, { "name": "VOTE_AVERAGE", "source": "modeltable2.VOTE_AVERAGE" }, { "name": "OVERVIEW", "source": "modeltable2.OVERVIEW" }], "joinConditions": [{ "leftTable": "modeltable1", "rightTable": "modeltable2", "joinType": "LeftJoin", "clauses": [{ "field": "modeltable1.FILM_ID", "operator": "=", "value": "=modeltable2.FILM_ID" }] }], "name": "关联" }, { "id": "default", "type": "Output", "inputNodes": ["join1"], "fields": ["COUNTRY_ID", "COUNTRY_NAME", "FILM_ID", "FILM_ID1", "TITLE", "STATUS", "HOMEPAGE", "TAGLINE", "ORIGINAL_LANGUAGE", "RELEASE_DATE", { "name": "POSTER_HIGHER", "comment": "海报(较高)", "dataType": "blob" }, { "name": "POSTER_WIDER", "comment": "海报(较宽)", "dataType": "blob" }, "POPULARITY", "BUDGET", "REVENUE", "RUNTIME", "VOTE_COUNT", "VOTE_AVERAGE", "OVERVIEW"], "name": "模型输出" }], "referenceResources": { "FILM_DIM_COUNTRY": { "targetType": "METAFILE", "targetPath": "$DATA:/行业/电影模型/dim/FILM_DIM_COUNTRY.tbl", "refType": "link" }, "FILM_F_MAJOR": { "targetType": "METAFILE", "targetPath": "$DATA:/行业/电影模型/fact/FILM_F_MAJOR.tbl", "refType": "query", "srcComponent": "modeltable2", "srcProperty": "moduleTablePath" }, "FILM_DIM_LANGUAGE": { "targetType": "METAFILE", "targetPath": "$DATA:/行业/电影模型/dim/FILM_DIM_LANGUAGE.tbl", "refType": "link" }, "FILM_F_COUNTRY": { "targetType": "METAFILE", "targetPath": "$DATA:/行业/电影模型/fact/FILM_F_COUNTRY.tbl", "refType": "query", "srcComponent": "modeltable1", "srcProperty": "moduleTablePath" }, "FILM_F_MAJOR1": { "targetType": "METAFILE", "targetPath": "$DATA:/行业/电影模型/fact/FILM_F_MAJOR.tbl", "refType": "link", "srcComponent": "FILM_ID", "srcProperty": "relTable" } } } }, "tbl2": { "type": "tbl", "content": { "version": "5.8.0", "tableType": "DataFlow", "settings": {}, "fields": [{ "name": "GENRES_ID", "comment": "类别ID", "dataType": "string", "len": 20, "relTable": "FILM_DIM_GENRES" }, { "name": "POPULARITY", "comment": "欢迎度", "dataType": "number", "len": 10, "scale": 6 }, { "name": "BUDGET", "comment": "预算", "dataType": "int", "len": 38 }, { "name": "REVENUE", "comment": "票房", "dataType": "int", "len": 38 }, { "name": "RUNTIME", "comment": "电影时长", "dataType": "int", "len": 38 }, { "name": "VOTE_COUNT", "comment": "投票数", "dataType": "int", "len": 38 }, { "name": "VOTE_AVERAGE", "comment": "评分", "dataType": "number", "len": 10, "scale": 5 }, { "name": "PM", "comment": "排名", "dataType": "int", "len": 38 }, { "name": "REVENUE1", "comment": "总票房", "dataType": "int", "len": 38 }], "dataFlow": [{ "id": "modeltable1", "type": "ModelTable", "moduleTablePath": "FILM_F_GENRES_INFO", "devQueryFixedRows": true, "devFixedRowCount": 10000, "fields": [{ "name": "FILM_ID", "comment": "电影ID", "dataType": "string", "len": 20, "relTable": "FILM_F_MAJOR", "folder": "dimensions", "textField": "TITLE" }, { "name": "TITLE", "comment": "电影标题", "dataType": "string", "len": 100, "folder": "dimensions" }, { "name": "STATUS", "comment": "电影状态", "dataType": "string", "len": 20, "folder": "dimensions" }, { "name": "HOMEPAGE", "comment": "电影主页", "dataType": "string", "len": 280, "folder": "dimensions" }, { "name": "TAGLINE", "comment": "标语", "dataType": "string", "len": 500, "folder": "dimensions" }, { "name": "ORIGINAL_LANGUAGE", "comment": "原始语言", "dataType": "string", "len": 100, "relTable": "FILM_DIM_LANGUAGE", "folder": "dimensions" }, { "name": "RELEASE_DATE", "comment": "上映时间", "dataType": "date", "valueFormat": "yyyymmdd", "role": "period/date", "folder": "dimensions" }, { "name": "GENRES_ID", "comment": "类别ID", "dataType": "string", "len": 20, "relTable": "FILM_DIM_GENRES", "folder": "dimensions" }, { "name": "GENRES_NAME", "comment": "类别名称", "dataType": "string", "len": 100, "folder": "dimensions" }, { "name": "DYLBFZ", "comment": "电影类别分组", "dataType": "string", "len": 20, "folder": "dimensions" }, { "name": "POPULARITY", "comment": "欢迎度", "dataType": "number", "len": 10, "scale": 6, "folder": "measures" }, { "name": "BUDGET", "comment": "预算", "dataType": "int", "len": 38, "folder": "measures" }, { "name": "REVENUE", "comment": "票房", "dataType": "int", "len": 38, "folder": "measures" }, { "name": "RUNTIME", "comment": "电影时长", "dataType": "int", "len": 38, "folder": "measures" }, { "name": "VOTE_COUNT", "comment": "投票数", "dataType": "int", "len": 38, "folder": "measures" }, { "name": "VOTE_AVERAGE", "comment": "评分", "dataType": "number", "len": 10, "scale": 5, "folder": "measures" }, { "name": "OVERVIEW", "comment": "简介", "dataType": "clob", "folder": "measures" }], "filter": [{ "exp": "RELEASE_DATE.year = '2015'" }], "name": "FILM_F_GENRES_INFO" }, { "id": "select1", "type": "Select", "inputNodes": ["modeltable1"], "fields": ["FILM_ID", "TITLE", "STATUS", "HOMEPAGE", "TAGLINE", "ORIGINAL_LANGUAGE", "RELEASE_DATE", "GENRES_ID", "GENRES_NAME", "DYLBFZ", { "name": "HZZD", "comment": "汇总字段", "dataType": "string", "len": 3, "folder": "dimensions" }, "POPULARITY", "BUDGET", "REVENUE", "RUNTIME", "VOTE_COUNT", "VOTE_AVERAGE", "OVERVIEW"], "steps": [{ "type": "AddField", "addField": { "name": "HZZD", "comment": "汇总字段", "dataType": "string", "len": 3, "dim": true, "exp": "'A'", "folder": "dimensions", "extractable": true } }], "name": "列加工1" }, { "id": "agg1", "type": "Agg", "inputNodes": ["select1"], "groupFields": ["HZZD"], "fields": [{ "name": "HZZD", "hidden": false }, { "name": "FILM_ID", "hidden": true, "aggType": "MAX" }, { "name": "TITLE", "hidden": true, "aggType": "MAX" }, { "name": "STATUS", "hidden": true, "aggType": "MAX" }, { "name": "HOMEPAGE", "hidden": true, "aggType": "MAX" }, { "name": "TAGLINE", "hidden": true, "aggType": "MAX" }, { "name": "ORIGINAL_LANGUAGE", "hidden": true, "aggType": "MAX" }, { "name": "RELEASE_DATE", "hidden": true, "aggType": "MAX" }, { "name": "GENRES_ID", "hidden": true, "aggType": "MAX" }, { "name": "GENRES_NAME", "hidden": true, "aggType": "MAX" }, { "name": "DYLBFZ", "hidden": true, "aggType": "MAX" }, { "name": "POPULARITY", "hidden": false, "aggType": "SUM" }, { "name": "BUDGET", "hidden": false, "aggType": "SUM" }, { "name": "REVENUE", "hidden": false, "aggType": "SUM" }, { "name": "RUNTIME", "hidden": false, "aggType": "SUM" }, { "name": "VOTE_COUNT", "hidden": false, "aggType": "SUM" }, { "name": "VOTE_AVERAGE", "hidden": false, "aggType": "SUM" }, { "name": "OVERVIEW", "hidden": true, "aggType": "MAX" }], "name": "汇总1" }, { "id": "modeltable2", "type": "ModelTable", "moduleTablePath": "FILM_F_GENRES_INFO", "devQueryFixedRows": true, "devFixedRowCount": 10000, "fields": [{ "name": "FILM_ID", "comment": "电影ID", "dataType": "string", "len": 20, "relTable": "FILM_F_MAJOR", "folder": "dimensions", "textField": "TITLE" }, { "name": "TITLE", "comment": "电影标题", "dataType": "string", "len": 100, "folder": "dimensions" }, { "name": "STATUS", "comment": "电影状态", "dataType": "string", "len": 20, "folder": "dimensions" }, { "name": "HOMEPAGE", "comment": "电影主页", "dataType": "string", "len": 280, "folder": "dimensions" }, { "name": "TAGLINE", "comment": "标语", "dataType": "string", "len": 500, "folder": "dimensions" }, { "name": "ORIGINAL_LANGUAGE", "comment": "原始语言", "dataType": "string", "len": 100, "relTable": "FILM_DIM_LANGUAGE", "folder": "dimensions" }, { "name": "RELEASE_DATE", "comment": "上映时间", "dataType": "date", "valueFormat": "yyyymmdd", "role": "period/date", "folder": "dimensions" }, { "name": "GENRES_ID", "comment": "类别ID", "dataType": "string", "len": 20, "relTable": "FILM_DIM_GENRES", "folder": "dimensions" }, { "name": "GENRES_NAME", "comment": "类别名称", "dataType": "string", "len": 100, "folder": "dimensions" }, { "name": "DYLBFZ", "comment": "电影类别分组", "dataType": "string", "len": 20, "folder": "dimensions" }, { "name": "POPULARITY", "comment": "欢迎度", "dataType": "number", "len": 10, "scale": 6, "folder": "measures" }, { "name": "BUDGET", "comment": "预算", "dataType": "int", "len": 38, "folder": "measures" }, { "name": "REVENUE", "comment": "票房", "dataType": "int", "len": 38, "folder": "measures" }, { "name": "RUNTIME", "comment": "电影时长", "dataType": "int", "len": 38, "folder": "measures" }, { "name": "VOTE_COUNT", "comment": "投票数", "dataType": "int", "len": 38, "folder": "measures" }, { "name": "VOTE_AVERAGE", "comment": "评分", "dataType": "number", "len": 10, "scale": 5, "folder": "measures" }, { "name": "OVERVIEW", "comment": "简介", "dataType": "clob", "folder": "measures" }], "filter": [{ "exp": "RELEASE_DATE.year = '2015'" }], "name": "FILM_F_MAJOR" }, { "id": "select2", "type": "Select", "inputNodes": ["agg1"], "fields": [{ "name": "HZZD", "hidden": false }, { "name": "POPULARITY", "hidden": true }, { "name": "BUDGET", "hidden": true }, { "name": "REVENUE", "hidden": false }, { "name": "RUNTIME", "hidden": true }, { "name": "VOTE_COUNT", "hidden": true }, { "name": "VOTE_AVERAGE", "hidden": true }], "name": "列加工2" }, { "id": "agg2", "type": "Agg", "inputNodes": ["modeltable2"], "groupFields": ["GENRES_ID"], "fields": [{ "name": "GENRES_ID", "hidden": false }, { "name": "FILM_ID", "hidden": true, "aggType": "MAX" }, { "name": "TITLE", "hidden": true, "aggType": "MAX" }, { "name": "STATUS", "hidden": true, "aggType": "MAX" }, { "name": "HOMEPAGE", "hidden": true, "aggType": "MAX" }, { "name": "TAGLINE", "hidden": true, "aggType": "MAX" }, { "name": "ORIGINAL_LANGUAGE", "hidden": true, "aggType": "MAX" }, { "name": "RELEASE_DATE", "hidden": true, "aggType": "MAX" }, { "name": "GENRES_NAME", "hidden": true, "aggType": "MAX" }, { "name": "DYLBFZ", "hidden": true, "aggType": "MAX" }, { "name": "POPULARITY", "hidden": false, "aggType": "SUM" }, { "name": "BUDGET", "hidden": false, "aggType": "SUM" }, { "name": "REVENUE", "hidden": false, "aggType": "SUM" }, { "name": "RUNTIME", "hidden": false, "aggType": "SUM" }, { "name": "VOTE_COUNT", "hidden": false, "aggType": "SUM" }, { "name": "VOTE_AVERAGE", "hidden": false, "aggType": "SUM" }, { "name": "OVERVIEW", "hidden": true, "aggType": "MAX" }], "name": "汇总" }, { "id": "select3", "type": "Select", "inputNodes": ["agg2"], "fields": ["GENRES_ID", { "name": "HZZD", "comment": "汇总字段", "dataType": "string", "len": 3, "folder": "dimensions" }, "POPULARITY", "BUDGET", "REVENUE", "RUNTIME", "VOTE_COUNT", "VOTE_AVERAGE", { "name": "PM", "comment": "排名", "dataType": "int", "len": 38, "folder": "measures" }], "filter": [{ "field": "PM", "operator": "<=", "value": "5" }], "steps": [{ "type": "AddField", "addField": { "name": "PM", "comment": "排名", "dataType": "int", "len": 38, "dim": false, "exp": "RANK(REVENUE,'desc')", "folder": "measures", "extractable": true } }, { "type": "AddField", "addField": { "name": "HZZD", "comment": "汇总字段", "dataType": "string", "len": 3, "dim": true, "exp": "'A'", "folder": "dimensions", "extractable": true } }], "name": "列加工" }, { "id": "join1", "type": "Join", "inputNodes": ["select3", "select2"], "fields": [{ "name": "GENRES_ID", "source": "select3.GENRES_ID" }, { "name": "HZZD", "source": "select3.HZZD" }, { "name": "HZZD1", "comment": "汇总字段(1)", "source": "select2.HZZD" }, { "name": "POPULARITY", "source": "select3.POPULARITY" }, { "name": "BUDGET", "source": "select3.BUDGET" }, { "name": "REVENUE", "source": "select3.REVENUE" }, { "name": "RUNTIME", "source": "select3.RUNTIME" }, { "name": "VOTE_COUNT", "source": "select3.VOTE_COUNT" }, { "name": "VOTE_AVERAGE", "source": "select3.VOTE_AVERAGE" }, { "name": "PM", "source": "select3.PM" }, { "name": "REVENUE1", "comment": "票房(1)", "source": "select2.REVENUE" }], "joinConditions": [{ "leftTable": "select3", "rightTable": "select2", "joinType": "LeftJoin", "clauses": [{ "field": "select3.HZZD", "operator": "=", "value": "=select2.HZZD" }] }], "name": "关联" }, { "id": "select4", "type": "Select", "inputNodes": ["join1"], "fields": [{ "name": "GENRES_ID", "hidden": false }, { "name": "HZZD", "hidden": true }, { "name": "HZZD1", "hidden": true }, { "name": "POPULARITY", "hidden": false }, { "name": "BUDGET", "hidden": false }, { "name": "REVENUE", "hidden": false }, { "name": "RUNTIME", "hidden": false }, { "name": "VOTE_COUNT", "hidden": false }, { "name": "VOTE_AVERAGE", "hidden": false }, { "name": "PM", "hidden": false }, { "name": "REVENUE1", "hidden": false }], "steps": [{ "fields": ["REVENUE1"], "type": "Refactor", "refactor": { "rename": "总票房" } }], "name": "列加工3" }, { "id": "default", "type": "Output", "inputNodes": ["select4"], "fields": ["GENRES_ID", "POPULARITY", "BUDGET", "REVENUE", "RUNTIME", "VOTE_COUNT", "VOTE_AVERAGE", "PM", "REVENUE1"], "name": "模型输出" }], "referenceResources": { "FILM_DIM_GENRES": { "targetType": "METAFILE", "targetPath": "$DATA:/行业/电影模型/dim/FILM_DIM_GENRES.tbl", "refType": "link" }, "FILM_F_GENRES_INFO": { "targetType": "METAFILE", "targetPath": "$DATA:/行业/电影模型/fact/FILM_F_GENRES_INFO.tbl", "refType": "query", "srcComponent": "modeltable1", "srcProperty": "moduleTablePath" }, "FILM_F_MAJOR": { "targetType": "METAFILE", "targetPath": "$DATA:/行业/电影模型/fact/FILM_F_MAJOR.tbl", "refType": "link" }, "FILM_DIM_LANGUAGE": { "targetType": "METAFILE", "targetPath": "$DATA:/行业/电影模型/dim/FILM_DIM_LANGUAGE.tbl", "refType": "link" } } } } } }