Business intelligence system and methods

• US 20070038683A1
• Filed: 08/03/2006
• Published: 02/15/2007
• Est. Priority Date: 08/04/2005
• Status: Abandoned Application

• Current Assignee: Pentaho Incorporated (Hitachi, Ltd.)
• Original Assignee: Pentaho Incorporated (Hitachi, Ltd.)
• Inventors: Moran, Doug, Dixon, James, Batchelor, Marc
• Application Number:
  US11/498,943
• Publication Number:
  US 20070038683A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/10 Office automation; Time management

Abstract

In general, the invention relates to a business intelligence platform. In one aspect, data is logged such that information about execution instances can be obtained. In another aspect, action sequences are developed, stored, and executed, such that use of a variety of components can be specified.

Claims

1. A method for logging data in a business process workflow, comprising the steps of:

assigning a session identifier to a user session upon initiation by a user of the user session;

generating first audit data comprising the session identifier and a user identifier;

assigning an instance identifier to an execution instance initiated by the user during the user session;

generating second audit data comprising the session identifier and the instance identifier; and

generating log entries during the execution of the execution instance, the log entries comprising the instance identifier.

2. The method of claim 1 wherein the execution instance comprises tasks to be performed on behalf of the user.

3. The method of claim 2 wherein the execution instance comprises a reporting task.

4. The method of claim 1, further comprising the step of associating the log entries with the session and the user based on the second audit data.

5. The method of claim 4, wherein the step of associating the log entries with the session and the user further comprises associating the additional log entries with the session and the user based on the second audit data comprising the session identifier and the instance identifier, and the first audit data comprising the session identifier and the user identifier.

6. The method of claim 1 wherein the log entries are generated using a log function provided by an application server.

7. The method of claim 1 wherein the log entries are generated using a function provided by a logging tool.

8. The method of claim 1 wherein the initiation of the user session comprises authentication of the user.

9. The method of claim 1, wherein the step of generating log entries during the execution of the execution instance comprises generating a log entry when an action sequence is started.

10. The method of claim 1, wherein the step of generating log entries during the execution of the execution instance comprises generating a log entry when an action sequence is completed.

11. The method of claim 1, wherein the first audit data and the second audit data are stored in a database.

12. The method of claim 1, wherein the first audit data is stored in a log entry.

13. The method of claim 1, wherein the second audit data is stored in a log entry.

14. A system for logging data in a business process workflow, comprising:

an audit data store for storing identifiers of execution instances, session identifiers, and user identifiers; and

a log file that includes for each log file entry generated by an execution instance an identifier of the execution instance that generated the entry.

15. The system of claim 14, wherein the log file further comprises a first log entry generated at the initiation of a session comprising a session identifier and a user identifier.

16. The system of claim 15, further comprising a second log file entry generated at the initiation of an execution instance comprising the session identifier and the instance identifier.

17. The system of claim 14, wherein the log file further includes for each log file entry generated by an execution instance one of the following:

identifier for each process, identifier of the parent of the instance, identifier of an activity, identifier of a component executing the activity, date and time of each event, and relevant attributes.

18. The system of claim 14, wherein the log file further includes for each log file entry generated by an execution instance two or more of the following:

identifier for each process, identifier of each executing instance, identifier of the parent of the instance, identifier of an activity, identifier of a component executing the activity, date and time of each event, and relevant attributes.

19. The system of claim 14, wherein the log file comprises an entry generated when an action sequence is started.

20. The system of claim 19, wherein the log file comprises an entry generated during action execution.

21. The system of claim 20, wherein the log file comprises an entry generated during action sequence completion.

22. The system of claim 14, wherein the log file comprises a relational database table.

23. A method for executing applications that form a business process, comprising:

defining an action sequence comprising a description of business intelligence processes to call and the order in which they should be called;

storing the action sequence in a solution repository;

executing the action sequence such that the business intelligence processes defined in the stored action sequence are called in the order specified, thereby implementing a business process.

24. The method of claim 23, wherein the action sequence comprises a description of components to call and the order in which they should be called.

25. The method of claim 24, wherein the action sequence is implemented in XML.

26. The method of claim 23, wherein the solution repository is a database for storing action sequences.

27. The method of claim 23, wherein the business intelligence processes are business intelligence platform components.

28. The method of claim 27, wherein the output of one component in the action sequence is provided as input to a next component in the action sequence.

29. The method of claim 27, wherein the execution is performed by a runtime engine.

30. The method of claim 23, further comprising:

developing the action sequence; and

testing the action sequence.

31. The method of claim 23, further comprising the step of validating the action sequence.

32. The method of claim 23, wherein the step of storing the action sequence in a solution repository is performed by a solution engine.

33. A business intelligence platform for executing applications that form a business process, comprising:

a development environment for defining an action sequence comprising a description of business intelligence processes to call and the order in which they should be called;

a solution engine for storing the action sequence in a solution repository;

a runtime engine for executing the action sequence such that the business intelligence processes defined in the stored action sequence are called in the order specified, thereby implementing a business process.

34. The system of claim 33, wherein the action sequence comprises a description of components to call and the order in which they should be called.

35. The system of claim 34, wherein the action sequence is implemented in XML.

36. The system of claim 33, wherein the solution repository is a database for storing action sequences.

37. The system of claim 33, wherein the business intelligence processes are business intelligence platform components.

38. The system of claim 33, wherein the output of one component in the action sequence is provided as input to a next component in the action sequence.

39. The system of claim 33, wherein the execution is performed by a runtime engine.

40. The system of claim 33, further comprising:

a development environment for developing the action sequence and

an execution environment for testing the action sequence.

41. The system of claim 33, further comprising the step of validating the action sequence.