Enterprise performance management software system having action-based data capture

• US 20080066067A1
• Filed: 08/10/2007
• Published: 03/13/2008
• Est. Priority Date: 09/07/2006
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: Cognos Incorporated (International Business Machines Corporation)
• Inventors: Stimpson, Mark, Nelmes, Andrew Thomas
• Application Number:
  US11/891,570
• Publication Number:
  US 20080066067A1
• Time in Patent Office: Days
• US Class Current: 718/100
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling

Abstract

Techniques are described of entering and presenting data in an enterprise planning and performance management system. As disclosed herein, the techniques facilitate the capture and entry of data into an underlying multidimensional dataset through action-based forms. In addition, the techniques allow reviewers to use spreadsheet-like views of the captured data. In certain embodiments, the techniques also facilitate straightforward review of changes to data within the spreadsheet-like views by providing a task log that enables reviewers to more readily review, accept, or dismiss such changes.

Claims

1. A computer-implemented method of performing an enterprise planning session, comprising:

receiving model data that defines an enterprise planning model for use within a subsequent enterprise planning session, wherein the model data comprises action data that specifies one or more tasks, and wherein the action data defines;

(i) a plurality of task-specific forms to capture task-specific contribution data for the enterprise planning session on a per-task basis, and (ii) a mapping for storing the task-specific contribution data within a database of multidimensional data; and

executing software to conduct the enterprise planning session in accordance with the model at least in part by;

capturing business-as-usual contribution data associated with ordinary operation of the enterprise from a first set of contributors using a spreadsheet interface,

capturing the task-specific contribution data associated with out-of-the-ordinary operations of the enterprise from a second set of contributors using the task-specific forms and storing the task-specific contribution data within the database according to the mapping,

aggregating the task-specific contribution data and the business-as-usual contribution data to form aggregate contribution data for the enterprise planning session, and

generating a composite forecast from the aggregate contribution data.

2. The method of claim 1, wherein the action data specifies chronological dependencies among the tasks.

3. The method of claim 2, further comprising automatically updating the task-specific contribution data associated with at least one of the plurality of tasks in response to the captured task-specific contribution data and the dependencies specified by the action data.

4. The method of claim 3, wherein executing software to conduct the enterprise planning session comprises:

capturing, via at least one of the corresponding task-specific forms, an actual date of occurrence of at least one of the plurality of tasks;

automatically updating one or more target dates of the other tasks based on the actual date and the defined interdependencies; and

automatically recalculating the aggregate contribution data based on the updated target dates.

5. The method of claim 1,

wherein the task-specific contribution data includes data associated with a variable,

wherein the business-as-usual contribution data includes data associated with the variable;

wherein the variable is associated with an overlay calculation; and

wherein aggregating the task-specific contribution data and the business-as-usual contribution data comprises performing the overlay calculation in order to form aggregate contribution data associated with the variable.

6. The method of claim 4, wherein the method further comprises:

presenting a user interface that enables a user to specify the overlay calculation to associate with the variable; and

receiving input from a user of the user interface, wherein the input specifies the overlay calculation to associate with the variable.

7. The method of claim 1, further comprising:

while executing the enterprise planning session, reviewing the contribution data by presenting a task log that describes a plurality of tasks, each of which has an impact on the task-specific contribution data;

updating the aggregate contribution data to reflect impacts on the task-specific contribution data of selected ones of the tasks described by the task log; and

presenting the composite forecast based on the updated aggregate contribution data.

8. The method of claim 7, wherein reviewing the contribution data comprises includes performing a roll-back operation to remove an impact of one of the tasks described in the task log on the task-specific contribution data in response to input from the user.

9. The method of claim 7, wherein selectively reviewing the contribution data comprises performing a “

show impact”

operation that temporarily shows an impact of one of the tasks described in the task log to the task-specific contribution data.

10. The method of claim 7, further comprising:

presenting a forecast pane that includes a spreadsheet-like or grid view of the aggregate contribution data in conjunction with presenting the task log; and

updating the aggregate contribution data shown within the forecast pane of the action-based contribution data based on selected ones of the tasks described in the task log.

11. The method of claim 1, further comprising automatically invoking one or more applications to issue reminders pertaining to the tasks.

12. The method of claim 1, further comprising storing the captured action-based contribution data to dimensions of the multidimensional data store based on the mapping.

13. The method of claim 1, further comprising configuring the model to define input fields of the task-specific forms.

14. The method of claim 1, wherein executing software to conduct the enterprise planning session further comprises:

presenting a user interface through which a reviewer indicates whether an action defined by the action data was performed; and

automatically generating output representing commentary on the difference between actual and forecasted data based on the indication.

15. The method of claim 13, wherein executing software to conduct the enterprise planning session further comprises automatically generating accrual data based on the difference between the actual and forecasted data based on the indication.

16. The method of claim 1, wherein executing software to conduct the enterprise planning session comprises capturing, via at least one of the corresponding task-specific forms, an ownership of at least one of the plurality of tasks, wherein the ownership indicates permissible contributors of the set of contributors able to enter task data associated with the task.

17. A computing system comprising:

an analysis software module executing on the computing system to receive data that defines an enterprise planning session to be carried out by a set of users associated with a multi-level enterprise hierarchy, wherein the model data comprises action data that specifies one or more tasks, and wherein the action data defines (1) a plurality of task-specific forms to capture task-specific contribution data for the enterprise planning session on a per-task basis, and (ii) a mapping for storing the task-specific contribution data within a database of multidimensional data; and

a contribution module executing on the computing system to conduct the enterprise planning session in accordance with the model at least in part by;

capturing business-as-usual contribution data associated with ordinary operation of the enterprise from a first set of contributors using a spreadsheet interface,

capturing the task-specific contribution data associated with out-of-the-ordinary operations of the enterprise from a second set of contributors using the task-specific forms and storing the task-specific contribution data within the database according to the mapping,

aggregating the task-specific contribution data and the business-as-usual contribution data to form aggregate contribution data for the enterprise planning session, and

generating a composite forecast from the aggregate contribution data.

18. The computing system of claim 17, wherein the action data specifies chronological dependencies among the tasks.

19. The computing system of claim 17, wherein the system automatically updates the task-specific contribution data associated with at least one of the plurality of tasks in response to the captured task-specific contribution data and the dependencies specified by the action data.

20. The computing system of claim 19,

wherein the user interface captures task-specific contribution data by capturing an actual date of occurrence of at least one of the plurality of tasks via at least one of the corresponding task-specific forms,

wherein the system automatically updates one or more target dates of the other tasks based on the actual date and the dependencies, and automatically recalculates the aggregated contribution data based on the updated target dates.

21. The computing system of claim 17,

wherein the task-specific contribution data includes data associated with a variable,

wherein the business-as-usual contribution data includes data associated with the variable;

wherein the variable is associated with an overlay calculation; and

wherein the contribution module aggregates the task-specific contribution data and the business-as-usual contribution data at least in part by performing the overlay calculation in order to form aggregate contribution data associated with the variable.

22. The computing system of claim 21, wherein the system further comprises an application executing on the computing system that presents a user interface that enables a user to specify the overlay calculation to associate with the variable and that receives input from a user of the user interface, wherein the input specifies the overlay calculation to associate with the variable.

23. The computing system of claim 17, wherein the system presents a user interface having a task log that describes a plurality tasks, each of which has an impact on the task-specific contribution data,

wherein the system updates the aggregate contribution data to reflect impacts on the task-specific contribution data of selected ones of the tasks described by the task log, and

wherein the user interface outputs a composite forecast based on the updated aggregate contribution data.

24. The computing system of claim 23, wherein, in response to the input, the system performs a roll-back operation to remove an impact of one of the tasks described in the task log and updates the aggregated contribution data accordingly.

25. The computing system of claim 23, wherein the system selectively accepts one or more of the sequential plurality of pending changes by performing a “

show impact”

operation to temporarily show an impact of one of the tasks described in the task log on the task-specific contribution data and outputs adjusted task-specific contribution data.

26. The computing system of claim 17, wherein the system stores the captured task-specific contribution data to dimensions of the multidimensional data store based on the mapping.

27. The computing system of claim 17, wherein the system receives input from a user to configure the action data to define fields of the task-specific forms and time-based dependencies of the tasks.

28. The computing system of claim 17, wherein the multidimensional data store resides on a server and a client device presents the user interface.

29. The computing system of claim 17,

wherein the contribution module further presents a user interface through which a user indicates whether an action defined by the action data was performed, and

wherein the system further includes a report generator module that automatically generates commentary on the difference between actual and forecasted data based on the indication.

30. The computing system of claim 17, wherein the system further includes a report generator module that automatically generates accrual data on a difference between actual and forecasted data.

31. The computing system of claim 17, wherein contribution module captures the task-specific contribution data from the users using the task-specific forms by capturing, via at least one of the corresponding task-specific forms, an ownership of at least one of the tasks, wherein the ownership indicates permissible users able to enter task-specific data associated with the at least one of the tasks.

32. A computer-readable medium comprising instructions, the instructions causing a programmable processor to:

retrieve model data that defines an enterprise planning model for use within a subsequent enterprise planning session, wherein the model data comprises action data that specifies one or more tasks, and wherein the action data defines;

(i) a plurality of task-specific forms to capture task-specific contribution data for the enterprise planning session on a per-task basis, and (ii) a mapping for storing the task-specific contribution data within a database of multidimensional data; and

execute software to conduct the enterprise planning session in accordance with the model at least in part by causing the programmable processor to;

capture business-as-usual contribution data associated with ordinary operation of the enterprise from a first set of contributors using a spreadsheet interface,

capture the task-specific contribution data associated with out-of-the-ordinary operations of the enterprise from a second set of contributors using the task-specific forms and storing the task-specific contribution data within the database according to the mapping,

aggregate the task-specific contribution data and the business-as-usual contribution data to form aggregate contribution data for the enterprise planning session, and

generate a composite forecast from the aggregate contribution data.

33. The computer-readable medium of claim 32, wherein the action data specifies chronological dependencies among the tasks.

34. The computer-readable medium of claim 32,

wherein the task-specific contribution data includes data associated with a variable,

wherein the business-as-usual contribution data includes data associated with the variable;

wherein the variable is associated with an overlay calculation; and

wherein the instructions cause the programmable processor to aggregate the task-specific contribution data and the business-as-usual contribution data at least in part by causing the programmable processor to perform the overlay calculation in order to form aggregate contribution data associated with the variable.