A report generation method and system. The system comprises a computing system comprising data. The computing system presents a first list comprising process categories for a plurality of processes. The computing system receives first selection of a process category from the first list. The computing system presents a second list comprising peer group options associated with the process categories. The computing system receives a second selection of at least one peer group option from the second list. The computing system retrieves a portion of from the data. The portion is associated with the first selection and the second selection. The computing system calculates a plurality of values for attributes associated with the first selection and the second selection. The computing system generates a report comprising the plurality of values.
|
1. A report generation method within a computing system, said computing system comprising a memory device, said memory device comprising data, said method comprising:
presenting, by said computing system to a user of said computing system, a first list comprising process categories for a plurality of processes;
receiving, by said computing system from said user, a first selection of a process category from said first list;
presenting, by said computing system to said user, a user peer selection interface comprising a second list comprising first peer group options associated with said process categories and an additional list comprising additional peer group options associated with a selection of said first peer group options, wherein said first peer group options comprise options associated with a specified industry, a specified region, a role for ordering materials, a system for ordering materials, and current market conditions, and wherein said additional peer group options comprise options associated with government types and manufacturing types;
receiving, by said computing system from said user, a second selection of at least one peer group option from said first peer group options of said second list;
receiving, by said computing system from said user based on said second selection, an additional selection of at least one peer group option from said additional peer group options of said additional list;
retrieving, by said computing system, a portion of data from said data, said portion of data associated with said first selection, said second selection, and said additional selection;
calculating, by said computing system, a plurality of values for attributes associated with said first selection, said second selection, and said additional selection, said calculating based on said portion of data, said calculating said plurality of values comprising calculating: benchmark values, median values, and business driver values associated with said first selection, said second selection, and said additional selection;
presenting, by said computing system to said user via a benchmark wizard interface, a plurality of currency selections and associated exchange rates;
receiving, by said computing system from said user in response to said presenting said plurality of currency selections and said associated exchange rates, a specified currency selection and exchange rate for displaying said benchmark values and said median values;
receiving, by said computing system from said user in response to said presenting said plurality of currency selections and said associated exchange rates, a specified conversion direction associated with said specified currency selection and exchange rate;
changing, by said computing system in response to said specified currency selection and exchange rate and said specified conversion direction, a first currency association for said benchmark values and said median values to a second currency association for said benchmark values and said median values;
generating, by said computing system, a report comprising said plurality of values, wherein said report comprises a first portion, a second portion, and a third portion, wherein said first portion comprises said benchmark values and said median values listed in association with said specified currency selection, wherein said first portion comprises a cost measures section, a cycle time measures section, and an efficiency and quality measures section, wherein said second portion comprises costs associated with said business driver values, and wherein said third portion comprises leading practice statements and case studies; and
independently printing or displaying, by said computing system, said first portion, said second portion, and said third portion of said report.
7. A computing system comprising a processor coupled to a computer-readable memory unit, said memory unit comprising data and instructions that when executed by the processor implement a report generation method, said method comprising:
presenting, by said computing system to a user of said computing system, a first list comprising process categories for a plurality of processes;
receiving, by said computing system from said user, a first selection of a process category from said first list;
presenting, by said computing system to said user, a user peer selection interface comprising a second list comprising first peer group options associated with said process categories and an additional list comprising additional peer group options associated with a selection of said first peer group options, wherein said first peer group options comprise options associated with a specified industry, a specified region, a role for ordering materials, a system for ordering materials, and current market conditions, and wherein said additional peer group options comprise options associated with government types and manufacturing types;
receiving, by said computing system from said user, a second selection of at least one peer group option from said first peer group options of said second list;
receiving, by said computing system from said user based on said second selection, an additional selection of at least one peer group option from said additional peer group options of said additional list;
retrieving, by said computing system, a portion of data from said data, said portion of data associated with said first selection, said second selection, and said additional selection;
calculating, by said computing system, a plurality of values for attributes associated with said first selection, said second selection, and said additional selection, said calculating based on said portion of data, said calculating said plurality of values comprising calculating: benchmark values, median values, and business driver values associated with said first selection, said second selection, and said additional selection;
presenting, by said computing system to said user via a benchmark wizard interface, a plurality of currency selections and associated exchange rates;
receiving, by said computing system from said user in response to said presenting said plurality of currency selections and said associated exchange rates, a specified currency selection and exchange rate for displaying said benchmark values and said median values;
receiving, by said computing system from said user in response to said presenting said plurality of currency selections and said associated exchange rates, a specified conversion direction associated with said specified currency selection and exchange rate;
changing, by said computing system in response to said specified currency selection and exchange rate and said specified conversion direction, a first currency association for said benchmark values and said median values to a second currency association for said benchmark values and said median values;
generating, by said computing system, a report comprising said plurality of values, wherein said report comprises a first portion, a second portion, and a third portion, wherein said first portion comprises said benchmark values and said median values listed in association with said specified currency selection, wherein said first portion comprises a cost measures section, a cycle time measures section, and an efficiency and quality measures section, wherein said second portion comprises costs associated with said business driver values, and wherein said third portion comprises leading practice statements and case studies; and
independently printing or displaying, by said computing system, said first portion, said second portion, and said third portion of said report.
12. A computer program product, comprising a tangible computer readable storage device comprising a computer readable program code embodied therein, said computer readable program code comprising an algorithm adapted to implement a report generation method within a computing system, said computing system comprising data, said method comprising:
presenting, by said computing system to a user of said computing system, a first list comprising process categories for a plurality of processes;
receiving, by said computing system from said user, a first selection of a process category from said first list;
presenting, by said computing system to said user, a user peer selection interface comprising a second list comprising first peer group options associated with said process categories and an additional list comprising additional peer group options associated with a selection of said first peer group options, wherein said first peer group options comprise options associated with a specified industry, a specified region, a role for ordering materials, a system for ordering materials, and current market conditions, and wherein said additional peer group options comprise options associated with government types and manufacturing types;
receiving, by said computing system from said user, a second selection of at least one peer group option from said first peer group options of said second list;
receiving, by said computing system from said user based on said second selection, an additional selection of at least one peer group option from said additional peer group options of said additional list;
retrieving, by said computing system, a portion of data from said data, said portion of data associated with said first selection, said second selection, and said additional selection;
calculating, by said computing system, a plurality of values for attributes associated with said first selection, said second selection, and said additional selection, said calculating based on said portion of data, said calculating said plurality of values comprising calculating: benchmark values, median values, and business driver values associated with said first selection, said second selection, and said additional selection;
presenting, by said computing system to said user via a benchmark wizard interface, a plurality of currency selections and associated exchange rates;
receiving, by said computing system from said user in response to said presenting said plurality of currency selections and said associated exchange rates, a specified currency selection and exchange rate for displaying said benchmark values and said median values;
receiving, by said computing system from said user in response to said presenting said plurality of currency selections and said associated exchange rates, a specified conversion direction associated with said specified currency selection and exchange rate;
changing, by said computing system in response to said specified currency selection and exchange rate and said specified conversion direction, a first currency association for said benchmark values and said median values to a second currency association for said benchmark values and said median values;
generating, by said computing system, a report comprising said plurality of values, wherein said report comprises a first portion, a second portion, and a third portion, wherein said first portion comprises said benchmark values and said median values listed in association with said specified currency selection, wherein said first portion comprises a cost measures section, a cycle time measures section, and an efficiency and quality measures section, wherein said second portion comprises costs associated with said business driver values, and wherein said third portion comprises leading practice statements and case studies; and
independently printing or displaying, by said computing system, said first portion, said second portion, and said third portion of said report.
2. The method of
3. The method of
4. The method of
5. The method of
presenting, by said computing system to said user, a third list comprising currency options associated with said process categories;
receiving, by said computing system from said user, a third selection for at least one currency option from said third list, wherein said portion of data is further associated with said third selection, and wherein said calculating said plurality of values comprises calculating values for attributes associated with said third selection.
6. The method of
providing at least one support service for at least one of creating, integrating, hosting, maintaining, and deploying computer-readable code in said computing system, wherein the code in combination with the computing system is capable of performing: said presenting said first list, said receiving said first selection, said presenting said user peer selection interface, said receiving said second selection, said receiving said additional selection, said retrieving, said calculating said plurality of values, said presenting said plurality of currency selections, said receiving said specified currency selection, said receiving said specified conversion direction, said changing, said generating said report, and said independently printing or displaying.
8. The computing system of
9. The computing system of
10. The computing system of
11. The computing system of
presenting, by said computing system to said user, a third list comprising currency options associated with said process categories;
receiving, by said computing system from said user, a third selection for at least one currency option from said third list, wherein said portion of data is further associated with said third selection, and wherein said calculating said plurality of values comprises calculating values for attributes associated with said third selection.
13. The computer program product of
14. The computer program product of
15. The computer program product of
16. The computer program product of
presenting, by said computing system to said user, a third list comprising currency options associated with said process categories;
receiving, by said computing system from said user, a third selection for at least one currency option from said third list, wherein said portion of data is further associated with said third selection, and wherein said calculating said plurality of values comprises calculating values for attributes associated with said third selection.
|
The present invention relates to a system and associated method for generating reports on demand for a user.
Selecting suitable criteria for generating business related documents typically requires a series of steps that may be complicated and inaccurate. Accordingly, there exists a need in the art to overcome the deficiencies and limitations described herein above.
The present invention provides a report generation method within a computing system, said computing system comprising a memory device, said memory device comprising data, said method comprising:
presenting, by said computing system to a user of said computing system, a first list comprising process categories for a plurality of processes;
receiving, by said computing system from said user, a first selection of a process category from said first list;
presenting, by said computing system to said user, a second list comprising peer group options associated with said process categories;
receiving, by said computing system from said user, a second selection of at least one peer group option from said second list;
retrieving, by said computing system, a portion of data from said data, said portion of data associated with said first selection and said second selection;
calculating, by said computing system, a plurality of values for attributes associated with said first selection and said second selection, said calculating based on said portion of data;
generating, by said computing system, a report comprising said plurality of values; and
printing or displaying, by said computing system, said report.
The present invention provides a computing system comprising a processor coupled to a computer-readable memory unit, said memory unit comprising data and instructions that when executed by the processor implement a report generation method, said method comprising:
presenting, by said computing system to a user of said computing system, a first list comprising process categories for a plurality of processes;
receiving, by said computing system from said user, a first selection of a process category from said first list;
presenting, by said computing system to said user, a second list comprising peer group options associated with said process categories;
receiving, by said computing system from said user, a second selection of at least one peer group option from said second list;
retrieving, by said computing system, a portion of data from said data, said portion of data associated with said first selection and said second selection;
calculating, by said computing system, a plurality of values for attributes associated with said first selection and said second selection, said calculating based on said portion of data;
generating, by said computing system, a report comprising said plurality of values; and
printing or displaying, by said computing system, said report.
The present invention provides a computer program product, comprising a computer usable medium comprising a computer readable program code embodied therein, said computer readable program code comprising an algorithm adapted to implement a report generation method within a computing system, said computing system comprising data, said method comprising:
presenting, by said computing system to a user of said computing system, a first list comprising process categories for a plurality of processes;
receiving, by said computing system from said user, a first selection of a process category from said first list;
presenting, by said computing system to said user, a second list comprising peer group options associated with said process categories;
receiving, by said computing system from said user, a second selection of at least one peer group option from said second list;
retrieving, by said computing system, a portion of data from said data, said portion of data associated with said first selection and said second selection;
calculating, by said computing system, a plurality of values for attributes associated with said first selection and said second selection, said calculating based on said portion of data;
generating, by said computing system, a report comprising said plurality of values; and
printing or displaying, by said computing system, said report.
The present invention provides a process for integrating computing infrastructure, comprising integrating computer-readable code into a computer system, wherein the computer system comprises a computer usable medium, wherein said computer usable medium comprises data, and wherein the code in combination with the computer system is capable of performing a report generation method comprising:
presenting, by said computing system to a user of said computing system, a first list comprising process categories for a plurality of processes;
receiving, by said computing system from said user, a first selection of a process category from said first list;
presenting, by said computing system to said user, a second list comprising peer group options associated with said process categories;
receiving, by said computing system from said user, a second selection of at least one peer group option from said second list;
retrieving, by said computing system, a portion of data from said data, said portion of data associated with said first selection and said second selection;
calculating, by said computing system, a plurality of values for attributes associated with said first selection and said second selection, said calculating based on said portion of data;
generating, by said computing system, a report comprising said plurality of values; and
printing or displaying, by said computing system, said report.
The present invention advantageously provides a simple method and associated system capable of generating business related documents.
A measure is defined herein as a set of rules that are applied to answers in response to questions. Each measure comprises a formula specifying a question or combination of questions that are used to compute measure values for each measure. For example, a measure may comprise “Total cost of financial reporting per $1,000 revenue.” This measure's formula would comprise:
(Personnel cost of financial reporting+systems cost of financial reporting+overhead cost of financial reporting+outsourced cost of financial reporting+“other” cost of financial reporting)/total annual revenue.
Measures are typically normalized. Measures comprise a directional value that indicates better performance. For example, in a case of cost measures a lower value is preferable to a higher value and in a case of productivity measures a higher value is preferable to a lower value. Measure values are always numeric. A measure value operates on questions that are numerical, percentage, or currency (i.e., monetary) related.
Benchmark values and median values are constructed from a set of eligible measure values for each measure. For each measure, a median value is the 50th percentile of the set of measure values (i.e., a midpoint) and a benchmark value is the 80th percentile of the set of eligible measure values (i.e., a point at which 80% of the measure values are worse; and 20% are better).
System 2 comprises computing system 4, an input terminal 18, an input terminal 22, and a network 10. Network 10 may comprise any type of network known to one skilled in the art including, inter alia, a local area network, (LAN), a wide area network (WAN), the Internet, etc. Input terminal 18 may comprise any type of computing apparatus including, inter alia, a personal computer (PC), a laptop computer, a personal digital assistant (PDA), etc. Input terminal 22 may comprise any type of computing apparatus including, inter alia, a personal computer (PC), a laptop computer, a PDA, etc. Computing system 4 comprises a central processing unit (CPU) 8 and a memory device 14. The memory device 14 comprises a software application 16, input data 27, selection lists 12 associated with input data 27, and generated performance data reports 28. Input data 27 may comprise benchmark data (e.g., benchmark values, median values, etc) and qualitative data. Input data 27 may be entered into computing system 4 using input terminal 18 or input terminal 22. Input terminal 18 is connected to computing system 4 through network 10. Selection lists 12 comprises a plurality of lists that enables specified selections for the input data 27. Computing system 4 executes software application 16. Software application 16 uses selected (i.e., by a user and selected using one or more of lists 12) portions of data 27 to generate performance data reports 28. Performance data reports 28 comprise company benchmark values and median values computed in real time using measure value data (i.e., input data 27) from the memory device 14. Users may select portions of data from data 27 to create custom cuts of data (e.g., peer group benchmark values, peer group medians, peer group business drivers) on demand. In order to initiate a report generation process, a user may be required to log into computing system 4 (e.g., using terminal 18 or 22). Software application 16 allows the user to select a function which may be a process category or a process. For each selected function, software application 16 displays (e.g., on terminal 18 or 22) to the user all benchmark values, median values, and business driver values that have been configured for display for the associated function. For each selected function, software application 16 will display to the user leading practice statements (i.e., a proven business method or application that has resulted in significant improvements in performance and may be applied across industry boundaries), supporting case in point studies, (i.e., a company specific reference to a leading practice statement that highlights how the company uses that practice and the associated benefits) and process models. Software application 16 will display a selection (e.g., a list) for peer group options configured for display based on the function selected. Software application 16 will allow a user to select one or multiple peer group options. Software application 16 will construct median and benchmark values based on the following rules:
1. The set of available measure values to be used in constructing a median/benchmark value should start with the intersection of all values associated with the selected function and peer groups.
2. The set should then be narrowed according to the measure value computation rules and measure value reporting rules.
3. The medians and benchmarks should be computed according to measure specific benchmark rules.
For each selected measure, software application 16 will display the measure description and the median values/benchmark values for the selected peer group intersection. Software application 16 will allow the user to select a currency to display benchmark values, median values and business driver values. The end result is a performance data report comprising the aforementioned information. Each performance data report is either displayed (e.g., using one of terminals 18 or 22) or printed (e.g., using a printer portion of one of terminals 18 or 22) for the user.
An example for implementation of software application 16 to generate a performance data report is described as follows:
A user would like to generate a performance data report for a procurement function. The user opens software application 16 and logs in. The user selects from a process category “Procure materials and services”. Software application provides list of available processes for the selected process category and user selects “Order materials and services”. Software application 16 displays for the user, peer group options such as industry, region, size, market conditions, strategy etc. The user selects the major industry “manufacturing” and region “Europe”. The user selects the currency “Euro” to receive values. Software application 16 accesses an eligible set of measure values and business drivers and calculates and reports benchmark value, median value, and business driver values. Software application 16 provides a performance data report comprising leading practices for “procure materials and services” with relevant case in points. Additionally, the performance data report comprises process maps for “procure materials and services”.
Still yet, any of the components of the present invention could be deployed, managed, serviced, etc. by a service provider who offers to provide a service for generating performance data reports 28. Thus the present invention discloses a process for deploying or integrating computing infrastructure, comprising integrating computer-readable code into the computer system 90, wherein the code in combination with the computer system 90 is capable of performing a method for generating performance data reports 28. In another embodiment, the invention provides a business method that performs the process steps of the invention on a subscription, advertising, and/or fee basis. That is, a service provider, such as a Solution Integrator, could offer to generate performance data reports 28. In this case, the service provider can create, maintain, support, etc., a computer infrastructure that performs the process steps of the invention for one or more customers. In return, the service provider can receive payment from the customer(s) under a subscription and/or fee agreement and/or the service provider can receive payment from the sale of advertising content to one or more third parties.
While
While embodiments of the present invention have been described herein for purposes of illustration, many modifications and changes will become apparent to those skilled in the art. Accordingly, the appended claims are intended to encompass all such modifications and changes as fall within the true spirit and scope of this invention.
Crysel, Kirsten S., Simonson, Lori Kay
Patent | Priority | Assignee | Title |
Patent | Priority | Assignee | Title |
6581071, | Sep 12 2000 | University of Southern California | Surveying system and method |
6795828, | Mar 21 2001 | International Business Machines Corporation | Navigation among conditional questions and answers in computer and network based questionnaires |
6877034, | Aug 31 2000 | BENCHMARKPORTAL, INC | Performance evaluation through benchmarking using an on-line questionnaire based system and method |
7337142, | Oct 27 1999 | INTUIT INC | Multiple exchange rate tracking in a financial transaction manager |
7711595, | Aug 28 2001 | TWITTER, INC | Method and system for generating a value proposition for a company in an industry |
20020052774, | |||
20040039619, | |||
20040073441, | |||
20040128183, | |||
20050193333, | |||
20050222945, | |||
20050262014, | |||
20060010058, |
Executed on | Assignor | Assignee | Conveyance | Frame | Reel | Doc |
Sep 29 2006 | CRYSEL, KIRSTEN S | International Business Machines Corporation | ASSIGNMENT OF ASSIGNORS INTEREST SEE DOCUMENT FOR DETAILS | 018406 | /0317 | |
Oct 01 2006 | SIMONSON, LORI KAY | International Business Machines Corporation | ASSIGNMENT OF ASSIGNORS INTEREST SEE DOCUMENT FOR DETAILS | 018406 | /0317 | |
Oct 17 2006 | International Business Machines Corporation | (assignment on the face of the patent) | / |
Date | Maintenance Fee Events |
Feb 20 2015 | REM: Maintenance Fee Reminder Mailed. |
Jul 12 2015 | EXP: Patent Expired for Failure to Pay Maintenance Fees. |
Date | Maintenance Schedule |
Jul 12 2014 | 4 years fee payment window open |
Jan 12 2015 | 6 months grace period start (w surcharge) |
Jul 12 2015 | patent expiry (for year 4) |
Jul 12 2017 | 2 years to revive unintentionally abandoned end. (for year 4) |
Jul 12 2018 | 8 years fee payment window open |
Jan 12 2019 | 6 months grace period start (w surcharge) |
Jul 12 2019 | patent expiry (for year 8) |
Jul 12 2021 | 2 years to revive unintentionally abandoned end. (for year 8) |
Jul 12 2022 | 12 years fee payment window open |
Jan 12 2023 | 6 months grace period start (w surcharge) |
Jul 12 2023 | patent expiry (for year 12) |
Jul 12 2025 | 2 years to revive unintentionally abandoned end. (for year 12) |