CA2606940A1 - Business intelligence incorporated business process management system and method thereof - Google Patents
Business intelligence incorporated business process management system and method thereof Download PDFInfo
- Publication number
- CA2606940A1 CA2606940A1 CA002606940A CA2606940A CA2606940A1 CA 2606940 A1 CA2606940 A1 CA 2606940A1 CA 002606940 A CA002606940 A CA 002606940A CA 2606940 A CA2606940 A CA 2606940A CA 2606940 A1 CA2606940 A1 CA 2606940A1
- Authority
- CA
- Canada
- Prior art keywords
- business process
- gadgets
- process activity
- activity form
- data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Abandoned
Links
- 238000000034 method Methods 0.000 title claims abstract description 353
- 230000008569 process Effects 0.000 title claims abstract description 335
- 230000000694 effects Effects 0.000 claims abstract description 194
- 230000008520 organization Effects 0.000 claims abstract description 19
- 238000007726 management method Methods 0.000 claims description 56
- 238000004458 analytical method Methods 0.000 claims description 34
- 230000009471 action Effects 0.000 claims description 8
- 238000013500 data storage Methods 0.000 claims description 6
- 239000000284 extract Substances 0.000 claims description 3
- 238000013507 mapping Methods 0.000 claims description 3
- 230000000644 propagated effect Effects 0.000 claims description 2
- 238000010586 diagram Methods 0.000 description 11
- 238000013461 design Methods 0.000 description 8
- 238000012550 audit Methods 0.000 description 7
- 230000003993 interaction Effects 0.000 description 6
- 230000006870 function Effects 0.000 description 5
- 230000004807 localization Effects 0.000 description 5
- 238000004891 communication Methods 0.000 description 3
- 230000007246 mechanism Effects 0.000 description 3
- 238000009877 rendering Methods 0.000 description 3
- 230000001419 dependent effect Effects 0.000 description 2
- 230000006872 improvement Effects 0.000 description 2
- 230000004044 response Effects 0.000 description 2
- 230000004931 aggregating effect Effects 0.000 description 1
- 238000013459 approach Methods 0.000 description 1
- 238000003491 array Methods 0.000 description 1
- 230000000295 complement effect Effects 0.000 description 1
- 238000004883 computer application Methods 0.000 description 1
- 230000014509 gene expression Effects 0.000 description 1
- 238000010348 incorporation Methods 0.000 description 1
- 238000009434 installation Methods 0.000 description 1
- 230000002452 interceptive effect Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000013439 planning Methods 0.000 description 1
- 238000012552 review Methods 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 230000001755 vocal effect Effects 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
A business process management system provides one or more business intelligence (Bl) gadgets, each providing a predefined functionality for extracting data from one or more data sources of an organization. The system allows embedment of one or more BI gadgets into a business process activity form for presenting to a user relevant data for a business process activity represented by the business process activity form.
Description
Business Intelligence Incorporated Business Process Management System and Method Thereof FIELD OF THE INVENTION
[0001] This invention relates to the field of managing business process, and more particularly to a Business Intelligence (BI) incorporated Business Process Management (BPM) system and method thereof.
BACKGROUND OF THE (NVENTION
[0001] This invention relates to the field of managing business process, and more particularly to a Business Intelligence (BI) incorporated Business Process Management (BPM) system and method thereof.
BACKGROUND OF THE (NVENTION
[0002] Business process management is describing business process activities which are performed to optimize a business process in an organization. A business process often involves access to information in one or more data sources of the organization. Business processes, as currently instantiated in business process management software, tend to be low-level operational in nature, i.e., the processes are rote and prescriptive, and executed by staff personnel. Management processes, on the other hand, are more ad hoc and near-real-time information-dependent.
[0003] Management participation in business processes is typically manual, e.g., verbal/written communications through email or voicemail. In cases where administrators want to include 'data' within an administrative form, such a form needs custom hand crafted data retrieval query using, e.g., structured query language (SQL).
[0004] Other existing solutions include sets of components that enable JavaTM
developers to quickly create custom solutions using Java Objects or Java Server Pages (JSPs). These can be tightly integrated with other applications or portals and by their nature involve writing and adapting programs.
developers to quickly create custom solutions using Java Objects or Java Server Pages (JSPs). These can be tightly integrated with other applications or portals and by their nature involve writing and adapting programs.
[0005] Others have made the results of the Extract, Transform and Load (ETL) process more current, ensuring more up-to-date data is made available.
However, this approach does not solve the problem of providing non-programmer users with suitable access to the data.
However, this approach does not solve the problem of providing non-programmer users with suitable access to the data.
[0006] It is known to provide users with an indication that updating of the underlying database has taken place, thereby ensuring immediate results to multi-dimensional sophisticated queries for business process events occurring in near real time.
However, there is no process of actually carrying out the queries and subsequent decision-making based on forms.
However, there is no process of actually carrying out the queries and subsequent decision-making based on forms.
[0007] It is also known to provide analytics that give end users across an organization access to the information they need, directly in the context of their business processes so that these processes are more timely and up-to-date. This can be done by using a framework for guiding users through effective, repeatable decision-making processes. However, the processes so improved must be pre-defined and tend to involve interactions with many people or organizations. They do not address ad hoc or informal situations.
[0008] Business process systems are known where process activities and associated forms are provided in a computer-assisted environment. These systems require the users to provide all of the data deemed necessary to make decisions, thereby allowing room for error in inputting or transferring that data.
[0009] It is therefore desirable to provide a mechanism to overcome the latency of data, at the same time reducing errors in planning processes.
SUMMARY OF THE INVENTION
SUMMARY OF THE INVENTION
[0010] It is an object of the invention to provide an improved method and system that obviates or mitigates at least one of the disadvantages of existing systems.
[0011] The invention uses business intelligence (BI) gadgets to access data in data sources, e.g., for navigation, search, rendering and interaction. The BI
gadgets are embeddable in business process activity forms.
gadgets are embeddable in business process activity forms.
[0012] In accordance with an aspect of the present invention, there is provided a business process management system for managing business process using data from one or more data sources of an organization. The business process management system comprises a business process activity form generator, one or more business intelligence (Bi) gadgets, and a BI gadgets manager. The business process activity form generator is provided for generating business process activity forms, each business process activity form for presenting to a user relevant data for a business process activity represented by the business process activity form.
Each BI
gadget provides a predefined functionality for extracting data from the data sources.
The BI gadgets manager is provided for enabling embedment of one or more of the BI gadgets into the business process activity forms.
Each BI
gadget provides a predefined functionality for extracting data from the data sources.
The BI gadgets manager is provided for enabling embedment of one or more of the BI gadgets into the business process activity forms.
[0013] In accordance with another aspect of the present invention, there is provided a method of managing business process using data from one or more data sources of an organization. The me~ho~ic"comprises the steps of providing one or more business intelligence (BI) gadgets, each providing a predefined functionality for extracting data from the data sources; generating a business process activity form represented a business process activity; and embedding one or more of the BI gadgets into the business process activity form for allowing a user to access the functionality of the embedded BI gadgets from the business process activity form.
[00141 In accordance with another aspect of the present invention, there is provided a computer readable medium storing instructions and/or statements for use in the execution in a computer of a method of managing business process using data from one or more data sources of an organization. The method comprises the steps of providing one or more business intelligence (BI) gadgets, each providing a predefined functionality for extracting data from the data sources; generating a business process activity form represented a business process activity; and embedding one or more of the BI gadgets into the business process activity form for allowing a user to access the functionality of the embedded BI gadgets from the business process activity form.
[0015] In accordance with another aspect of the present invention, there is provided a propagated signal carrier containing computer executable instructions and/or statements that can be read and executed by a computer, the computer executable instructions being used to execute a method of managing business process using data from one or more data sources of an organization. The method comprises the steps of providing one or more business intelligence (BI) gadgets, each providing a predefined functionality for extracting data from the data sources; generating a business process activity form represented a business process activity; and embedding one or more of the BI gadgets into the business process activity form for allowing a user to access the functionality of the embedded BI gadgets from the business process activity form.
[0016] This summary of the invention does not necessarily describe all features of the invention.
BRIEF DESCRIPTION OF THE DRAWINGS
[0017] These and other features of the invention will become more apparent from the following description in which reference is made to the appended drawings wherein:
Figure 1 is a diagram showing an example of a general-purpose computing environment in which embodiments of the invention may be practiced;
Figure 2 is a block diagram showing a business process management system in accordance with an embodiment of the present invention;
Figure 3 is a block diagram showing an example of a set of BI gadgets;
Figure 4 is a diagram showing a very simple example of a business process activity form used in an embodiment of the invention;
Figure 5 is a block diagram showing a BI gadgets manager;
Figure 6 is a block diagram showing a business process activity form generator;
Figure 7 is a block diagram showing a business process management system in accordance with another embodiment of the present invention;
Figure 8 is a diagram showing an example of elements interacting with a business process activity form having embedded BI gadgets;
Figure 9 is a schematic diagram showing an example of a sequence of actions taken by a run-time user of a business process activity form;
Figure 10 is a diagram showing an example of a business process activity form;
and Figure 11 is a diagram showing another example of elements interacting with a business process activity form having embedded BI gadgets.
DETAILED DESCRIPTION OF PREFERRED EMBODIMENTS
[0018] Embodiments of the invention may conveniently be implemented on any general purpose computing platform, including one incorporated in a client/server or networked environment, such as that described with reference to Figure 1 in which one or more client computers 110, 111 are connected over a network 100 to a server 120, which is itself connected to one or more enterprise data sources 130.
[0019] Figure 2 shows a business process management (BPM) system 10 in accordance with an embodiment of the invention. The BPM system 10 comprises a business process activity form generator 30, a BI gadget manager 50 and a set of BI
gadgets 60.
[0020] The business process activity form generator 30 generates business process activity forms. Each business process activity form represents a business process activity. A business process activity form is a visible manifestation of data used in business process management. It provides data that is relevant for a business user to make a decision or recommendation in performing the business process activity.
Business process activity forms are used by business users at run-time, such as a manager or other employee who uses the BPM system 10 and are typically not technically skilled. The business process activity forms assist such run-time users in making a decision or recommendation, as further described below.
[0021] A Bt gadget 60 is a toof to extract data from one or more data sources 130.
An organization, e.g., an enterprise or corporation, typically has one or more data sources 130, such as, a data warehouse, a transactional database, enterprise applications and/or other corporate data sources. BI gadgets 60 access data in the data sources 130 for navigation, search, rendering and interaction by run-time users.
BI gadgets 60 are embeddable in business process activity forms. Examples of various BI gadgets 60 are described referring to Figure 3 below.
[0022] The Bi gadgets manager 50 presents the BI gadgets 60 to the business process activity form generator 30 to allow one or more BI gadgets 60 to be embedded in business process activity forms.
[0023] When a run-time user requests a business process activity form, the business process activity form generator 30 provides the requested business process activity form with relevant BI gadgets automatically and dynamically embedded in the requested form. An embedded Bi gadget may take a form of data or a report containing data extracted from the data sources 130, a query to extract data from the data sources 130, and/or a search option for searching and/or navigating data in the data sources 130. The run-time user can use one or more desired BI gadgets within the business process activity form to obtain refevant information to complete the business process activity form. There is no need for the run-time business user to know how to focate and access relevant information. Also, there is no need for a designer or author of the business process activity form to write code within the forms for extracting data from the data sources 130.
[0024] A BI gadget 60 may be an application that can be embedded in a business process activity form. Examples of these BI gadgets 60 include Web Services for Remote Portlets (WSRP)-compliant portlets, and those based on HyperText Mark-up Language (HTML). The type of BI gadgets 60 may be determined depending on the capability of the relevant business process activity forms. WSRP is a web services protocol for aggregating content and interactive web applications from remote sources. A portlet is typically an area or component within a web page where data is exposed to the user, that data being derived from underlying data by processes that are not visible to the user. A portlet processes requests and generates dynamic content. The end-user sees a portlet as being specialized content within a web page that occupies a small window iri that page. A portiet provides users with the capability to customize the content, appearance and position of the portiet.
It provides a framework for sophisticated scenarios, including the ability for consumers to customize a portiet's content, and to create application process flows.
WSRP
builds on a few fundamental standards and allows for the implementation of evolving standards, to deliver a protocol rich in abstractions and operations. It functions as a toolkit for programmers.
[0025] Figure 4 illustrates an example of a simple business process activity form having embedded BI gadgets. The form 300 has embedded in it four fields 310, 312, 314, 316 with or without their associated field labels. In this case, the first field 310 contains information supplied by the user, and no BI gadget is associated with that field 310. The second field 312 contains a value that is directly picked from one of the corporate data sources using an embedded BI gadget 60. The third field 314 contains data (or artifacts) derived from the data sources 130 using business intelligence tools through an embedded BI gadget 60. An artifact is data derived from the data sources 130 using business intelligence tools. The user can select from the artifacts using the scroll tool 315 or similar mechanisms commonly used in business and windowing computer applications. The fourth field 316 contains a report, in graphical format, based on data contained in the corporate data sources, again derived using business intelligence tools, and made available using an embedded BI gadget 60.
[0026] Figure 5 shows an embodiment of the BI gadgets manager 50. In this embodiment, the BI gadgets manager 50 has a BI gadgets provider 52 for exposing available BI gadgets 60 for the use by the business process activity form generator 30. As shown in Figure 6, the business process activity form generator 30 may have a form designing tool 32 to assist a form designer or author to design business process activity forms. The form designing tool 32 may have a process design palette for presenting to the form author available tools that can be used in designing a business process activity form. In that case, the BI gadgets provider 52 may add available BI gadgets 60 to the process design palette for author's selection for embedding selected BI gadgets 60 in the business process activity form.
[0027] The BI gadgets manager 50 may have a context manager 54. Context may be data that was embedded to the business process activity form at design-time, data that was pre-populated in the business process activity form at run-time, or data that the user has entered into the business process activity form. Design-time is the period during which a business process activity form is developed, including the assignment of BI gadgets and other means to pre-fill fields. Run-time is a business real-time and the period during which a business process activity form is used.
[0028] The context manager 54 derives context from business process activity forms.
The BI gadgets manager 50 makes the derived context available to the BI
gadgets 60 to render BI content or extract data from the data sources 130.
[0029] The context manager 54 may use a BI metadata model 90 storing metadata describing business intelligence data in the data sources 130. The BI metadata model 90 may or may not be part of the BI gadgets manager 50 or the BPM system 10. When the organization has an existing BI metadata model, the BI gadgets manager 50 may use metadata in such an existing BI metadata model.
[0030] The BI gadgets manager 50 may also have a business process data record handier 56 and a business process data storage 58. The business process data record handler 56 records in the business process data storage 58 relevant business process data, including BI data and contexts in business process activity forms, process paths taken, and actions, e.g., decisions or recommendations, taken within the business process activity forms. The BI gadgets manager 50 thus provides recording of decision making for future reference, process improvement and similar functions, and for audit and compliance purposes. This will form a knowledge database for the organization. The recorded business process data may also form an audit/compliance database. The business process data storage 58 may be a separate component. It may be part of other data storage of the computer system.
[0031] As shown in Figure 6, the business process activity form generator 30 may have a form library 34 for storing business process activity forms predefined or defined by form authors. The business process activity form generator 30 may generate business process activity forms from the form library 34 and embed one or more appropriate BI gadgets 60 therein. These business process activity forms with embedded BI gadgets may be stored in the library 34 or other storage.
[0032] Figure 7 shows a business process management (BPM) system 12 in accordance with another embodiment of the invention. Similar elements to those shown in Figure 2 are denoted with the same reference numbers for the simplicity of description.
[0033] This embodiment is suitably used when an organization has an existing BPM
tool 20. The BPM system 12 may use features of the BPM tool 20. Similarly, when an organization has one or more existing BI tools 70, one or more BI gadgets 60 of the business process management system 12 may use BI features of the BI tools to extract data from the data sources 130.
[0034] The BPM system 12 has a set of BI gadgets 60 and a BI gadgets manager 50.
A typical BPM tool 20 has a business process repository 40, a modelling tool 42 and a business process activity form generator 30.
[0035] The business process repository 40 stores one or more business process models representing business process activities and process paths among the business process activities. It may also store business process activity forms in association with the relevant business process models. The modeling tool 42 allows a model designer to define business process models, which are stored in the business process repository 40. The business process activity form generator generates business process activity forms based on the business process models in the repository 40.
[0036] The BI gadgets manager 50 of the business process management system 12 provides the BI gadgets 60 to the business process activity form generator 30 of the BPM tool 20 to enable the BI gadgets 60 to be embedded into business process activity forms based on the relevant business process models in the repository 40.
Thus, the business intelligence is incorporated in the business process management that is driven by models. There is no need to write code or applications each time BI
functionality is needed.
[0037] The BI gadgets manager 50 may embed BI data in proprietary business process activity forms by using a Bi gadget 60 as a proxy. In this situation, the Bi gadget manager 50 allows the BI gadget 60 to respond to a data request from a business process activity form and return it to the form the requested data in a known format, such as Extensible Mark-up Language (XML). The BI gadget 60 is effectively an information broker between the business process activity form and the data source 130 or a BI tool 70 accessing the data source 130. The BI gadgets manager 50 may use the context manager 54 to derive context from the business process activity form and hand it to the BI gadget 60. Based on that context, the BI
gadget 60 may deliver rendered Bi content or data from the data source 130 or the BI
tool 70.
[0038] Thus, the BPM system 12 improves on the existing BPM tool 20 by introducing the BI gadgets 60 for navigation, search, rendering and interaction by run-time users.
The BPM system 12 may also use the power of existing BI tools 70 to extract that data from data sources 130 and displaying it to the user as data embedded as part of the forms.
[0039] In a different embodiment, the business process repository 40 may be part of the BPM system 10 or 12.
[0040] In the above described embodiments, the BI gadgets 60 are embeddable within business process activity forms. When a process author or modeller is defining a business process, e.g., using a business process modeling tool 42, the BI
gadgets manager 50 may add BI gadgets 60 to the process design palette. A form designer may use the BI gadgets 60 in the process design palette to design business process activity forms. Within business process activity forms, one or more appropriate embedded BI gadgets (e.g., a report) appear and are presented to the run-time user who is the process participant. Such business process activity forms may be called the "BI-enabled forms". A BI-enabled form supports run-time process path branching, i.e., the form allows the user to determine the "next" process activity.
The next process activity is dependent upon the BI data or information delivered to the user in the business process activity form using the embedded BI gadgets.
The BI gadgets manager 50 may record in the business process data storage 58 both the BI and the process path branch for audit and compliance purposes.
[0041] Referring back to Figure 3, examples of BI gadgets 60 are described. BI
gadgets 60 in this embodiment include a viewer gadget 61, navigation and search gadgets 62, an ad hoc query gadget 63, an analysis gadget 64, and a post analysis gadget 65. In a different embodiment, the BI management system 50 may have a different set of BI gadgets.
[0042] The viewer gadget 61 is a tool for exposing BI content or data and context inside of a business process activity form. The viewer gadget 61 may expose pre-defined BI content or context. For example, in the business process model, a form author selects a specific BI artifact that has been previously authored, and elects to embed it inside the business process activity form for runtime consumption as pre-defined BI content or context. Also, the viewer gadget 61 may generate and expose BI content or context at run-time based on the context of the particular/current in-flight process, i.e., a process currently being used. In-flight means during a cycle of the present business process incarnation. For example, in the business process model, the author selects a specific BI artifact that has been previously authored, and embeds it inside the business process activity form for runtime consumption or exploitation. Additionally, the viewer gadget 61 may set a context flag to ensure that the context of the BPM process is passed to the BI artifact so that the report or analysis is filtered dynamically based on the context at runtime.
[0043] The navigation and/or search gadgets 62 are tools for finding and/or navigating Bi content from a business process activity form. The administrator, i.e., a form author, selects to include either a search gadget or a navigation gadget or both gadgets 62 inside the business process activity form by, e.g., dragging and dropping these gadgets 62 onto the form. This gadget embedding does not involve any code coding, such as Structured Query Language (SQL) or multidimensional expressions (MDX) coding by the administrator. The context of these gadgets 62 can be predefined or dynamically defined. For example, as predefined context, a form author, at design time, may defined context, such as a specific category of information for the navigation gadget, or a default search keyword for the search gadget. When the context is dynamic, these gadgets 62 allow the instance of the BPM process to set the context at runtime, or allow the user to freely navigate through the gadgets 62 to select BI artifacts from relevant information, e.g., a relevant set of categorized folders. BI context may be centralized in a common repository for security and consistency purposes. The BI context can also be used by other BI
gadgets.
[0044] The ad hoc query gadget 63 is a tool for filling in input information in a business process activity form using ad hoc queries. A. query may be pre-defined, e.g., in the business process model, or defined by a user at run-time. The ad hoc query gadget 63 uses business-friendly semantics, i.e., without the need to know SQL or MDX. When the run-time user defines a query, the ad hoc query gadget 63 automatically generates some of the query parameters according to the context of the in-flight process, or the context of the particular business process activity form.
For example, a business process activity form may have multiple input-capture fields in which the ad hoc query gadget 63 is embedded. In that case, the user keys in a subset of those fields, and based on the data input, the ad hoc query gadget generates a query and retrieves the appropriate information for the remaining fields.
[0045] The analysis gadget 64 is a tool for filling in input information in a business process activity form. An analysis may be pre-defined, e.g., in the business process model, or defined by a user at run-time. The analysis gadget 64 uses business friendly semantics, i.e., without the need to know SQL or MDX. When the run-time user defines an analysis, the analysis gadget 64 automatically generates some of the analysis parameters according to the context of the in-flight process, or the context of the particular business process activity form. The analysis gadget 64 differs from the ad hoc query gadget 63 in that typical users of the ad hoc query gadget 63 knows what they are looking for (e.g., "What is the average sales for this product across North America?"), while a typical user of the analysis gadget 64 may not know what specific information is needed, but is looking to start on a broad set of information and drill down, pivot, sort and/or calculate to find interesting information, e.g., trends and data highlights, and with each step of information discovery gain deeper knowledge.
[0046] The post analysis gadget 65 is a tool for providing a mechanism to save a "snapshot" of the Bi content and context to a business process history database 80.
The post analysis gadget 65 also stores decisions made, and responses to the decisions. The post analysis gadget 65 also allows users to easily navigate through BI artifacts of past decision responses to review past decisions and the supporting BI
content and context that was leveraged in the decision-making process.
[0047] Embedded BI gadgets (e.g., reports, queries, searches) utilized in the course of a business process may be "save-able". The embedded BI gadgets may be recorded in the business process history database 80, along with the decision made, e.g., the course taken or process path taken, as a result of Bi gadget utilization by the user or users. This recording is performed using the post analysis gadget 65.
Consequently, these saveable embedded Bi gadgets provide two post facto capabilities: historical reporting of BI gadget process utilization in support of users' compliance agendas; and a form of knowledge management, whereby decision paths are recorded and exposed at run-time to users, so that they can have a basis for what decisions were made in the past, and based on what information at that time.
[0048] The BI gadgets 60 may have a mapping capability, i.e., the ability to translate the mapping between the contextual data in the business process activity form and the BI metadata, and to that end can formulate and run complex BI queries, and render the result set appropriately.
[0049] Figure 8 shows an example of elements interaction in relation to a business process. When a user initiates the business process 200, the BPM system 10, 12 generates a first instantiation of a business process activity form (not shown) for the first business process activity 220. The business process activity form has various BI
gadgets, i.e. embedded viewer gadget 61, navigation and search gadget 62, ad hoc query gadget 63, analysis gadget 64, and post analysis gadget 65. .
[0050] The embedded viewer gadget 61 is represented as the interface between the business process activity 220 and the business process activity form. The viewer gadget 61 allows the user to interact with the form.
[00141 In accordance with another aspect of the present invention, there is provided a computer readable medium storing instructions and/or statements for use in the execution in a computer of a method of managing business process using data from one or more data sources of an organization. The method comprises the steps of providing one or more business intelligence (BI) gadgets, each providing a predefined functionality for extracting data from the data sources; generating a business process activity form represented a business process activity; and embedding one or more of the BI gadgets into the business process activity form for allowing a user to access the functionality of the embedded BI gadgets from the business process activity form.
[0015] In accordance with another aspect of the present invention, there is provided a propagated signal carrier containing computer executable instructions and/or statements that can be read and executed by a computer, the computer executable instructions being used to execute a method of managing business process using data from one or more data sources of an organization. The method comprises the steps of providing one or more business intelligence (BI) gadgets, each providing a predefined functionality for extracting data from the data sources; generating a business process activity form represented a business process activity; and embedding one or more of the BI gadgets into the business process activity form for allowing a user to access the functionality of the embedded BI gadgets from the business process activity form.
[0016] This summary of the invention does not necessarily describe all features of the invention.
BRIEF DESCRIPTION OF THE DRAWINGS
[0017] These and other features of the invention will become more apparent from the following description in which reference is made to the appended drawings wherein:
Figure 1 is a diagram showing an example of a general-purpose computing environment in which embodiments of the invention may be practiced;
Figure 2 is a block diagram showing a business process management system in accordance with an embodiment of the present invention;
Figure 3 is a block diagram showing an example of a set of BI gadgets;
Figure 4 is a diagram showing a very simple example of a business process activity form used in an embodiment of the invention;
Figure 5 is a block diagram showing a BI gadgets manager;
Figure 6 is a block diagram showing a business process activity form generator;
Figure 7 is a block diagram showing a business process management system in accordance with another embodiment of the present invention;
Figure 8 is a diagram showing an example of elements interacting with a business process activity form having embedded BI gadgets;
Figure 9 is a schematic diagram showing an example of a sequence of actions taken by a run-time user of a business process activity form;
Figure 10 is a diagram showing an example of a business process activity form;
and Figure 11 is a diagram showing another example of elements interacting with a business process activity form having embedded BI gadgets.
DETAILED DESCRIPTION OF PREFERRED EMBODIMENTS
[0018] Embodiments of the invention may conveniently be implemented on any general purpose computing platform, including one incorporated in a client/server or networked environment, such as that described with reference to Figure 1 in which one or more client computers 110, 111 are connected over a network 100 to a server 120, which is itself connected to one or more enterprise data sources 130.
[0019] Figure 2 shows a business process management (BPM) system 10 in accordance with an embodiment of the invention. The BPM system 10 comprises a business process activity form generator 30, a BI gadget manager 50 and a set of BI
gadgets 60.
[0020] The business process activity form generator 30 generates business process activity forms. Each business process activity form represents a business process activity. A business process activity form is a visible manifestation of data used in business process management. It provides data that is relevant for a business user to make a decision or recommendation in performing the business process activity.
Business process activity forms are used by business users at run-time, such as a manager or other employee who uses the BPM system 10 and are typically not technically skilled. The business process activity forms assist such run-time users in making a decision or recommendation, as further described below.
[0021] A Bt gadget 60 is a toof to extract data from one or more data sources 130.
An organization, e.g., an enterprise or corporation, typically has one or more data sources 130, such as, a data warehouse, a transactional database, enterprise applications and/or other corporate data sources. BI gadgets 60 access data in the data sources 130 for navigation, search, rendering and interaction by run-time users.
BI gadgets 60 are embeddable in business process activity forms. Examples of various BI gadgets 60 are described referring to Figure 3 below.
[0022] The Bi gadgets manager 50 presents the BI gadgets 60 to the business process activity form generator 30 to allow one or more BI gadgets 60 to be embedded in business process activity forms.
[0023] When a run-time user requests a business process activity form, the business process activity form generator 30 provides the requested business process activity form with relevant BI gadgets automatically and dynamically embedded in the requested form. An embedded Bi gadget may take a form of data or a report containing data extracted from the data sources 130, a query to extract data from the data sources 130, and/or a search option for searching and/or navigating data in the data sources 130. The run-time user can use one or more desired BI gadgets within the business process activity form to obtain refevant information to complete the business process activity form. There is no need for the run-time business user to know how to focate and access relevant information. Also, there is no need for a designer or author of the business process activity form to write code within the forms for extracting data from the data sources 130.
[0024] A BI gadget 60 may be an application that can be embedded in a business process activity form. Examples of these BI gadgets 60 include Web Services for Remote Portlets (WSRP)-compliant portlets, and those based on HyperText Mark-up Language (HTML). The type of BI gadgets 60 may be determined depending on the capability of the relevant business process activity forms. WSRP is a web services protocol for aggregating content and interactive web applications from remote sources. A portlet is typically an area or component within a web page where data is exposed to the user, that data being derived from underlying data by processes that are not visible to the user. A portlet processes requests and generates dynamic content. The end-user sees a portlet as being specialized content within a web page that occupies a small window iri that page. A portiet provides users with the capability to customize the content, appearance and position of the portiet.
It provides a framework for sophisticated scenarios, including the ability for consumers to customize a portiet's content, and to create application process flows.
WSRP
builds on a few fundamental standards and allows for the implementation of evolving standards, to deliver a protocol rich in abstractions and operations. It functions as a toolkit for programmers.
[0025] Figure 4 illustrates an example of a simple business process activity form having embedded BI gadgets. The form 300 has embedded in it four fields 310, 312, 314, 316 with or without their associated field labels. In this case, the first field 310 contains information supplied by the user, and no BI gadget is associated with that field 310. The second field 312 contains a value that is directly picked from one of the corporate data sources using an embedded BI gadget 60. The third field 314 contains data (or artifacts) derived from the data sources 130 using business intelligence tools through an embedded BI gadget 60. An artifact is data derived from the data sources 130 using business intelligence tools. The user can select from the artifacts using the scroll tool 315 or similar mechanisms commonly used in business and windowing computer applications. The fourth field 316 contains a report, in graphical format, based on data contained in the corporate data sources, again derived using business intelligence tools, and made available using an embedded BI gadget 60.
[0026] Figure 5 shows an embodiment of the BI gadgets manager 50. In this embodiment, the BI gadgets manager 50 has a BI gadgets provider 52 for exposing available BI gadgets 60 for the use by the business process activity form generator 30. As shown in Figure 6, the business process activity form generator 30 may have a form designing tool 32 to assist a form designer or author to design business process activity forms. The form designing tool 32 may have a process design palette for presenting to the form author available tools that can be used in designing a business process activity form. In that case, the BI gadgets provider 52 may add available BI gadgets 60 to the process design palette for author's selection for embedding selected BI gadgets 60 in the business process activity form.
[0027] The BI gadgets manager 50 may have a context manager 54. Context may be data that was embedded to the business process activity form at design-time, data that was pre-populated in the business process activity form at run-time, or data that the user has entered into the business process activity form. Design-time is the period during which a business process activity form is developed, including the assignment of BI gadgets and other means to pre-fill fields. Run-time is a business real-time and the period during which a business process activity form is used.
[0028] The context manager 54 derives context from business process activity forms.
The BI gadgets manager 50 makes the derived context available to the BI
gadgets 60 to render BI content or extract data from the data sources 130.
[0029] The context manager 54 may use a BI metadata model 90 storing metadata describing business intelligence data in the data sources 130. The BI metadata model 90 may or may not be part of the BI gadgets manager 50 or the BPM system 10. When the organization has an existing BI metadata model, the BI gadgets manager 50 may use metadata in such an existing BI metadata model.
[0030] The BI gadgets manager 50 may also have a business process data record handier 56 and a business process data storage 58. The business process data record handler 56 records in the business process data storage 58 relevant business process data, including BI data and contexts in business process activity forms, process paths taken, and actions, e.g., decisions or recommendations, taken within the business process activity forms. The BI gadgets manager 50 thus provides recording of decision making for future reference, process improvement and similar functions, and for audit and compliance purposes. This will form a knowledge database for the organization. The recorded business process data may also form an audit/compliance database. The business process data storage 58 may be a separate component. It may be part of other data storage of the computer system.
[0031] As shown in Figure 6, the business process activity form generator 30 may have a form library 34 for storing business process activity forms predefined or defined by form authors. The business process activity form generator 30 may generate business process activity forms from the form library 34 and embed one or more appropriate BI gadgets 60 therein. These business process activity forms with embedded BI gadgets may be stored in the library 34 or other storage.
[0032] Figure 7 shows a business process management (BPM) system 12 in accordance with another embodiment of the invention. Similar elements to those shown in Figure 2 are denoted with the same reference numbers for the simplicity of description.
[0033] This embodiment is suitably used when an organization has an existing BPM
tool 20. The BPM system 12 may use features of the BPM tool 20. Similarly, when an organization has one or more existing BI tools 70, one or more BI gadgets 60 of the business process management system 12 may use BI features of the BI tools to extract data from the data sources 130.
[0034] The BPM system 12 has a set of BI gadgets 60 and a BI gadgets manager 50.
A typical BPM tool 20 has a business process repository 40, a modelling tool 42 and a business process activity form generator 30.
[0035] The business process repository 40 stores one or more business process models representing business process activities and process paths among the business process activities. It may also store business process activity forms in association with the relevant business process models. The modeling tool 42 allows a model designer to define business process models, which are stored in the business process repository 40. The business process activity form generator generates business process activity forms based on the business process models in the repository 40.
[0036] The BI gadgets manager 50 of the business process management system 12 provides the BI gadgets 60 to the business process activity form generator 30 of the BPM tool 20 to enable the BI gadgets 60 to be embedded into business process activity forms based on the relevant business process models in the repository 40.
Thus, the business intelligence is incorporated in the business process management that is driven by models. There is no need to write code or applications each time BI
functionality is needed.
[0037] The BI gadgets manager 50 may embed BI data in proprietary business process activity forms by using a Bi gadget 60 as a proxy. In this situation, the Bi gadget manager 50 allows the BI gadget 60 to respond to a data request from a business process activity form and return it to the form the requested data in a known format, such as Extensible Mark-up Language (XML). The BI gadget 60 is effectively an information broker between the business process activity form and the data source 130 or a BI tool 70 accessing the data source 130. The BI gadgets manager 50 may use the context manager 54 to derive context from the business process activity form and hand it to the BI gadget 60. Based on that context, the BI
gadget 60 may deliver rendered Bi content or data from the data source 130 or the BI
tool 70.
[0038] Thus, the BPM system 12 improves on the existing BPM tool 20 by introducing the BI gadgets 60 for navigation, search, rendering and interaction by run-time users.
The BPM system 12 may also use the power of existing BI tools 70 to extract that data from data sources 130 and displaying it to the user as data embedded as part of the forms.
[0039] In a different embodiment, the business process repository 40 may be part of the BPM system 10 or 12.
[0040] In the above described embodiments, the BI gadgets 60 are embeddable within business process activity forms. When a process author or modeller is defining a business process, e.g., using a business process modeling tool 42, the BI
gadgets manager 50 may add BI gadgets 60 to the process design palette. A form designer may use the BI gadgets 60 in the process design palette to design business process activity forms. Within business process activity forms, one or more appropriate embedded BI gadgets (e.g., a report) appear and are presented to the run-time user who is the process participant. Such business process activity forms may be called the "BI-enabled forms". A BI-enabled form supports run-time process path branching, i.e., the form allows the user to determine the "next" process activity.
The next process activity is dependent upon the BI data or information delivered to the user in the business process activity form using the embedded BI gadgets.
The BI gadgets manager 50 may record in the business process data storage 58 both the BI and the process path branch for audit and compliance purposes.
[0041] Referring back to Figure 3, examples of BI gadgets 60 are described. BI
gadgets 60 in this embodiment include a viewer gadget 61, navigation and search gadgets 62, an ad hoc query gadget 63, an analysis gadget 64, and a post analysis gadget 65. In a different embodiment, the BI management system 50 may have a different set of BI gadgets.
[0042] The viewer gadget 61 is a tool for exposing BI content or data and context inside of a business process activity form. The viewer gadget 61 may expose pre-defined BI content or context. For example, in the business process model, a form author selects a specific BI artifact that has been previously authored, and elects to embed it inside the business process activity form for runtime consumption as pre-defined BI content or context. Also, the viewer gadget 61 may generate and expose BI content or context at run-time based on the context of the particular/current in-flight process, i.e., a process currently being used. In-flight means during a cycle of the present business process incarnation. For example, in the business process model, the author selects a specific BI artifact that has been previously authored, and embeds it inside the business process activity form for runtime consumption or exploitation. Additionally, the viewer gadget 61 may set a context flag to ensure that the context of the BPM process is passed to the BI artifact so that the report or analysis is filtered dynamically based on the context at runtime.
[0043] The navigation and/or search gadgets 62 are tools for finding and/or navigating Bi content from a business process activity form. The administrator, i.e., a form author, selects to include either a search gadget or a navigation gadget or both gadgets 62 inside the business process activity form by, e.g., dragging and dropping these gadgets 62 onto the form. This gadget embedding does not involve any code coding, such as Structured Query Language (SQL) or multidimensional expressions (MDX) coding by the administrator. The context of these gadgets 62 can be predefined or dynamically defined. For example, as predefined context, a form author, at design time, may defined context, such as a specific category of information for the navigation gadget, or a default search keyword for the search gadget. When the context is dynamic, these gadgets 62 allow the instance of the BPM process to set the context at runtime, or allow the user to freely navigate through the gadgets 62 to select BI artifacts from relevant information, e.g., a relevant set of categorized folders. BI context may be centralized in a common repository for security and consistency purposes. The BI context can also be used by other BI
gadgets.
[0044] The ad hoc query gadget 63 is a tool for filling in input information in a business process activity form using ad hoc queries. A. query may be pre-defined, e.g., in the business process model, or defined by a user at run-time. The ad hoc query gadget 63 uses business-friendly semantics, i.e., without the need to know SQL or MDX. When the run-time user defines a query, the ad hoc query gadget 63 automatically generates some of the query parameters according to the context of the in-flight process, or the context of the particular business process activity form.
For example, a business process activity form may have multiple input-capture fields in which the ad hoc query gadget 63 is embedded. In that case, the user keys in a subset of those fields, and based on the data input, the ad hoc query gadget generates a query and retrieves the appropriate information for the remaining fields.
[0045] The analysis gadget 64 is a tool for filling in input information in a business process activity form. An analysis may be pre-defined, e.g., in the business process model, or defined by a user at run-time. The analysis gadget 64 uses business friendly semantics, i.e., without the need to know SQL or MDX. When the run-time user defines an analysis, the analysis gadget 64 automatically generates some of the analysis parameters according to the context of the in-flight process, or the context of the particular business process activity form. The analysis gadget 64 differs from the ad hoc query gadget 63 in that typical users of the ad hoc query gadget 63 knows what they are looking for (e.g., "What is the average sales for this product across North America?"), while a typical user of the analysis gadget 64 may not know what specific information is needed, but is looking to start on a broad set of information and drill down, pivot, sort and/or calculate to find interesting information, e.g., trends and data highlights, and with each step of information discovery gain deeper knowledge.
[0046] The post analysis gadget 65 is a tool for providing a mechanism to save a "snapshot" of the Bi content and context to a business process history database 80.
The post analysis gadget 65 also stores decisions made, and responses to the decisions. The post analysis gadget 65 also allows users to easily navigate through BI artifacts of past decision responses to review past decisions and the supporting BI
content and context that was leveraged in the decision-making process.
[0047] Embedded BI gadgets (e.g., reports, queries, searches) utilized in the course of a business process may be "save-able". The embedded BI gadgets may be recorded in the business process history database 80, along with the decision made, e.g., the course taken or process path taken, as a result of Bi gadget utilization by the user or users. This recording is performed using the post analysis gadget 65.
Consequently, these saveable embedded Bi gadgets provide two post facto capabilities: historical reporting of BI gadget process utilization in support of users' compliance agendas; and a form of knowledge management, whereby decision paths are recorded and exposed at run-time to users, so that they can have a basis for what decisions were made in the past, and based on what information at that time.
[0048] The BI gadgets 60 may have a mapping capability, i.e., the ability to translate the mapping between the contextual data in the business process activity form and the BI metadata, and to that end can formulate and run complex BI queries, and render the result set appropriately.
[0049] Figure 8 shows an example of elements interaction in relation to a business process. When a user initiates the business process 200, the BPM system 10, 12 generates a first instantiation of a business process activity form (not shown) for the first business process activity 220. The business process activity form has various BI
gadgets, i.e. embedded viewer gadget 61, navigation and search gadget 62, ad hoc query gadget 63, analysis gadget 64, and post analysis gadget 65. .
[0050] The embedded viewer gadget 61 is represented as the interface between the business process activity 220 and the business process activity form. The viewer gadget 61 allows the user to interact with the form.
[0051] The interface 233 between the business process repository 234 and the BI
model 232, which is shown as a BI metadata model 90 in Figure 5, represents the BI
gadgets manager 50. It makes available to a business process modeller the BI
content stored in the BI model 232, such as reports, report definitions, and analysis cubes. The BI gadgets manager 50 enables a business process modeller or form author to embed into the business process activity form BI gadgets 60 that are relevant to the process activity 220 and can be called up by the user who assigned the process activity 220 from inside of the business process activity form.
The BI
gadgets may be "clickable" and may be navigable.
[0052] BI server 248 shown in Figure 8 is a server having various BI tools for extracting data from corporate data sources 240, including enterprise applications 242, data warehouse 244 and transactional databases 246. The interface 222 between the business process activity 220 and the BI server 248 is the real-time (run-time) complement of the interface 233. The BI content is not pre-defined, but is determined at run-time, taking into context and the status of the process, e.g., what paths were taken to get to this point, and what data values have been collected from the user.
[0053] The embedded navigation and search gadget 62 is represented as the interface 224 between the business process activity 220 and search BI 260.
This is similar to the interface 222 but instead of displaying a list of relevant BI
content, the navigation and search gadget 62 presents the user with a GoogleTM-like search field.
For example, the navigation and search gadget 62 brings up a list of all reports relating to search terms, e.g., Sales of Shoeware Products in the U.K. Using the navigation and search gadget 62, the user determines or finds the BI content relevant to the process activity 220.
[0054] The embedded ad hoc query gadget 63 is represented as the interface 226 between the business process activity 220 and an ad-hoc query 250. The ad hoc query gadget 63 enables the user to form own business queries from inside of the business process activity form. This is in contrast to the interfaces 233 and 222 that provide a more structured access to the information, through usually predefined queries. In the case of interface 222, it is capable of limited variability of access to the information.
[0055] The embedded analysis gadget 64 combines the functions of the navigation and search gadget 62 and ad hoc query gadget 63.
[0056] The embedded post analysis gadget 65 is represented as the interface between the business process activity 220 and an audit/compliance database 270.
This is an optional component used for compiling and audit the history of activity of the system. Thus, the audit/compliance database 270 is accessed to record activities, and also to permit display of previous activities.
[0057] Once the user makes a decision, i.e., fills out the business process activity form for the process activity 220, the BPM system 10, 12 brings the business process to the next business process activity 210 and generates a business process activity form associated with the process activity 210.
[0058] The following scenarios illustrate examples of the use of business process activity forms with embedded Bi gadgets.
[0059] Consider a company that has a large number of products to sell. The company has implemented a business process management (BPM) system that can improve the customer order process. The following scenario illustrates how business intelligence (BI) is incorporated within such a BPM system.
[0060] One common process activity for selling products is where an agent needs to offer an aftractive discount for a customer. The company has already provided an intelligent discounting tool, Step Processor, based on current inventory levels of the product and type of customer. The following sequence of actions is carried out by the sales agent within a business process activity form generated by the BPM
model 232, which is shown as a BI metadata model 90 in Figure 5, represents the BI
gadgets manager 50. It makes available to a business process modeller the BI
content stored in the BI model 232, such as reports, report definitions, and analysis cubes. The BI gadgets manager 50 enables a business process modeller or form author to embed into the business process activity form BI gadgets 60 that are relevant to the process activity 220 and can be called up by the user who assigned the process activity 220 from inside of the business process activity form.
The BI
gadgets may be "clickable" and may be navigable.
[0052] BI server 248 shown in Figure 8 is a server having various BI tools for extracting data from corporate data sources 240, including enterprise applications 242, data warehouse 244 and transactional databases 246. The interface 222 between the business process activity 220 and the BI server 248 is the real-time (run-time) complement of the interface 233. The BI content is not pre-defined, but is determined at run-time, taking into context and the status of the process, e.g., what paths were taken to get to this point, and what data values have been collected from the user.
[0053] The embedded navigation and search gadget 62 is represented as the interface 224 between the business process activity 220 and search BI 260.
This is similar to the interface 222 but instead of displaying a list of relevant BI
content, the navigation and search gadget 62 presents the user with a GoogleTM-like search field.
For example, the navigation and search gadget 62 brings up a list of all reports relating to search terms, e.g., Sales of Shoeware Products in the U.K. Using the navigation and search gadget 62, the user determines or finds the BI content relevant to the process activity 220.
[0054] The embedded ad hoc query gadget 63 is represented as the interface 226 between the business process activity 220 and an ad-hoc query 250. The ad hoc query gadget 63 enables the user to form own business queries from inside of the business process activity form. This is in contrast to the interfaces 233 and 222 that provide a more structured access to the information, through usually predefined queries. In the case of interface 222, it is capable of limited variability of access to the information.
[0055] The embedded analysis gadget 64 combines the functions of the navigation and search gadget 62 and ad hoc query gadget 63.
[0056] The embedded post analysis gadget 65 is represented as the interface between the business process activity 220 and an audit/compliance database 270.
This is an optional component used for compiling and audit the history of activity of the system. Thus, the audit/compliance database 270 is accessed to record activities, and also to permit display of previous activities.
[0057] Once the user makes a decision, i.e., fills out the business process activity form for the process activity 220, the BPM system 10, 12 brings the business process to the next business process activity 210 and generates a business process activity form associated with the process activity 210.
[0058] The following scenarios illustrate examples of the use of business process activity forms with embedded Bi gadgets.
[0059] Consider a company that has a large number of products to sell. The company has implemented a business process management (BPM) system that can improve the customer order process. The following scenario illustrates how business intelligence (BI) is incorporated within such a BPM system.
[0060] One common process activity for selling products is where an agent needs to offer an aftractive discount for a customer. The company has already provided an intelligent discounting tool, Step Processor, based on current inventory levels of the product and type of customer. The following sequence of actions is carried out by the sales agent within a business process activity form generated by the BPM
system. The business process activity form has an embedded viewer gadget 61, search gadget 62, analysis gadget 64 and ad hoc query gadget 63.
[0061] Figure 9 schematically illustrates the sequence of the actions for a request-for-quote workflow process. Figure 11 shows interactions of components during the process.
[0062] At 500, a request for quote (RFQ) form which is a business process activity form is filled out by the customer, which automatically initiates the RFQ
workflow process. At 510, when the sales agent opens the Step Processor, the sales agent receives the request for quote from the customer in his work inbox within a portal environment. Figure 10 shows an example of a Step Process interface. On the first tab are the details of the customer which are pulled up automatically from the workflow data fields through the embedded viewer gadget 61.
[0063] Within the quote form, the agent is automatically presented (530) through the embedded viewer gadget 61 with reports retrieved from a repository of the BI
server 248. The reports show the current inventory levels of the products (Report that appears on the bottom-left on Figure 10), the customer information (Report on bottom-right pane on Figure 10), and possible discount scenarios. Other workflow data fields contain the information for retrieving the reports from the BI
server 248.
The data fields are in the form of String arrays which contain information {<Package Name>, <Folder Name>, <Report Name>}. These values are parsed and passed as parameters in a call that retrieves the corresponding reports from the data source 240.
[0064] The sales agent needs to make the quota for the quarter and this order is very critical to achieving that goal. The agent wants to give an attractive discount for the customer, which is beyond the recommended discounts on the form. In order to offer additional discount, the agent needs to understand the credit rating of the customer, determine if this customer is profitable, and possibly look at past decisions that have been made. To this end, the sales agent types in the discount into the Step Processor data field called "Discount." The value of that data field gets written back to the work item by the BPM system. The work item gets dispatched onto the next step.
[0065] The search gadget 62 is embedded in a second tab in the Step Processor.
The agent uses the embedded search gadget 62 to find the customer credit rating, the payment terms and payment history, and other Business Intelligence information.
The embedded search gadget 62 passes a package name relating to the requested information into the second tab and used as context to present the agent with a search screen with the correct package already opened up (550).
[0066] The embedded search gadget 62 obtains the relevant information not only from the data in the transactional system, but also from many data assets utilized within the company including data warehouses, and other modern and local data sources (XML, Excel, etc).
[0067] The sales agent may also conduct some analysis on this data (540), using the embedded analysis gadget 64, to see how this customer compares to others, how the customer activity has averaged over time or in comparison to industry benchmarks, etc. With this information and newly formed knowledge, the sales agent is ready to fill the form to offer the additional discount. This additional information may be consolidated into a report that is saved on the Bl server 248 and linked into the step processor and/or saved as a document that is added to the form as a workflow attachment.
[0068] Since the additional discount being offered is beyond the standard policy, the sales agent is required to fill in extra information in the business process activity form.
The sales agent picks the reason for further discounting as "good credit score". The embedded BI gadgets automatically fills the fields like the payment history, and external agency scoring for that customer.
[0061] Figure 9 schematically illustrates the sequence of the actions for a request-for-quote workflow process. Figure 11 shows interactions of components during the process.
[0062] At 500, a request for quote (RFQ) form which is a business process activity form is filled out by the customer, which automatically initiates the RFQ
workflow process. At 510, when the sales agent opens the Step Processor, the sales agent receives the request for quote from the customer in his work inbox within a portal environment. Figure 10 shows an example of a Step Process interface. On the first tab are the details of the customer which are pulled up automatically from the workflow data fields through the embedded viewer gadget 61.
[0063] Within the quote form, the agent is automatically presented (530) through the embedded viewer gadget 61 with reports retrieved from a repository of the BI
server 248. The reports show the current inventory levels of the products (Report that appears on the bottom-left on Figure 10), the customer information (Report on bottom-right pane on Figure 10), and possible discount scenarios. Other workflow data fields contain the information for retrieving the reports from the BI
server 248.
The data fields are in the form of String arrays which contain information {<Package Name>, <Folder Name>, <Report Name>}. These values are parsed and passed as parameters in a call that retrieves the corresponding reports from the data source 240.
[0064] The sales agent needs to make the quota for the quarter and this order is very critical to achieving that goal. The agent wants to give an attractive discount for the customer, which is beyond the recommended discounts on the form. In order to offer additional discount, the agent needs to understand the credit rating of the customer, determine if this customer is profitable, and possibly look at past decisions that have been made. To this end, the sales agent types in the discount into the Step Processor data field called "Discount." The value of that data field gets written back to the work item by the BPM system. The work item gets dispatched onto the next step.
[0065] The search gadget 62 is embedded in a second tab in the Step Processor.
The agent uses the embedded search gadget 62 to find the customer credit rating, the payment terms and payment history, and other Business Intelligence information.
The embedded search gadget 62 passes a package name relating to the requested information into the second tab and used as context to present the agent with a search screen with the correct package already opened up (550).
[0066] The embedded search gadget 62 obtains the relevant information not only from the data in the transactional system, but also from many data assets utilized within the company including data warehouses, and other modern and local data sources (XML, Excel, etc).
[0067] The sales agent may also conduct some analysis on this data (540), using the embedded analysis gadget 64, to see how this customer compares to others, how the customer activity has averaged over time or in comparison to industry benchmarks, etc. With this information and newly formed knowledge, the sales agent is ready to fill the form to offer the additional discount. This additional information may be consolidated into a report that is saved on the Bl server 248 and linked into the step processor and/or saved as a document that is added to the form as a workflow attachment.
[0068] Since the additional discount being offered is beyond the standard policy, the sales agent is required to fill in extra information in the business process activity form.
The sales agent picks the reason for further discounting as "good credit score". The embedded BI gadgets automatically fills the fields like the payment history, and external agency scoring for that customer.
[0069] Further, the sales agent wants to make sure that the case for additional discount is solid when it comes to the manager for approval. The agent decides to fili in extra information fields with historical discount percentage offered to this customer.
The sales agent in the business process activity form clicks on the embedded ad hoc query gadget 63 and creates a customer discount history query using the business semantics and fills in the extra information field (540). With all this data filled in, the sales agent submits with great confidence the quote activity form to the next step for approval from the manager at 520.
[0070] In a second example, a company has plans to expand into new regions, where it requires local offices. The company has implemented a business process management system to support optimal location identification that includes such activities as: "consider regional financial projections", "elicit regional political data and economic forecasts", "determine timeline and resource requirements for product localization", and "determine local support resource availability".
[0071] Consider the process activity where a researcher needs to determine, and potentially adjust, timeline and resource requirements for product localization. Thus, the following sequence of actions is carried out by the researcher within a business process activity form. The business process activity form has an embedded viewer gadget 61, search gadget 62, analysis gadget 64 and ad hoc query gadget 63.
[0072] The researcher receives a Process activity notification. After clicking on the notification, the researcher is presented with the business process activity form that has a pre-defined (at process design time) BI report viewer. The report shows the timelines and planned resources for localizing the company's products for various regions.
[0073] The researcher runs a BI report on market projections for each of the candidate locations using embedded analysis gadget 64. Noting that Dubai is at the top for new, untapped markets; and referring to the report that Dubai localization is planned for 18 months out, the researcher invokes the ad hoc query gadget 63 and creates a query of local third party support resources, such as availability and skill level, that may be utilized for product localization.
[0074] The researcher clicks on a button in the business process activity form to recommend to the product manager that the timeline and resources be adjusted/acce(erated for accommodating a 6-month product localization target for Dubai. The business process activity form is passed on to the product manager for action, together with the report and query results from the process activity.
[0075] As demonstrated in the above examples, there are numerous scenarios similar to the above-described scenarios can be identified within an organization.
Generalizing these process activities, the BPM system 10, 12 uses BI gadgets to permit the automated incorporation of BI within BPM to support management processes.
[0076] As described above, the business process management system 10, 12 allows non-software-developers to embed Bt gadgets business process activity forms so that run-time users, e.g., managers without programming skills, can receive in-context and in-place or in form reports and analysis. Thus, up-to-date BI can be embedded directly inside of the business process management workflow. The business process management system 10, 12 also allows the placing of appropriate navigation controls or gadgets to allow users to select from pertinent BI
content.
Thus, administrators and users can embed, leverage, and exploit Business Intelligence data without knowledge of SQL or MDX. Management activities and decisions can be tracked and recorded, thus improving management performance, communications, and compliance. The business process management system 10, 12 can constitute a "system of record" upon completion of the decision.
[0077] The business process management system 10, 12 can also address the "information overload" problem that many managers face. The business process management system 10, 12 can deliver BI to managers in the context of business processes, i.e., the right information to the right user at the right time. In some cases the administrator, in setting up the form, elects to provide the user with a navigation option to select from a series of Business Intelligence artifacts that are derived from or directly based on the enterprise databases using the functions of the business intelligence tools suite.
[0078] The business process management system 10, 12 may automatically provide the user with 'secured' content, gaining access to appropriate reports and analysis.
Context can be passed from the BPM process to the BI artifact, e.g., the report, the analysis, and the navigation control, in order to improve the efficiency of the user as well as the administrator who can create dynamic content, which adjusts for various BPM conditions.
[0079] The business process management system enables Business Intelligence to be embedded within business processes to support management participation and run-time decision-making based on near real time or business real time data.
The information leading to the decision, and more specifically the Business Intelligence used as part of a management decision, can be captured for historic reference, such as audit or compliance and also to assist in process improvement.
[0080] The business process management system may be conveniently embodied in an executable or loadable software package, which may be transmitted over data links, or stored on a computer readable medium, for ease of installation on appropriately configured computers.
[0081] The business process management system of the invention may be implemented by any hardware, software or a combination of hardware and software having the above described functions. The software code, instructions and/or statements, either in its entirety or a part thereof, may be stored in a computer readable memory. Further, a computer data signal representing the software code, instructions and/or statements may be embedded in a carrier wave may be transmitted via a communication network. Such a computer readable memory and a computer data signal and/or its carrier are also within the scope of the present invention, as well as the hardware, software and the combination thereof.
[0082] While particular embodiments of the present invention have been shown and described, changes and modifications may be made to such embodiments without departing from the scope of the invention. For example, the elements of the business process management system are described separately, however, two or more elements may be provided as a single element, or one or more elements may be shared with other components in one or more computer systems.
The sales agent in the business process activity form clicks on the embedded ad hoc query gadget 63 and creates a customer discount history query using the business semantics and fills in the extra information field (540). With all this data filled in, the sales agent submits with great confidence the quote activity form to the next step for approval from the manager at 520.
[0070] In a second example, a company has plans to expand into new regions, where it requires local offices. The company has implemented a business process management system to support optimal location identification that includes such activities as: "consider regional financial projections", "elicit regional political data and economic forecasts", "determine timeline and resource requirements for product localization", and "determine local support resource availability".
[0071] Consider the process activity where a researcher needs to determine, and potentially adjust, timeline and resource requirements for product localization. Thus, the following sequence of actions is carried out by the researcher within a business process activity form. The business process activity form has an embedded viewer gadget 61, search gadget 62, analysis gadget 64 and ad hoc query gadget 63.
[0072] The researcher receives a Process activity notification. After clicking on the notification, the researcher is presented with the business process activity form that has a pre-defined (at process design time) BI report viewer. The report shows the timelines and planned resources for localizing the company's products for various regions.
[0073] The researcher runs a BI report on market projections for each of the candidate locations using embedded analysis gadget 64. Noting that Dubai is at the top for new, untapped markets; and referring to the report that Dubai localization is planned for 18 months out, the researcher invokes the ad hoc query gadget 63 and creates a query of local third party support resources, such as availability and skill level, that may be utilized for product localization.
[0074] The researcher clicks on a button in the business process activity form to recommend to the product manager that the timeline and resources be adjusted/acce(erated for accommodating a 6-month product localization target for Dubai. The business process activity form is passed on to the product manager for action, together with the report and query results from the process activity.
[0075] As demonstrated in the above examples, there are numerous scenarios similar to the above-described scenarios can be identified within an organization.
Generalizing these process activities, the BPM system 10, 12 uses BI gadgets to permit the automated incorporation of BI within BPM to support management processes.
[0076] As described above, the business process management system 10, 12 allows non-software-developers to embed Bt gadgets business process activity forms so that run-time users, e.g., managers without programming skills, can receive in-context and in-place or in form reports and analysis. Thus, up-to-date BI can be embedded directly inside of the business process management workflow. The business process management system 10, 12 also allows the placing of appropriate navigation controls or gadgets to allow users to select from pertinent BI
content.
Thus, administrators and users can embed, leverage, and exploit Business Intelligence data without knowledge of SQL or MDX. Management activities and decisions can be tracked and recorded, thus improving management performance, communications, and compliance. The business process management system 10, 12 can constitute a "system of record" upon completion of the decision.
[0077] The business process management system 10, 12 can also address the "information overload" problem that many managers face. The business process management system 10, 12 can deliver BI to managers in the context of business processes, i.e., the right information to the right user at the right time. In some cases the administrator, in setting up the form, elects to provide the user with a navigation option to select from a series of Business Intelligence artifacts that are derived from or directly based on the enterprise databases using the functions of the business intelligence tools suite.
[0078] The business process management system 10, 12 may automatically provide the user with 'secured' content, gaining access to appropriate reports and analysis.
Context can be passed from the BPM process to the BI artifact, e.g., the report, the analysis, and the navigation control, in order to improve the efficiency of the user as well as the administrator who can create dynamic content, which adjusts for various BPM conditions.
[0079] The business process management system enables Business Intelligence to be embedded within business processes to support management participation and run-time decision-making based on near real time or business real time data.
The information leading to the decision, and more specifically the Business Intelligence used as part of a management decision, can be captured for historic reference, such as audit or compliance and also to assist in process improvement.
[0080] The business process management system may be conveniently embodied in an executable or loadable software package, which may be transmitted over data links, or stored on a computer readable medium, for ease of installation on appropriately configured computers.
[0081] The business process management system of the invention may be implemented by any hardware, software or a combination of hardware and software having the above described functions. The software code, instructions and/or statements, either in its entirety or a part thereof, may be stored in a computer readable memory. Further, a computer data signal representing the software code, instructions and/or statements may be embedded in a carrier wave may be transmitted via a communication network. Such a computer readable memory and a computer data signal and/or its carrier are also within the scope of the present invention, as well as the hardware, software and the combination thereof.
[0082] While particular embodiments of the present invention have been shown and described, changes and modifications may be made to such embodiments without departing from the scope of the invention. For example, the elements of the business process management system are described separately, however, two or more elements may be provided as a single element, or one or more elements may be shared with other components in one or more computer systems.
Claims (26)
1. A business process management system for managing business process using data from one or more data sources of an organization, the business process management system comprising:
a business process activity form generator for generating business process activity forms, each business process activity form for presenting to a user relevant data for a business process activity represented by the business process activity form;
one or more business intelligence (BI) gadgets, each providing a predefined functionality for extracting data from the data sources; and a BI gadgets manager for enabling embedment of one or more of the BI
gadgets into the business process activity forms.
a business process activity form generator for generating business process activity forms, each business process activity form for presenting to a user relevant data for a business process activity represented by the business process activity form;
one or more business intelligence (BI) gadgets, each providing a predefined functionality for extracting data from the data sources; and a BI gadgets manager for enabling embedment of one or more of the BI
gadgets into the business process activity forms.
2. The business process management system as claimed in claim 1, wherein the BI
gadgets dynamically update the business process activity forms according to the functionalities provided by the embedded BI gadgets.
gadgets dynamically update the business process activity forms according to the functionalities provided by the embedded BI gadgets.
3. The business process management system as claimed in claim 1, wherein the business process activity form generator uses one or more business process activity models representing business processes activities and process paths among the process activities.
4. The business process management system as claimed in claim 1, wherein one or more of the embedded BI gadgets provides a report, query and/or search.
5. The business process management system as claimed in claim 1, wherein the BI
gadgets manager comprises:
a context manager for extracting context from a business process activity form; and a BI gadgets provider for providing one or more of the BI gadgets to the process activity form generator based on the extracted context.
gadgets manager comprises:
a context manager for extracting context from a business process activity form; and a BI gadgets provider for providing one or more of the BI gadgets to the process activity form generator based on the extracted context.
6. The business process management system as claimed in claim 5, wherein the context manager extracts the context of the business process activity form using data embedded in the business process activity form at the design-time, data pre-populated in the business process activity form at run-time, and/or data entered by a user into the business process activity form.
7. The business process management system as claimed in claim 1, wherein the BI gadgets manager uses a BI metadata model storing BI metadata of the organization, and one of the BI gadgets is a mapping gadget that maps between contextual data in a business process activity form and the BI metadata in the BI metadata model.
8. The business process management system as claimed in claim 1, wherein one of the BI gadgets is a viewer gadget for exposing BI data inside of a business process activity form.
9. The business process management system as claimed in claim 1, wherein one of the BI gadgets is a search gadget for providing searching functionality to search data stored in the data sources; and the BI gadgets manager provides the search gadget for embedment in a field of a business process activity form to provide a user with access to the searching functionality within the business process activity form.
10.The business process management system as claimed in claim 1, wherein one of the BI gadgets is a navigation gadget for providing navigation functionality allowing a user to navigate BI content from a business process activity form.
11. The business process management system as claimed in claim 1, wherein one of the BI gadgets is an ad hoc query gadget for providing ad hoc query functionality in a business process activity form.
12.The business process management system as claimed in claim 11, wherein the ad hoc query gadget allows a user to define a query and automatically generates query parameters based on context of the business process activity form.
13.The business process management system as claimed in claim 1, wherein one of the BI gadgets is an analysis gadget for providing analysis functionality in a business process activity form for filling in input information.
14.The business process management system as claimed in claim 13, wherein the analysis gadget allows a user to define an analysis and automatically generates analysis parameters based on context of the business process activity form.
15.The business process management system as claimed in claim 1, wherein one of the BI gadgets is a post analysis gadgets for storing business process data including BI content and context of a business process activity form together with actions taken in the business process activity form.
16.The business process management system as claimed in claim 15, wherein the BI gadget manager has a business process data storage for storing the business process data.
17.The business process management system as claimed in claim 15, wherein the BI gadget manager has a BI gadget utilization recorder for recording utilization of the BI gadgets utilized in the business process activity forms together with results of the BI gadgets utilization by users.
18.The business process management system as claimed in claim 1, wherein the BI
gadgets include Web Services for Remote Portlets (WSPR)-compliant portlets and/or portlets based on Hyper Text Mark-up Language (HTML).
gadgets include Web Services for Remote Portlets (WSPR)-compliant portlets and/or portlets based on Hyper Text Mark-up Language (HTML).
19.The business process management system as claimed in claim 1, wherein the BI
gadgets manager embeds data in the business process activity forms using the BI
gadgets as a proxy.
gadgets manager embeds data in the business process activity forms using the BI
gadgets as a proxy.
20.The business process management system as claimed in claim 1, wherein the business process activity form having one or more embedded BI gadgets provides run-time process path branching for a user to determine a next process activity based on BI information delivered to the user in the business process activity form by the embedded BI gadgets.
21.A method of managing business process using data from one or more data sources of an organization, the method comprising the steps of:
providing one or more business intelligence (BI) gadgets, each providing a predefined functionality for extracting data from the data sources;
generating a business process activity form represented a business process activity; and embedding one or more of the BI gadgets into the business process activity form for allowing a user to access the functionality of the embedded BI
gadgets from the business process activity form.
providing one or more business intelligence (BI) gadgets, each providing a predefined functionality for extracting data from the data sources;
generating a business process activity form represented a business process activity; and embedding one or more of the BI gadgets into the business process activity form for allowing a user to access the functionality of the embedded BI
gadgets from the business process activity form.
22. The method as claimed in claim 21 further comprising the step of:
dynamically updating the business process activity form according to the functionalities provided by the embedded BI gadgets.
dynamically updating the business process activity form according to the functionalities provided by the embedded BI gadgets.
23.The method as claimed in claim 21 further comprising the steps of:
extracting context from a business process activity form; and providing one or more of the BI gadgets to the process activity form generator based on the extracted context.
extracting context from a business process activity form; and providing one or more of the BI gadgets to the process activity form generator based on the extracted context.
24. The method as claimed in claim 21 further comprising the step of:
storing business process data including BI content and context of a business process activity form together with actions taken in the business process activity form.
storing business process data including BI content and context of a business process activity form together with actions taken in the business process activity form.
25.A computer readable medium storing instructions and/or statements for use in the execution in a computer of a method of managing business process using data from one or more data sources of an organization, the method comprising the steps of:
providing one or more business intelligence (BI) gadgets, each providing a predefined functionality for extracting data from the data sources;
generating a business process activity form represented a business process activity; and embedding one or more of the BI gadgets into the business process activity form for allowing a user to access the functionality of the embedded BI
gadgets from the business process activity form.
providing one or more business intelligence (BI) gadgets, each providing a predefined functionality for extracting data from the data sources;
generating a business process activity form represented a business process activity; and embedding one or more of the BI gadgets into the business process activity form for allowing a user to access the functionality of the embedded BI
gadgets from the business process activity form.
26.A propagated signal carrier containing computer executable instructions and/or statements that can be read and executed by a computer, the computer executable instructions being used to execute a method of managing business process using data from one or more data sources of an organization, the method comprising the steps of:
providing one or more business intelligence (BI) gadgets, each providing a predefined functionality for extracting data from the data sources;
generating a business process activity form represented a business process activity; and embedding one or more of the BI gadgets into the business process activity form for allowing a user to access the functionality of the embedded BI
gadgets from the business process activity form.
providing one or more business intelligence (BI) gadgets, each providing a predefined functionality for extracting data from the data sources;
generating a business process activity form represented a business process activity; and embedding one or more of the BI gadgets into the business process activity form for allowing a user to access the functionality of the embedded BI
gadgets from the business process activity form.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CA002606940A CA2606940A1 (en) | 2005-06-30 | 2006-06-23 | Business intelligence incorporated business process management system and method thereof |
Applications Claiming Priority (4)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CA2511196 | 2005-06-30 | ||
| CA002511196A CA2511196A1 (en) | 2005-06-30 | 2005-06-30 | System and method for embedding business data in forms |
| PCT/US2006/024828 WO2007005378A2 (en) | 2005-06-30 | 2006-06-23 | Business intelligence incorporated business process management system and method thereof |
| CA002606940A CA2606940A1 (en) | 2005-06-30 | 2006-06-23 | Business intelligence incorporated business process management system and method thereof |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CA2606940A1 true CA2606940A1 (en) | 2007-01-11 |
Family
ID=38988229
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CA002606940A Abandoned CA2606940A1 (en) | 2005-06-30 | 2006-06-23 | Business intelligence incorporated business process management system and method thereof |
Country Status (1)
| Country | Link |
|---|---|
| CA (1) | CA2606940A1 (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116483872A (en) * | 2023-06-20 | 2023-07-25 | 合肥青谷信息科技有限公司 | Complex data processing method and device and electronic equipment |
-
2006
- 2006-06-23 CA CA002606940A patent/CA2606940A1/en not_active Abandoned
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116483872A (en) * | 2023-06-20 | 2023-07-25 | 合肥青谷信息科技有限公司 | Complex data processing method and device and electronic equipment |
| CN116483872B (en) * | 2023-06-20 | 2023-09-12 | 合肥青谷信息科技有限公司 | Complex data processing method and device and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7707040B2 (en) | Method of generating business intelligence incorporated business process activity forms | |
| US8543527B2 (en) | Method and system for implementing definable actions | |
| US10540636B2 (en) | Method and apparatus for providing process guidance | |
| US8296311B2 (en) | Solution search for software support | |
| CN102385483B (en) | User interface based on context, search and navigation | |
| US7590972B2 (en) | Role-oriented development environment | |
| US7953767B2 (en) | Developing applications using configurable patterns | |
| US7739121B2 (en) | Method and apparatus for providing intelligent and controlled access to supply chain information | |
| US7716253B2 (en) | Centralized KPI framework systems and methods | |
| US7366723B2 (en) | Visual query modeling for configurable patterns | |
| US8412549B2 (en) | Analyzing business data for planning applications | |
| US7565613B2 (en) | User interface incorporating data ecosystem awareness | |
| US7613713B2 (en) | Data ecosystem awareness | |
| US7653638B2 (en) | Data ecosystem awareness | |
| Brambilla et al. | Designing web applications with WebML and WebRatio | |
| US20120179644A1 (en) | Automatic Synthesis and Presentation of OLAP Cubes from Semantically Enriched Data Sources | |
| US20060136409A1 (en) | System for identification of context related information in knowledge sources | |
| US8126937B2 (en) | Visual database modeling | |
| EP2075746A1 (en) | Systems and/or methods for managing transformations in enterprise application integration and/or business processing management environments | |
| US8495510B2 (en) | System and method for managing browser extensions | |
| US8600982B2 (en) | Providing relevant information based on data space activity items | |
| CA2606940A1 (en) | Business intelligence incorporated business process management system and method thereof | |
| US20050060309A1 (en) | Query objects | |
| Tan | Visualization of a restaurant management data analysis using Java Technologies |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| EEER | Examination request | ||
| FZDE | Discontinued |