Dashboard creation system, dashboard creation method, and dashboard creation program

Abstract

To provide a dashboard creation system that can reduce a cost in designing a dashboard by limiting analysis operation to clicking a chart and analysis processing to extraction and emphasis.SOLUTION: A dashboard creation system according to the embodiment includes: setting means that sets, according to operation of a developer on a setting screen, data of an extraction event master for registering a chart, a click event, and an extraction event in association with one another, and an emphasis event master for registering a chart, a click event, and an emphasis event in association with one another; and display control means that refers, when a click event on a chart occurs, to the extraction event master to execute extraction processing, and also refers to the emphasis event master to execute emphasis processing.SELECTED DRAWING: Figure 1

Description

Technical Field

[0001] The present invention relates to a dashboard creation system, a dashboard creation method, and a dashboard creation program.

Background Art

[0002] In BI tools and business management systems, a management screen that integrates and displays various data indicating the status of corporate activities is called a "dashboard". Conventionally, as a system for developing a dashboard, for example, there is Patent Document 1.

Prior Art Documents

Patent Documents

[0003]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0004] However, Patent Document 1 does not describe anything regarding reducing the cost at the time of designing a dashboard by limiting the analysis operation to clicking on a chart and limiting the analysis process to extraction / emphasis.

[0005] The present invention has been made in view of the above problems, and an object thereof is to provide a dashboard creation system, a dashboard creation method, and a dashboard creation program capable of reducing the cost at the time of designing a dashboard by limiting the analysis operation to clicking on a chart and limiting the analysis process to extraction / emphasis.

Means for Solving the Problems

[0006] In order to solve the above-described problems and achieve the object, the present invention is a dashboard creation system including a control unit, wherein the control unit includes an extraction event master that associates and registers a chart, a click event, and an extraction event according to an operation of a developer on a setting screen, a setting means for setting data of an emphasis event master that associates and registers a chart, a click event, and an emphasis event, and a display control means that, when a click event on a chart occurs, refers to the extraction event master to execute an extraction process and refers to the emphasis event master to execute an emphasis process.

[0007] Further, according to an aspect of the present invention, the target of the extraction process and the emphasis process may be business data for outlier determination.

[0008] Further, according to an aspect of the present invention, the setting screen may be a GUI.

[0009] Further, according to an aspect of the present invention, the control unit is configured to be able to access a chart master that associates and registers a chart ID, a chart name, a chart type ID, and a data acquisition ID, a graph / map master that associates and registers a chart ID and a graph / map creation definition, a data acquisition master that associates and registers a data acquisition ID, a data acquisition name, and a stored procedure name, a data acquisition column master that associates and registers a data acquisition ID, a column number, and a column name, and business data for outlier determination. The extraction event of the extraction event master includes an extraction data value ID, an extraction target chart ID, and an extraction target column number. The display control means, when a click event on a chart occurs, acquires the clicked chart ID, click type, and acquirable value, and refers to the chart master, the graph / map master, the data acquisition master, the data acquisition column master, and the extraction event master to draw a graph / map and execute an extraction process.

[0010] Further, according to one aspect of the present invention, the display control means may display, in the title of the drawn graph or map, the value used for extraction of the extraction target column of the extraction event master.

[0011] Further, according to one aspect of the present invention, the highlighting event of the highlighting event master includes a highlighted chart ID, a highlighted item ID, a highlighting condition data value ID, a color of the target, a color of the non-target, a transparency of the target, and a transparency of the non-target, and the display control means may execute a highlighting process on the drawn graph or map with reference to the highlighting event master.

[0012] Also, in order to solve the above-described problems and achieve the object, the present invention is a dashboard creation method executed by an information processing apparatus including a control unit, and includes, in the control unit, an extraction event master that associates and registers a chart, a click event, and an extraction event in response to an operation of a developer on a setting screen, and a setting step of setting data of a highlighting event master that associates and registers a chart, a click event, and a highlighting event, and a display control step of, when a click event on a chart occurs, executing an extraction process with reference to the extraction event master and executing a highlighting process with reference to the highlighting event master.

[0013] Also, in order to solve the above-described problems and achieve the object, the present invention is a dashboard creation program for causing an information processing apparatus including a control unit to execute, and includes, in the control unit, an extraction event master that associates and registers a chart, a click event, and an extraction event in response to an operation of a developer on a setting screen, and a setting step of setting data of a highlighting event master that associates and registers a chart, a click event, and a highlighting event, and a display control step of, when a click event on a chart occurs, executing an extraction process with reference to the extraction event master and executing a highlighting process with reference to the highlighting event master, and is characterized in that it is a dashboard creation program for causing the above to be executed.

Effect of the Invention

[0014] According to the present invention, by limiting the analysis operation to a chart click and limiting the analysis process to extraction and highlighting, it is possible to reduce the cost at the time of dashboard design, which has the effect of reducing the cost.

Brief Description of the Drawings

[0015]

Figure 1

Figure 2

Figure 3

Figure 4

Figure 5

Figure 6

Figure 7

Figure 8

Figure 9

Figure 10

Figure 11

Figure 12

Figure 13

Figure 14

Figure 15

Figure 16

Figure 17

Figure 18

Figure 19

Figure 20

Figure 21

Figure 22

Figure 23

Figure 24

Figure 25

Figure 26

Figure 27

Figure 28

Figure 29

Figure 30

Figure 31

Figure 32

Figure 33

Figure 34

Figure 35

Figure 36

Figure 37

Figure 38

Figure 39

Figure 40

Figure 41

Figure 42

Figure 43

Figure 44

Figure 45

Figure 46

Figure 47

Figure 48

Figure 49

Figure 50

Figure 51

Figure 52

Figure 53

Figure 54

Figure 55

Figure 56

Figure 57

Figure 58

Figure 59

Figure 60

Figure 61

Figure 62

MODE FOR CARRYING OUT THE INVENTION

[0016] Embodiments of the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited to these embodiments.

[0017] [1. Overview] Conventionally, when developing a dashboard, there are the following two problems. The first is that since the design of the operation flow line of the dashboard has a high degree of freedom, specialized knowledge is required. To perform efficient determination result analysis, a dashboard with an appropriate operation flow line designed is necessary. However, there are many possible operation flow lines, and due to the high degree of freedom, the design is difficult. Therefore, knowledge of UI / UX is required for the design.

[0018] The second is that development by programming occurs for each dashboard. Since appropriate operation flow lines are different for each determination method, it is necessary to develop a dashboard for each determination method. In this case, a development process is required every time a dashboard is designed, and the cost becomes enormous.

[0019] Therefore, in the present invention, the operation flow line of the dashboard is restricted to only those necessary for outlier determination analysis and generalized. Also, the operation flow line can be set in the GUI.

[0020] As a result, it becomes possible to reduce the cost at the time of design by limiting the analysis operation to clicking on the chart and limiting the analysis process to extraction / emphasis. Also, by enabling the setting of the operation flow line on the GUI, it becomes possible to reduce the development cost.

[0021] The dashboard creation system of the present invention is applicable to all industries and all business types.

[0022] [2. Configuration] FIG. 1 is a diagram showing an outline of the configuration of a dashboard creation system (Web server) 100 according to the present embodiment. In FIG. 1, the dashboard creation system (Web server) 100, a developer terminal (client) 400..., and a server 200 are connected to a network 300 and are configured to be able to communicate with each other. Hereinafter, the dashboard creation system 100 may be referred to as the "Web server", and the developer terminal 400 may be referred to as the "client".

[0023] The dashboard creation system 100 provides a platform (tool) for dashboard development to the developer terminal 400... and provides a setting screen (for example, a web page) for generating a dashboard.

[0024] The developer terminal 400... is for the developer to access the dashboard creation system 100 and create a dashboard. The developer terminal 400... performs operations on the setting screen provided by the dashboard creation system 100 using, for example, a browser.

[0025] The dashboard creation system 100 is, for example, a workstation or a commercially available desktop personal computer.

[0026] As shown in FIG. 1, the dashboard creation system 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each unit included in the dashboard creation system 100 is communicably connected via an arbitrary communication path.

[0027] The communication interface unit 104 communicably connects the dashboard creation system 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via a communication line. Here, the network 300 has a function of communicably connecting the dashboard creation system 100 and the developer terminal 400... the server 200 to each other, and is, for example, the Internet or a LAN (Local Area Network).

[0028] An input / output interface unit 108 has an input device 112 and an output device 114 connected thereto. As the output device 114, in addition to a monitor (including a home TV), a speaker or a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that cooperates with the mouse to realize a pointing device function can be used. Hereinafter, the output device 114 may be described as the monitor 114, and the input device 112 may be described as the keyboard 112 or the mouse 112.

[0029] The storage unit 106 stores various databases (DBs), tables, and files. The storage unit 106 records a computer program for giving commands to the CPU (Central Processing Unit) in cooperation with the OS (Operating System) to perform various processes. As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, and an optical disk can be used. The storage unit 106 includes a DB 106a.

[0030] DB106a includes a chart type master 106a1, a chart emphasis item master 106a2, a chart type - emphasis item mapping master 106a3, a chart click event master 106a4, a chart type - click event mapping master 106a5, a chart click event available value master 106a6, a dashboard definition master 106a7, a data acquisition master 106a8, a data acquisition column master 106a9, a chart layout master 106a10, a chart master 106a11, a line graph master 106a12, a bar graph master 106a13, a stacked bar graph master 106a14, a surface graph master 106a15, a stacked surface graph master 106a16, a pie graph master 106a17, a scatter plot master 106a18, a heat map master 106a19, a horizontal bar graph master 106a20, a table column header master 106a21, an extraction event master 106a22, an emphasis event master 106a23, a data source 106b, and a data file 106c.

[0031] The data source 106b is, for example, business data for outlier determination. The business data for outlier determination is used during extraction processing and emphasis processing.

[0032] The control unit 102 is a CPU or the like that comprehensively controls the dashboard creation system 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs defining various processing procedures, and required data, and executes various information processes based on these stored programs.

[0033] The control unit 102 is configured to be able to access the DB106a stored in the storage unit 106. Note that the DB106a may be provided in another location (for example, the server 200) as long as the control unit 102 can access it.

[0034] Conceptually in terms of functions, the control unit 102 includes a setting unit 102a and a display control unit 102b.

[0035] The setting unit 102a associates and registers a chart, a click event, and an extraction event according to the developer's operations on the setting screen provided to the developer terminal 400, and sets the data of the extraction event master 106a22 and the highlighting event master 106a23 that associates and registers a chart, a click event, and a highlighting event, creates the extraction event master 106a22 and the highlighting event master 106a23, and registers them in the DB 106a. The target of the extraction process and the highlighting process may be the business data for outlier determination. Also, the setting screen may be a GUI.

[0036] When a click event on a chart occurs, the display control unit 102b refers to the extraction event master 106a22 and executes an extraction process, and also refers to the highlighting event master 106a23 and executes a highlighting process.

[0037] The extraction event of the extraction event master may include an extraction data value ID, an extraction target chart ID, and an extraction target column number. When a click event on a chart occurs, the display control unit 102b acquires the clicked chart ID, click type, and obtainable value, and refers to the chart master 106a11, the graph / map master (a general term for the line graph master 106a12, bar graph master 106a13, stacked bar graph master 106a14, area graph master 106a15, stacked area graph master 106a16, pie chart master 106a17, scatter plot master 106a18, heat map master 106a19, horizontal bar graph master 106a20), the data acquisition master 106a8, the data acquisition column master 106a9, and the extraction event master 106a22, and may draw a graph / map and execute an extraction process.

[0038] The display control unit 102b may display the value used for the extraction of the extraction target column of the extraction event master 106a22 in the title of the drawn graph / map.

[0039] In addition, the highlighted events in the highlighted event master 106a23 may include the highlighted chart ID, highlighted item ID, highlighted condition data value ID, color of the target, color of non-target, transparency of the target, and transparency of non-target. The display control unit 102b may execute a highlighting process on the drawn graph / map by referring to the highlighted event master 106a23.

[0040] [3. Specific Example] A specific example of the processing of the control unit 102 of the dashboard creation system 100 according to the present embodiment will be described with reference to FIGS. 2 to 62.

[0041] [3-1. Overall Processing Flow] Here, with reference to FIG. 2, an example of the overall processing of the control unit 102 of the dashboard creation system 100 in the present embodiment will be described. FIG. 2 is a flowchart showing an example of the overall processing of the control unit 102 of the dashboard creation system 100 in the present embodiment.

[0042] The setting unit 102a executes a dashboard setting process (step S1). Specifically, in the dashboard setting process, the setting unit 102a associates and registers a chart, a click event, and an extraction event in the extraction event master 106a22 according to the developer's operation on the setting screen provided to the developer terminal 400, and sets the data of the highlighting event master 106a23 that associates and registers a chart, a click event, and a highlighting event, creates the extraction event master 106a22 and the highlighting event master 106a23, and registers them in the DB106a. The target of the extraction process and the highlighting process may be business data for outlier determination. Also, the setting screen may be a GUI.

[0043] The display control unit 102b executes a preview process (step S2). Specifically, in the preview process, when a click event on the chart occurs, the display control unit 102b refers to the extraction event master 106a22 and executes an extraction process, and also refers to the highlighting event master 106a23 and executes a highlighting process.

[0044] In this case, the extraction event of the extraction event master may include an extraction data value ID, an extraction target chart ID, and an extraction target column number. When a click event occurs for a chart, the display control unit 102b acquires the clicked chart ID, click type, and obtainable value, and refers to the chart master 106a11, graph / map master, data acquisition master 106a8, data acquisition column master 106a9, and extraction event master 106a22, and may draw a graph / map and execute an extraction process.

[0045] Also, the display control unit 102b may display the value used for extraction of the extraction target column of the extraction event master 106a22 in the title of the drawn graph / map.

[0046] Also, the highlighting event of the highlighting event master 106a23 may include a highlighting target chart ID, a highlighting target item ID, a highlighting condition data value ID, a color of the target, a color of the non-target, a transparency of the target, and a transparency of the non-target. The display control unit 102b may refer to the highlighting event master 106a23 and execute a highlighting process on the drawn graph / map.

[0047] [3-2. Point] The points of the dashboard creation system 100 will be described with reference to FIGS. 3 to 18. FIG. 3 is a diagram showing an example of a dashboard. The dashboard shown in FIG. 3 consists of three charts. Figure 1 aggregates the sales amounts by person in charge and month, and shows the trend for each person in charge. Figure 2 shows the monthly sales amounts only for a specific person in charge. Figure 3 shows, in a heat map, the sales amounts by person in charge and payee for a specific year and month.

[0048] For example, in Figure 1, the sales amount of Person in Charge B in March 2021 is prominent. Therefore, it is assumed that the analyst will conduct a more detailed analysis of this data. Specifically, it is desired to extract the data of Person in Charge B in Figure 2. It is desired to extract the data of Person in Charge B in March 2021 in Figure 3. It is desired to emphasize Person in Charge B in Figure 1. It is desired to emphasize March 2021 in Figure 1. It is desired to emphasize March 2021 in Figure 2.

[0049] The measures for this will be explained separately in (1) the behavior of the dashboard and (2) the settings of the dashboard.

[0050] (1) Regarding the behavior of the dashboard, the following measures were taken. 1. The candidates for processing by dashboard operations were narrowed down to only those necessary for outlier determination analysis. 2. The methods of dashboard operations were narrowed down to only those necessary and sufficient for outlier determination analysis. 3. Devising the method of expressing the selected data.

[0051] 1. Explain in detail the fact that the candidates for processing by dashboard operations were narrowed down to only those necessary for outlier determination analysis. In the present invention, the processing by operations was narrowed down to two patterns ("extraction" and "emphasis") necessary for outlier determination analysis, and the locations to be highlighted and the highlighting methods were patterned.

[0052] "Extraction" means narrowing down a specific column in the data source of a chart by a specific value and displaying it. Referring to FIGS. 4 and 5, "extraction" will be explained. In the dashboard example, as shown in FIG. 4, Figure 2-1 displays only the data whose "person in charge code" column has the value of T001 among the sales data of all persons in charge in the data source.

[0053] On the other hand, when it is desired to display for Person in Charge B who is the focus, it is displayed as in Figure 2-2 of FIG. 5.

[0054] "Emphasis" means to display the data of the target of interest darker on the chart to make it stand out, or conversely, to display the data outside the target of interest lighter so that it does not stand out. Referring to FIG. 6, "emphasis" will be explained. FIG. 6 is a diagram showing an example of patternization of emphasis. In FIG. 6, single bar graph, stacked bar graph, grouped bar graph, line graph, area graph For stacked area graph, scatter plot, pie chart, heat map, horizontal bar graph, it shows whether x-axis emphasis, legend emphasis, bar emphasis, point emphasis, cell emphasis, row emphasis can be set.

[0055] Note that grouped bar graphs are not used. Since the bars of multiple series (legends) are jumbled up, it is inappropriate as a graph representation of the abnormal determination result and is therefore unnecessary.

[0056] X-axis emphasis specifies the background color / transparency of the target x-axis. Legend emphasis specifies the color / transparency of the target legend and the legend outside the target. Point emphasis specifies the color / transparency of the target points. Bar emphasis specifies the color / transparency of the target bars and the bars outside the target. Cell emphasis specifies the background color / transparency of the target cells. Row emphasis specifies the background color / transparency of the target rows.

[0057] FIG. 7 and FIG. 8 are diagrams showing examples of emphasis on the dashboard. FIG. 7 shows before emphasis, and FIG. 8 shows after emphasis.

[0058] 2. The method of dashboard operation is limited to only what is necessary and sufficient for outlier determination analysis will be explained. In the present invention, since the necessary and sufficient operations can be performed when focusing on outlier determination analysis, the operation method is limited to the click events of the charts, the click events that can be set in each chart are limited, and the values that can be obtained in each click event are limited. Also, the settings of click events and the values to be obtained can be set in the GUI.

[0059] The reason for limiting the operation method to click events is to enable intuitive operation of the dashboard.

[0060] Figure 9 shows each click event (x-axis click, legend click, bar click, point click, cell click) that can be set in each chart, and the values (x-axis value, legend code, legend value, row number) that can be obtained with each click event. With an x-axis click, the x-axis value can be obtained; with a legend click, the legend code, legend value can be obtained; with a bar click, the x-axis value, legend code, legend value can be obtained; with a point click, the x-axis value, legend code, legend value can be obtained; with a cell click, the row number can be obtained.

[0061] Figures 10 to 13 illustrate examples of values that can be obtained with click events. For example, in Figure 10, with the click event "legend click", if, for example, Person in Charge B is clicked, the legend code "T002" and the legend value "Person in Charge B" can be obtained. With the click event "x-axis click", if, for example, the x-axis near May 2021 is clicked, the x value "May 2021" can be obtained. With the click event "point click", if, for example, the point near March 2021 on the graph of Person in Charge B is clicked, the legend code "T002", the legend value "Person in Charge B", and the x value "March 2021" can be obtained.

[0062] 3. Explain the contrivance of the expression method of the data selected as the extraction condition. In the present invention, when the data source of the chart is extracted according to the data selection state, the condition value used for extraction is displayed in the chart title, and the extraction condition is automatically displayed in the title. Figure 14 shows an example of the display before and after selection. In Figure 14, after selection, "Person in Charge B" used for extraction is displayed.

[0063] (2) Regarding the dashboard settings Explain "the contrivance of the UI operability of the dashboard design screen". In response to simplifying the above dashboard representation and operation method, the following points were contrived to make it easier to design them more efficiently. In the present invention, it is made possible to set on the GUI, and by generalizing the setting flow, it is made possible to set on one screen regardless of the type of chart. Furthermore, it is made possible to confirm the setting content by preview display.

[0064] In this dashboard creation system 100, the setting process is generalized as follows. 1. Select the chart to be set. 2. Select the click event to be set. 3. Select, from extraction and highlighting, the process that each chart performs at the clicked timing. 4. (1) In the case of extraction, select the extraction target column and the extraction value. The extraction target column is selected from the data source of the chart. The extraction value is selected from the values that can be obtained by the click event. (2) In the case of highlighting, select the highlighting item, the highlighting method, the column for narrowing down the highlighting target, and the value for narrowing down the highlighting target. The highlighting item and the highlighting method are selected from the options determined for each chart. The column for narrowing down the highlighting target is selected from the data source of the chart. The value for narrowing down the highlighting target is selected from the values that can be obtained by the click event.

[0065] Figure 15 shows an example of an extraction settings screen. In Figure 15, in area A1, select the chart you want to set. In area A2, select the event click you want to set. The UI is simplified by making the event only a click. Although the selectable click events differ for each chart type, they can be displayed in tabular form by generalization. As a result, various types of charts can be set on one screen, reducing the learning cost of operating the settings screen. In area A3, in 3., you can select from extraction / emphasis for the processing performed by each chart. In the same figure, extraction is selected. In area A3, in 4. (1) In the case of extraction, select the extraction target column and the extraction value. The extraction target column is selected from the data source of the chart. The extraction value is selected from the values that can be obtained by the click event. Although the available items differ for each chart type × click event, they can be displayed in tabular form by generalization. As a result, various types of chart type × click event settings can be made on one screen, reducing the learning cost of operating the settings screen. In area A4, the set content can be previewed and its operation can be confirmed. This makes it easier to create a dashboard as expected by the setter.

[0066] Figure 16 shows an example of an emphasis settings screen. Explanation common to Figure 15 is omitted. In area A3, emphasis is selected. In area A3, in 4. (2) In the case of emphasis, select the emphasis location, the method of emphasis, the column for narrowing down the emphasis target, and the value for narrowing down the emphasis target. "Item name" selects the item of the chart you want to emphasize. "Used item" sets the value used to extract the emphasis target. "Emphasis target" sets the color and transparency of the data you want to focus on. "Outside the emphasis target" sets the color and transparency of the data you do not want to focus on.

[0067] The item name and used item differ in selectable items depending on the chart type and click event, but they can be displayed in tabular form by generalization. As a result, various types of chart type × click event settings can be made on one screen, and the learning cost of operating the settings screen can be reduced.

[0068] Referring to FIGS. 17 and 18, an example of a preview will be described. FIG. 17 shows an example of a screen before clicking. In FIG. 17, when clicking on the point of "Person in Charge B × 2021 / 03" in Figure 1, a screen as shown in FIG. 18 is displayed. In FIG. 18, in Figure 1, regarding highlighting, based on the legend code (= the code of Person in Charge B) obtained at the clicked point, the legends other than Person in Charge B become transparent with a transparency of 200. Based on the x value (= 2021 / 03) obtained at the clicked point, the x-axis of 2021 / 03 is displayed in gray.

[0069] In Figure 2, regarding highlighting, based on the x value (= 2021 / 03) obtained at the clicked point, the x-axis of 2021 / 03 is displayed in gray, and the transparency of the bars other than 2021 / 03 becomes 200. Regarding extraction, based on the legend code (= the code of Person in Charge B) obtained at the clicked point, extraction is performed on the person-in-charge code column of the data source in Figure 2, and only Person in Charge B is displayed. Also, the extraction condition value of "Person in Charge B" is displayed in the title part.

[0070] In Figure 3, regarding extraction, based on the legend code (= the code of Person in Charge B) obtained at the clicked point, extraction is performed on the person-in-charge code column of the data source in Figure 3, and only Person in Charge B is displayed. Based on the x value (= 2021 / 03) obtained at the clicked point, extraction is performed on the fiscal year and month column of the data source in Figure 3, and only 2021 / 03 is displayed. The extraction condition value of "2021 / 03 Person in Charge B" is displayed in the title part.

[0071] "3-3. Master Configuration" Referring to FIGS. 19 to 41, the master configuration of the dashboard creation system 100 will be described. The masters include a master of unified behavior settings predefined by the system, tables that need to be preconfigured, and masters set in this embodiment, which will be described in the following order. FIGS. 19 to 41 are diagrams showing configuration examples of each master.

[0072] (Master of Unified Behavior Settings Predefined by the System) The chart type master 106a1 is a master for managing the types of charts. As shown in FIG. 19, it can be composed of a table or the like in which a chart type ID and a chart type name are registered in association with each other. In the example shown in the figure, the first row has a chart type ID of "Bar" and a chart type name of "Single bar graph".

[0073] The chart emphasis item master 106a2 is a master for managing the emphasisable items of charts. As shown in FIG. 20, it can be composed of a table or the like in which an emphasis item ID and an emphasis item name are associated and registered. In the example shown in the figure, the first row has an emphasis item of "IDXAxisHighlight" and an emphasis item name of "x-axis emphasis".

[0074] The chart type emphasis item mapping master 106a3 is a master for managing which items of the chart emphasis item master can be used for each chart type of the chart type master. As shown in FIG. 21, it can be composed of a table or the like in which a chart type ID and an emphasis item ID are associated and registered. In the example shown in the figure, the first row has a chart type ID of "Bar" and an emphasis item ID of "XAxisHighlight".

[0075] The chart click event master 106a4 is a master for managing click events. As shown in FIG. 22, it can be composed of a table or the like in which a click event ID and a click event name are associated and registered. In the example shown in the figure, the first row has a click event ID of "XAxisClick" and a click event name of "x-axis click".

[0076] The chart type click event mapping master 106a5 is a master for managing which click events of the chart click event master can be used for each chart type of the chart type master. As shown in FIG. 23, it can be composed of a table or the like in which a chart type ID and a click event ID are associated and registered. In the example shown in the figure, the first row has a chart type ID of "Bar" and a click event ID of "XAxisClick".

[0077] The chart click event acquirable value master 106a6 is a master for managing the values that can be acquired for each click event in the chart click event master. As shown in FIG. 24, it can be composed of a table or the like in which a click event ID, an acquirable value ID, and an acquirable value name are associated and registered. In the example shown in the figure, the first row has a click event ID of "XAxisClick", an acquirable value ID of "XValue", and an acquirable value name of "x value".

[0078] (Master that needs to be set in advance) The dashboard definition master 106a7 is a master for managing dashboard definitions. As shown in FIG. 25, it can be composed of a table or the like in which a dashboard definition ID, a dashboard name, and an abnormal judgment definition ID are associated and registered. In the example shown in the figure, the first row has a dashboard definition ID of "Dashboard1", a dashboard name of "Dashboard 1", and an abnormal judgment definition ID of "AbnormalJudgement1".

[0079] The data acquisition master 106a8 is a master for managing data acquisition definitions. As shown in FIG. 26, it can be composed of a table or the like in which a data acquisition ID, a data acquisition name, and a stored procedure name are associated and registered. Here, the "data acquisition ID" is an ID that uniquely determines the data acquisition definition, the "data acquisition name" is the name of the data acquisition definition, and the "stored procedure name" is the name of the stored procedure executed in the data acquisition definition. In the example shown in the figure, the first row has a data acquisition ID of "DataSelection1", a data acquisition name of "Sales amount by person in charge x accounting month", and a stored procedure name of "StoredProcedure1".

[0080] The data acquisition column master 106a9 is a master for managing column information acquired in each definition of the data acquisition definition master 106a8, and as shown in FIG. 27, it can be composed of a table or the like in which a data acquisition ID, a column number, and a column name are registered in association with each other. The "data acquisition ID" is the ID of the data acquisition definition master and represents the data of the associated data acquisition master 106a8. The "column number" is a sequential number. The "column name" is the name of the column. In the example shown in the figure, the first row has a data acquisition ID of "DataSelection1", a column number of "0", and a column name of "Accounting year and month".

[0081] The chart layout master 106a10 is a master for managing the chart layout on the dashboard, and as shown in FIG. 28, it can be composed of a table or the like in which a dashboard definition ID, a chart ID, Top, Left, width, and height are registered in association with each other. The "dashboard definition ID" is the ID of the dashboard definition on which the chart is to be arranged. The "chart ID" is the ID of the chart definition to be arranged on the dashboard. "Top" is the vertical position at the time of chart layout and specifies the distance from the upper end. "Left" is the horizontal position at the time of chart layout and specifies the distance from the left end. "Width" is the width of the chart. "Height" is the height of the chart. In the example shown in the figure, the first row has a dashboard definition ID of "Dashboard1", a chart ID of "Figure1", Top of "0px", Left of "0px", width of "300px", and height of "100px".

[0082] The chart master 106a11 is a master for managing chart definitions. As shown in FIG. 29, it can be composed of a table or the like that registers by associating a chart ID, a chart name, a chart type ID, and a data acquisition ID. The "chart ID" is an ID that uniquely determines the chart definition. The "chart name" is the name of the chart definition and is used as a title. The "chart type ID" is the ID of the chart type master and represents the chart type of the chart definition. The "data acquisition ID" is the ID of the data acquisition master and represents the data acquisition definition used as the data source of the chart definition. In the example shown in the same figure, the first row has a chart ID of "Figure1", a chart name of "Sales amount trend by person in charge", a chart type ID of "Polyline", and a data acquisition ID of "DataSelection1".

[0083] The line graph master 106a12 is a master for managing the definitions related to line graphs among the chart definitions. As shown in FIG. 30, it can be composed of a table or the like that registers by associating a chart ID, an x-axis data column number, a y-axis data column number, a legend code data column number, and a legend value data column number. The "chart ID" is the ID of the record in the chart master to which the line graph definition is linked. The "x-axis data column number" is the number of the column used for the x-axis in the data source. The "y-axis data column number" is the number of the column used for the y-axis in the data source. The "legend code data column number" is the number of the column used for the legend code in the data source. The "legend value data column number" is the number of the column used for the legend value in the data source. In the example shown in the same figure, the first row has a chart ID of "Figure1", an x-axis data column number of "0: Accounting year and month", a y-axis data column number of "3: Sales amount", a legend code data column number of "1: Person in charge code", and a legend value data column number of "2: Person in charge name".

[0084] The bar graph master 106a13 is a master for managing definitions related to bar graphs among chart definitions. As shown in FIG. 31, it can be composed of a table or the like in which a chart ID, an x-axis data column number, and a y-axis data column number are registered in association. In the example shown in the figure, the first row has a chart ID of "Figure 2", an x-axis data column number of "0: Accounting year and month", and a y-axis data column number of "3: Sales amount".

[0085] The stacked bar graph master 106a14 is a master for managing definitions related to stacked bar graphs among chart definitions. As shown in FIG. 32, it can be composed of a table or the like in which a chart ID, an x-axis data column number, a y-axis data column number, a legend code data column number, and a legend value data column number are registered in association.

[0086] The area graph master 106a15 is a master for managing definitions related to area graphs among chart definitions. As shown in FIG. 33, it can be composed of a table or the like in which a chart ID, an x-axis data column number, a y-axis data column number, a legend code data column number, and a legend value data column number are registered in association.

[0087] The stacked area graph master 106a16 is a master for managing definitions related to stacked area graphs among chart definitions. As shown in FIG. 34, it can be composed of a table or the like in which a chart ID, an x-axis data column number, a y-axis data column number, a legend code data column number, and a legend value data column number are registered in association.

[0088] The pie chart master 106a17 is a master for managing definitions related to pie charts among chart definitions. As shown in FIG. 35, it can be composed of a table or the like in which a chart ID, a value data column number, a legend code data column number, and a legend value data column number are registered in association.

[0089] The scatter diagram master 106a18 is a master for managing the definitions related to scatter diagrams among the chart definitions. As shown in FIG. 36, it can be composed of a table or the like in which a chart ID, an x-axis data column number, a y-axis data column number, a legend code data column number, and a legend value data column number are registered in association with each other.

[0090] The heat map master 106a19 is a master for managing the definitions related to heat maps among the chart definitions. As shown in FIG. 37, it can be composed of a table or the like in which a chart ID, an x-axis data column number, and a gradation data column number are registered in association with each other. In the example shown in the same figure, the first row has a chart ID of "Figure3", an x-axis data column number of "4: Payee Name", and a gradation data column number of "5: Sales Amount".

[0091] The horizontal bar graph master 106a20 is a master for managing the definitions related to horizontal bar graphs among the chart definitions. As shown in FIG. 38, it can be composed of a table or the like in which a chart ID, an x-axis data column number, and a gradation data column number are registered in association with each other.

[0092] The table column header master 106a21 is a master for managing the column header information of the heat map master or the horizontal bar graph master. As shown in FIG. 39, it can be composed of a table or the like in which a chart ID, a column number, and a data column number are registered in association with each other. The "chart ID" is the ID of the record in the chart master to which the heat map definition or the horizontal bar graph definition is linked. The "column number" is a serial number and is used in the order of display as the column header. The "data column number" is the number of the column in the data source to be used as the column header. In the example shown in the same figure, the first row has a chart ID of "Figure3", a column number of "1", and a data column number of "1: Responsible person code".

[0093] (Master set in this embodiment) The extraction event master 106a22 is a master for managing extraction event definitions associated with each record of the chart definition master. As shown in FIG. 40, it can be composed of a table or the like in which a chart ID, a click event ID, an extraction data value ID, an extraction target chart ID, and an extraction target column number are registered in association with each other.

[0094] The "chart ID" is the ID of the chart definition that triggers the extraction event among the chart masters. The "click event ID" is the record ID in the chart click event master to which the extraction event definition is associated. The "extraction data value ID" is the ID of the obtainable value used in the extraction event among the chart click event obtainable value masters. The "extraction target chart ID" is the chart definition ID in the chart master for which extraction is executed in the extraction event. The "extraction target column number" is the number of the column for which extraction is executed among the data acquisition column masters (the data acquisition definition is obtained from the data acquisition definition ID column of the chart definition associated with the chart ID column). In the example shown in the same figure, the first row has a chart ID of "Figure1", a click event ID of "PointClick", an extraction data value ID of "LegendCode", an extraction target chart ID of "Figure2", and an extraction target column number of "1: person in charge code".

[0095] The emphasized event master 106a23 is a master for managing emphasized event definitions associated with each record in the chart master 106a11. As shown in FIG. 41, it can be composed of a table or the like that registers by associating a chart ID, a click event ID, an emphasized target chart ID, an emphasized target item ID, an emphasized condition data value ID, a color for the target, a color for non-target, a transparency for the target, and a transparency for non-target. The "chart ID" is the ID of the chart definition that triggers the emphasized event among the chart masters. The "click event ID" is the record ID in the chart click event master to which the emphasized event definition is associated. The "emphasized target chart ID" is the chart definition ID in the chart master for which emphasis is executed by the emphasized event. The "emphasized target item ID" is the chart emphasized item definition ID in the chart emphasized item master for which emphasis is executed by the emphasized event. The "emphasized condition data value ID" is the ID of the acquirable value used for extracting the emphasized target among the chart click event acquirable value masters. The "color for the target" is the color of the emphasized target. The "color for non-target" is the color of non-target of the emphasized target. The "transparency for the target" is the transparency of the emphasized target. The "transparency for non-target" is the transparency of non-target of the emphasized target. In the example shown in the same figure, the first row has a chart ID of "Figure1", a click event ID of "PointClick", an emphasized target chart ID of "Figure1", an emphasized target item ID of "LegendHighlight", an emphasized condition data value ID of "LegendCode", a transparency for the target of "0", and a transparency for non-target of "200".

[0096] [3-4. System Control] With reference to FIGS. 42 to 54, the system control of the dashboard creation system 100 will be described. In the system control, the flow of the setting screen for registering the masters shown in [3-3. Master Configuration] will be described.

[0097] FIG. 42 is a diagram showing an example of a screen transition diagram for the setting screens of "masters that need to be set in advance" and "masters set in this embodiment". On the dashboard definition setting screen, data acquisition definition setting screen, and chart setting / layout setting screen of FIGS. 42(A) to 42(C), the "masters that need to be set in advance" are set, and on the chart click setting screen of FIG. 42(D), the "masters set in this embodiment" are set. The characteristic screen of the present invention is the chart click setting screen.

[0098] With reference to FIGS. 43 to 54, the system control on the chart click setting screen will be described. It will be described in the order of (1) method for creating an extraction event master, (2) method for creating a highlighting event master, and (3) operation of the preview.

[0099] With reference to FIG. 43, (1) the method for creating an extraction event master will be described. FIG. 43 is a diagram showing a display example of the chart click setting screen for explaining the method for creating an extraction event master. In FIG. 43, in area A1, (1) select the chart for which a click event is to be set from the charts of chart master 106a11. In area A2, (2) the click events that can be selected from the chart type of the chart selected in (1) are displayed. Select the click event to be set from among these. In area A3, (3) select the chart for which extraction is to be performed when clicked from the selected chart. (4) Select the items for which extraction is to be performed from the list of data acquisition column definitions of the data acquisition definition associated with the selected chart. (5) From the content selected in (1) and (2), the chart type and click event are determined. Thereby, the acquirable items are displayed in a list, and the items to be used are selected.

[0100] In this way, by the operation on the chart click setting screen, for example, an extraction event master 102a22 as shown in FIG. 44 is created.

[0101] Referring to FIG. 45, (1) a method for creating an emphasized event master will be described. FIG. 45 is a diagram showing an example of a display of a chart click setting screen for explaining the method for creating an emphasized event master. In FIG. 45, the description of the parts common to FIG. 43 is omitted. In area A3, (3) select the chart for which emphasis is to be applied when clicked from the selected chart. (4) Display a list of emphasized parts from the chart type of the chart selected in (3), and select the part to be emphasized. (5) From the content selected in (1) and (2), the chart type and click event are determined. From this, the items that can be obtained are determined. Display a list of the items that can be obtained, and select the items to be used. (6) Set the emphasis method as target / non-target. Also, set it with color and transparency.

[0102] In this way, by operating on the chart click setting screen, for example, an emphasized event master 102a23 as shown in FIG. 46 is created.

[0103] Referring to FIGS. 47 to 54, the operation of the preview will be described. A preview is displayed in area A4 at the lower part of the chart click setting screen shown in FIG. 47. The preview is displayed based on the data acquisition definition, chart definition, extraction event definition, and emphasized event definition set so far.

[0104] The processing flow of the preview operation will be described. In the preview operation, the following processing is performed.

[0105] (1) When a chart is clicked, the clicked chart ID, click type, and selected value are sent to the web server. (2) Obtain the data of the extraction event master and emphasized event master from the chart ID and click type. (3) Obtain the chart definition and data acquisition definition of each chart. (4) Obtain the data for chart drawing from the data acquisition definition. (5) Extract the data for chart drawing using the extraction event master. (6) Create a chart from the data for chart drawing and the chart master. (7) Use the emphasized event master to change the style of the created chart.

[0106] Describe the details of each process.

[0107] (1) When a chart is clicked, send the clicked chart ID, click type, and selected value to the web server. For example, in Figure 48, when the point of the graph of Person B in the sales amount by person Figure 1 for March 2021 is clicked, the clicked chart ID "Figure 1", click event ID "PointClick (point click)", value that can be obtained "legend code → T002", legend value "Person B", x value "2021 / 03" are obtained and sent to the web server. The following processes are performed on the web server.

[0108] (2) Obtain the data of the extraction event master 106a22 and emphasized event master 106a23 from the chart ID and click type. For example, as shown in Figure 49, using the chart ID "Figure 1" and click event ID "PointClick (point click)" as keys, obtain the data of the first to third rows from the extraction event master 106a22 and the data of the first to fourth rows from the emphasized event master 106a23.

[0109] (3) Obtain the chart definition and data acquisition definition of each chart. The charts to be processed are Figure 1 to 3, but for simplicity of explanation, only Figure 2 will be described below as an example. For example, as shown in Figure 50, using the chart ID "Figure 2" as the key, obtain the data of the second row from the chart master 106a11 and the data of the first row from the bar graph master 106a13. Also, using the data acquisition ID "DataSelection1" obtained from the chart master 106a11 as the key, obtain the data of the first row from the data acquisition master 106a8 and the data of the first to fourth rows from the data acquisition column master 106a9.

[0110] (4) Obtain data for chart drawing from the data acquisition definition. For example, as shown in FIG. 51, using the stored procedure name "storedprocedure1" obtained from the data acquisition column master 106a9 as a key, identify the business data of the data source 106b, and from the identified business data, extract the data of the columns with column number "0", column name "Accounting Year / Month", column number "1", column name "Responsible Person Code", column number "2", column name "Responsible Person Name", column number "3", and column name "Sales Amount" obtained from the data acquisition column master 106a9 to obtain data for chart drawing.

[0111] (5) Use the extraction event master 106a22 to extract chart drawing data from the data for chart drawing. For example, as shown in FIG. 52, among the extraction event master 106a22, use the data with the extraction target chart ID = Figure2. Extract the data for chart drawing as follows. Among the extraction target column numbers of the extraction event master 106a22 = the selected value "1: Responsible Person Code", use the value "Responsible Person Code = T002" used for extraction in the extraction event master 106a22 to extract the data for chart extraction. Extract chart drawing data from the data for chart drawing using the extraction event master 106a22. For example, as shown in FIG. 52, among the extraction event master 106a22, use the data with the extraction target chart ID = Figure2. Extract the data for chart drawing as follows. Among the extraction target column numbers of the extraction event master 106a22 = the selected value "1: Responsible Person Code", use the value "Responsible Person Code = T002" used for extraction in the extraction event master 106a22 to extract the data for chart extraction.

[0112] (6) Create a chart from the data for chart drawing and the chart master 106a11. For example, as shown in FIG. 53, create a bar chart based on the chart master 106a11, the bar chart master 106a13, and the data for chart drawing, and the responsible person B (= T002) used for the extraction condition value is displayed in the chart title.

[0113] (7) Use the emphasis event master 106a23 to change the style of the created chart. For example, as shown in FIG. 54, since the emphasis event master 106a23 is set to have the target color as "#808080" and the transparency as "200", the x-axis part for March 2021 is displayed in semi-transparent gray. Also, since the transparency for non-target is set to "200", the bars other than March 2021 are drawn semi-transparently, and the bar for March 2021 is emphasized and displayed.

[0114] [3-5: Extraction / Emphasis Processing and Table Correspondence] Referring to FIGS. 55 to 62, in the dashboard creation system 100, the correspondence between the table on the extraction / emphasis setting screen and the data usage method at the time of executing extraction / emphasis in the preview will be described. Regarding the correspondence between the table on the setting screen, it will be described in the order of 1. Identification of click events, 2. When the extraction setting screen is displayed, 3. When the extraction setting screen is registered, 4. When the emphasis setting screen is displayed, and 5. When the emphasis setting screen is registered.

[0115] 1. Identification of click events will be described with reference to FIG. 55. The click event list is obtained as follows.

[0116] 1. In area A1, identify the chart ID corresponding to the "chart name" to be selected among the chart masters 102a11. In the example shown in the figure, "Figure1" is specified.

[0117] 2. Using the chart type ID of the chart master 102a11 corresponding to the identified chart ID as a key, obtain the click event ID from the chart type click event mapping master 106a5. In the example shown in the figure, using the chart type ID "Polyline" as a key, the click event IDs "XAxisClick, LegendClick, PointClick" are obtained from the chart type click event mapping master 106a5.

[0118] 3. Using the obtained click event ID as a key, obtain the click event name from the chart click event master 106a4 and display it in area 2. In the example shown in the figure, using the click event IDs "XAxisClick, LegendClick, PointClick" as keys, "Legend click, x-axis click, point click" are obtained from the chart click event master 106a4 and displayed in area 2.

[0119] 2. The display of the extraction settings screen will be described with reference to FIG. 56. In area A3 of the extraction settings screen, a list of available items is set. The list of available items includes items such as the chart name to be extracted, data column name, and extraction condition value usage item. The chart name to be extracted is selected from the chart IDs set in the chart master 106a11. The data column name is selected from the column names set in the data acquisition column master 106a9. The extraction condition value usage item is selected from the available values of the selected click event among the chart click event available value masters 106a6.

[0120] 3. The registration of the extraction settings screen will be described with reference to FIG. 57. In FIG. 57, when the OK button on the extraction settings screen is pressed, a registration process is executed, and the data of "chart ID", "click event ID", "extraction target chart ID", "extraction target column number", and "extraction data value ID" in the extraction event master 106a22 is obtained from the values on the screen and registered. Since the IDs (codes) corresponding to each value are held in the chart type click event mapping master 106a5 and the chart click event available value master 106a6, they are converted to codes during registration.

[0121] 4. The display of the highlighting settings screen will be described with reference to FIG. 58. The list of highlighting items in area A3 of the highlighting settings screen is set as follows.

[0122] The list of highlighting items in area A3 includes items such as the chart name to be highlighted, the item name to be highlighted, the highlighting condition value usage item, the highlighting style target (color, transparency), and the non-highlighting style target (color, transparency).

[0123] The chart name to be highlighted is selected from the chart IDs set in the chart master 106a11. The name of the item to be emphasized is specified by the chart type ID of the chart master 106a11 identified from the chart type emphasis item mapping master 106a3, and a list of emphasis item IDs is obtained. The list of emphasized location names is obtained and displayed by specifying with the emphasis item IDs obtained from the chart emphasis item master 106a2. The items for using the emphasis condition values are the same as those for obtaining the available items when "displaying the extraction setting screen" in FIG. 56.

[0124] 5. The registration time of the emphasis setting screen will be described with reference to FIG. 59. In FIG. 59, when the OK button on the emphasis setting screen is pressed, the registration process is executed, and the data of "chart ID", "click event ID", "chart ID to be emphasized", "item ID to be emphasized", "emphasis condition data value ID", "color of target", "color of non-target", "transparency of target", and "transparency of non-target" in the emphasis event master 106a23 are obtained from the values on the screen and registered. Since the IDs (codes) corresponding to each value are held in the chart type emphasis item mapping master 106a3 and the chart emphasis item master 106a2, they are converted to codes during registration.

[0125] The correspondence relationship during the execution of the preview will be described with reference to FIGS. 60 to 62. Hereinafter, as an example, the click on the point of "Person in Charge B × 2021 / 03" in Figure 1 described as "point" will be used. FIG. 60 shows the preview before clicking, and FIG. 61 shows the case where the click on the point of "Person in Charge B × 2021 / 03" in Figure 1 is executed.

[0126] The method for specifying the extraction target in the case of FIG. 60 will be described with reference to FIG. 61. 1. Specify the data of the extraction event master 106a22 from the chart ID and click event ID that have been clicked. 2. Among the chart masters 106a11, specify the chart definition of the extraction target in the extraction target chart ID column of the extraction event master 106a22 specified in 1. 3. Among the data acquisition masters 106a8, specify the data acquisition definition in the data acquisition ID column of the chart master 106a11 specified in 2. 4. Among the data acquisition column masters 106a9, specify the list of data acquisition column definitions in the data acquisition ID column of the data acquisition master 106a8 specified in 3. 5. Among the data acquisition column definitions specified in 4, specify the data acquisition column definition of the extraction target column in the extraction target column number column of the extraction event master 106a22 specified in 1.

[0127] The method for specifying the emphasis target in the case of FIG. 60 will be described with reference to FIG. 62. 1. Specify the data of the emphasis event master 106a23 from the chart ID and click event ID that have been clicked. 2. Among the chart masters 106a11, specify the chart definition of the emphasis target in the emphasis target chart ID column of the emphasis event master 106a23 specified in 1. 3. Among the chart type emphasis item mapping masters 106a3, specify the list of the chart type emphasis item mapping masters 106a3 using the chart type ID of the chart master 106a11 specified in 2. 4. Confirm that the value of the emphasis target item ID column of the emphasis event master 106a23 specified in 1 is included in the list of the chart type emphasis item mapping masters 106a3 specified in 3.

[0128] As described above, according to the present embodiment, an extraction event master 106a22 that associates and registers a chart, a click event, and an extraction event in response to an operation by a developer on a setting screen, a setting unit 102a that sets data of an emphasis event master 106a23 that associates and registers a chart, a click event, and an emphasis event, and a display control unit 102b that, when a click event for a chart occurs, refers to the extraction event master 106a22 and executes an extraction process, and also refers to the emphasis event master 106a23 and executes an emphasis process are provided. Therefore, by limiting the analysis operation to clicking on the chart and limiting the analysis process to extraction and emphasis, it is possible to reduce the cost at the time of dashboard design.

[0129] [4. Contribution to the Sustainable Development Goals (SDGs) Led by the United Nations] According to the present embodiment, since it can contribute to promoting business efficiency and appropriate management decisions of enterprises, it is possible to contribute to Goals 8 and 9 of the SDGs.

[0130] Also, according to the present embodiment, since it can contribute to promoting waste loss reduction and paperless and digitization, it is possible to contribute to Goals 12, 13, and 15 of the SDGs.

[0131] Also, according to the present embodiment, since it can contribute to strengthening control and governance, it is possible to contribute to Goal 16 of the SDGs.

[0132] [5. Other Embodiments] The present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims, in addition to the embodiments described above.

[0133] For example, among the processes described in the embodiment, all or part of the processes described as being automatically performed can be manually performed, or all or part of the processes described as being manually performed can be automatically performed by a known method.

[0134] In addition, regarding the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and the drawings, they can be arbitrarily changed unless otherwise specified.

[0135] Regarding the dashboard creation system 100, each illustrated component is a functional concept and does not necessarily have to be physically configured as shown in the figure.

[0136] For example, regarding the processing functions provided by the dashboard creation system 100, particularly each processing function performed by the control unit, all or any part of them may be realized by a CPU and a program interpreted and executed by the CPU, or may also be realized as hardware by wired logic. Note that the program is recorded on a non-transitory computer-readable recording medium including programmed instructions for causing an information processing apparatus to execute the processing described in this embodiment, and is mechanically read by the dashboard creation system 100 as necessary. That is, in a storage unit such as a ROM or an HDD (Hard Disk Drive), a computer program for giving instructions to the CPU in cooperation with the OS to perform various processes is recorded. This computer program is executed by being loaded into the RAM and constitutes the control unit in cooperation with the CPU.

[0137] In addition, this computer program may be stored in an application program server connected to the dashboard creation system 100 via an arbitrary network, and all or part of it can be downloaded as necessary.

[0138] Also, a program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium, or may be configured as a program product. Here, this "recording medium" includes any "portable physical medium" such as a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), an EEPROM (registered trademark) (Electrically Erasable and Programmable Read Only Memory), a CD-ROM (Compact Disk Read Only Memory), an MO (Magneto-Optical disk), a DVD (Digital Versatile Disk), and a Blu-ray (registered trademark) Disc.

[0139] Also, the "program" is a data processing method described in any language or description method, and is not limited to a specific form such as source code or binary code. Note that the "program" is not necessarily limited to a single configuration, and also includes those that are distributed as a plurality of modules or libraries, or those that achieve their functions in cooperation with another program represented by an OS. Note that for the specific configuration, reading procedure, and installation procedure after reading for reading the recording medium in each device shown in the embodiment, well-known configurations and procedures can be used.

[0140] The various databases and the like stored in the storage unit are storage means such as a memory device such as a RAM or a ROM, a fixed disk device such as a hard disk, a flexible disk, and an optical disk, and store various programs, tables, databases, and web page files used for various processes and website provision.

[0141] Further, the dashboard creation system 100 may be configured as an information processing apparatus such as a known personal computer or workstation, or may be configured as the information processing apparatus to which an arbitrary peripheral device is connected. Further, the dashboard creation system 100 may be realized by installing software (including programs or data, etc.) for realizing the processing described in the present embodiment in the apparatus.

[0142] Furthermore, the specific form of the distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in arbitrary units according to various additions or according to the functional load. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

Explanation of Signs

[0143] 100 Dashboard creation system 102 Control unit 102a Setting unit 102b Display control unit 104 Communication interface unit 106 Storage unit 106a DB 106a1 Chart type master 106a2 Chart emphasis item master 106a3 Chart type emphasis item mapping master 106a4 Chart click event master 106a5 Chart type click event mapping master 106a6 Chart click event acquirable value master 106a7 Dashboard definition master 106a8 Data acquisition master 106a9 Data acquisition column master 106a10 Chart layout master 106a11 Chart master 106a12 Line graph master 106a13 Bar graph master 106a14 Stacked Bar Graph Master 106a15 Area Graph Master 106a16 Stacked Area Graph Master 106a17 Pie Graph Master 106a18 Scatter Plot Master 106a19 Heatmap Master 106a20 Horizontal Bar Graph Master 106a21 Table Column Header Master 106a22 Extraction Event Master 106a23 Emphasis Event Master 106b Data Source 106c Data File 112 Input Device 114 Output Device 300 Network 400 Developer Terminal

Claims

1. A dashboard creation system comprising a control unit, wherein the control unit, an extraction event master for registering by associating a chart, a click event, and an extraction event according to an operation of a developer on a setting screen, and setting means for setting data of an emphasis event master for registering by associating a chart, a click event, and an emphasis event; display control means for, when a click event on a chart occurs, referring to the extraction event master to execute an extraction process, and referring to the emphasis event master to execute an emphasis process; and the control unit further includes a chart master in which a chart ID, a chart name, a chart type ID, and a data acquisition ID are associated and registered; a graph / map master in which a chart ID and a graph / map creation definition are associated and registered; a data acquisition master in which a data acquisition ID, a data acquisition name, and a stored procedure name are associated and registered; a data acquisition column master in which a data acquisition ID, a column number, and a column name are associated and registered; business data for abnormal value determination; and is configured to be accessible to; the extraction event of the extraction event master includes an extraction data value ID, an extraction target chart ID, and an extraction target column number; when a click event on a chart occurs, the display control means acquires the clicked chart ID, click type, and acquirable value, and refers to the chart master, the graph / map master, the data acquisition master, the data acquisition column master, and the extraction event master to draw a graph / map and execute an extraction process; the emphasis event of the emphasis event master includes an emphasis target chart ID, an emphasis target item ID, an emphasis condition data value ID, a color of the target, a color of the non-target, a transparency of the target, and a transparency of the non-target; the display control means refers to the emphasis event master and executes an emphasis process on the drawn graph / map. A dashboard creation system characterized by this.

2. The dashboard creation system according to claim 1, wherein the target of the extraction process and the emphasis process is business data for abnormal value determination.

3. The dashboard creation system according to claim 1 or 2, wherein the setting screen is a GUI.

4. The dashboard creation system according to claim 3, wherein the display control means displays, in the title of the drawn graph map, a value used for extraction of an extraction target column of the extraction event master.

5. A dashboard creation method executed by an information processing apparatus including a control unit, wherein the control unit a chart master in which a chart ID, a chart name, a chart type ID, and a data acquisition ID are registered in association with each other, a graph map master in which a chart ID and a graph map creation definition are registered in association with each other, a data acquisition master in which a data acquisition ID, a data acquisition name, and a stored procedure name are registered in association with each other, a data acquisition column master in which a data acquisition ID, a column number, and a column name are registered in association with each other, business data for abnormal value determination, is configured to be accessible, and the control unit executes a setting step of setting data of an extraction event master in which a chart, a click event, and an extraction event are registered in association with each other, and a highlight event master in which a chart, a click event, and a highlight event are registered in association with each other, in response to an operation of a developer on a setting screen; a display control step of, when a click event on a chart occurs, referring to the extraction event master to execute an extraction process, and referring to the highlight event master to execute a highlighting process; including the extraction event of the extraction event master includes an extraction data value ID, an extraction target chart ID, and an extraction target column number, in the display control step, when a click event on a chart occurs, the clicked chart ID, click type, and obtainable value are acquired, and a graph map is drawn and an extraction process is executed by referring to the chart master, the graph map master, the data acquisition master, the data acquisition column master, and the extraction event master; the highlight event of the highlight event master includes a highlight target chart ID, a highlight target item ID, a highlight condition data value ID, a color of a target, a color of a non-target, a transparency of a target, and a transparency of a non-target, and in the display control step, a highlighting process is executed on the drawn graph map by referring to the highlight event master. A dashboard creation method characterized by this.

6. A dashboard creation program for causing an information processing apparatus including a control unit to execute, wherein the control unit a chart master in which a chart ID, a chart name, a chart type ID, and a data acquisition ID are registered in association with each other, A graph map master that registers by associating a chart ID and a graph / map creation definition, A data acquisition master that registers by associating a data acquisition ID, a data acquisition name, and a stored procedure name, A data acquisition column master that registers by associating a data acquisition ID, a column number, and a column name, Business data for abnormal value determination, is configured to be accessible to, the control unit, According to the developer's operation on the setting screen, a setting step of setting data of an extraction event master that registers by associating a chart, a click event, and an extraction event, and a highlighting event master that registers by associating a chart, a click event, and a highlighting event, When a click event occurs on a chart, a display control step of executing an extraction process by referring to the extraction event master and executing a highlighting process by referring to the highlighting event master, A dashboard creation program for executing, The extraction event of the extraction event master includes an extraction data value ID, an extraction target chart ID, and an extraction target column number, In the display control step, when a click event occurs on a chart, the clicked chart ID, click type, and acquirable value are acquired, and a graph / map is drawn and an extraction process is executed by referring to the chart master, the graph map master, the data acquisition master, the data acquisition column master, and the extraction event master, The highlighting event of the highlighting event master includes a highlighting target chart ID, a highlighting target item ID, a highlighting condition data value ID, a color of the target, a color of the non-target, a transparency of the target, and a transparency of the non-target, In the display control step, a dashboard creation program characterized by executing a highlighting process on the drawn graph / map by referring to the highlighting event master.

Images