System and method for viewing supply chain network metrics

• US 20020116213A1
• Filed: 01/30/2002
• Published: 08/22/2002
• Est. Priority Date: 01/30/2001
• Status: Abandoned Application

• Current Assignee: Manugistics Group Incorporated (RedPrairie Holding Incorporated)
• Original Assignee: Manugistics Group Incorporated (RedPrairie Holding Incorporated)
• Inventors: Kale, Ajit Shaligram, Walker, Marcia Laign, Snowberger, Scott Edward, Kavounis, Julia Burrows
• Application Number:
  US10/059,055
• Publication Number:
  US 20020116213A1
• Time in Patent Office: Days
• US Class Current: 705/1
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling

Abstract

A method and system for retrieving and processing data from disparate network applications and displaying the processed data through a single user interface. The method includes retrieving data from disparate network applications using an ETL engine then storing the data in a multidimensional database. An OLAP server may then use the stored data to create key performance indicators based on the data from the various disparate network applications and display the key performance indicators through a single user interface.

Claims

1. A method for displaying metrics and performance measurements from two or more network applications, the method comprising:

retrieving a first data from a first network application;

retrieving a second data from a second network application, said second data is disparate from said first data;

storing said first and said second data;

creating a first key performance indicator from said first data;

creating a second key performance indicator from said second data;

and

displaying said key performance indicators through a single user interface.

2. The method as recited in claim 1, further comprising the step of creating two or more subject areas.

3. The method as recited in claim 2, wherein said step of creating a first key performance indicator further comprises the step of using one of said subject areas to access said first data.

4. The method as recited in claim 3, wherein said step of creating a second key performance indicator further comprises the step of using one of said subject areas to access said second data.

5. The method as recited in claim 1, wherein said first network application is a pricing management application.

7. The method as recited in claim 1, wherein said first data comprising of a dimension and a measure data.

8. The method as recited in claim 7, further comprising the step of creating a data hierarchy structure based on said dimension data.

9. The method as recited in claim 8, further comprising the step of using said data hierarchy structure to aggregate said first data.

10. The method as recited in claim 9, further comprising the step of drilling down said aggregated data.

11. The method as recited in claim 1, further comprising the step of displaying one of said first and said second data on said user display.

12. The method as recited in claim 11, further comprising the steps of defining a pre-define condition and highlighting said data being displayed based on said pre-defined condition.

13. The method as recited in claim 1, further comprising the steps of defining a pre-defined condition and highlighting one of said key performance indicator based on said pre-defined condition.

14. The method as recited in claim 1, further comprising the step of creating a third key performance indicator from said first and said second data.

16. The system as recited in claim 15, wherein said first network application is a pricing management application.

17. The system as recited in claim 16, wherein said second network application is an application from the group consisting of supply chain management and supplier relationship applications.

18. The system as recited in claim 15, wherein said OLAP server further adapted for creating a data hierarchy structure based on dimensions of data associated with said network applications.

19. The system as recited in claim 18, further comprising a means for using said data hierarchy structure to aggregate said data.

20. The system as recited in claim 19, further comprising a means for using said data structure to drill down said data.

21. The system as recited in claim 20, further comprising a means for providing exception highlighting.

22. The system as recited in claim 15, wherein said OLAP server adapted for generating subject areas used to access data in said database.

23. The system as recited in claim 15, wherein said first key performance indicator further based on said data of said second network application.

25. The system as recited in claim 24, wherein said generating means further comprises a means for generating subject areas, said subject areas used to access said first and second data.

26. The system as recited in claim 24, further comprising a means for creating a data hierarchy structure based on dimension associated with said data.

27. The system as recited in claim 26, further comprising a means for aggregating said data.

28. The system as recited in claim 27, further comprising a means for drilling down aggregated data.

29. The system as recited in claim 24, further comprising a means for exception highlighting.

30. The system as recited in claim 24 wherein said first supply chain network system is a pricing management application.

31. The system as recited in claim 30 wherein said second supply chain network system is an application belonging to a group consisting of supply chain management and supplier relationship applications.

32. The system as recited in claim 24 wherein said generating means generates a third key performance indicator based on said first and said second data.

6. The method as recited in claim 6, wherein said second network application is an application from the group consisting of supply chain management and supplier relationship applications.

15. A system for displaying data and results of performance analysis from two or more network applications on a user interface, comprising:

an ETL engine, said ETL engine in electronic communication with a first network application and a second network application, wherein said second network application is disparate from said first application;

a database interfaced with said ETL engine;

an OLAP server interfaced with said database, said OLAP server adapted for generating a first key performance indicator based on data associated with said first network application and a second key performance indicator based on data associated with said second network application; and

an user interface for displaying said first and said second key performance indicators on a single display.

24. A system for monitoring and evaluating a plurality of disparate supply chain network system through a single user interface, comprising:

means for acquiring a first data from a first supply chain network system and a second data from a second supply chain network system, wherein said first and said second data are disparate, said means further comprising a means for making compatible said disparate data;

means for storing said first and said second data, said storing means interfaced with said acquiring means;

means for generating a first key performance indicator based on said first data and a second key performance indicator based on said second data; and

means for displaying said data and said key performance indicators.