Data model for performance management system

• US 7,558,808 B2
• Filed: 10/17/2005
• Issued: 07/07/2009
• Est. Priority Date: 10/17/2005
• Status: Active Grant

• Current Assignee: Accenture Global Services Limited (Accenture PLC)
• Original Assignee: Accenture Global Services GmbH (Accenture PLC)
• Inventors: Mason, Miranda L., McLeod, Michelle
• Primary Examiner(s): Ali; Mohammad
• Assistant Examiner(s): Shmatov; Alexey
• Application Number:
  US11/252,099
• Publication Number:
  US 20070088730A1
• Time in Patent Office: 1,359 Days
• Field of Search: 707/101, 707/3, 707/102, 707/104.1
• US Class Current: 1/1
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: G06Q 40/06 Asset management; Financial planning or analysis
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image

Abstract

A performance management system renders performance management data and computed and aggregated metrics in a portfolio view. The performance management data flexibly calculates metrics from elemental data, aggregates the data within and across hierarchies, and establishes cross hierarchy performance management targets. Cross hierarchy performance management targets provide deeper insight into business performance through which the performance management system meets the performance management reporting challenges of modern, complex, global businesses.

Claims

1. A cross hierarchy performance management system comprising:

a database comprising;

a geographic hierarchy that establishes relationships between geographically related entities;

a geographical dimension table dimensioned by the geographically related entities and comprising geographical attributes that describe geographical dimensions for the geographically related entities;

an outsourcing group hierarchy that establishes relationships between outsourcing group related entities;

an outsourcing group dimension table dimensioned by the outsourcing group related entities and comprising outsourcing group attributes that describe outsourcing group dimensions for the outsourcing group related entities;

an operating group hierarchy that establishes relationships between operating group related entities;

an operating group dimension table dimensioned by the operating group related entities and comprising operating group attributes that describe operating group dimensions for the operating group related entities;

performance management data stored in the database and comprising a pre-calculated geographic-outsourcing group performance target for a geographic-outsourcing group aggregated metric and a pre-calculated operating group-outsourcing group performance target for an operating group-outsourcing group aggregated metric;

a first cross hierarchy between the geographic hierarchy and the outsourcing group hierarchy, the first cross hierarchy comprising;

a geographic-outsourcing group cross hierarchy fact table comprising;

a first cross hierarchy key that links the geographic-outsourcing group cross hierarchy fact table to the geographic hierarchy and the outsourcing group hierarchy;

where the geographic-outsourcing group performance target is absent from the first cross hierarchy fact table key; and

where the geographic-outsourcing group aggregated metric is absent from the first cross hierarchy fact table key;

a second cross hierarchy between the operating group hierarchy and the outsourcing group hierarchy, the second cross hierarchy comprising;

an operating group-outsourcing group cross hierarchy fact table comprising;

a second cross hierarchy key that links the operating group-outsourcing group cross hierarchy fact table to the operating group hierarchy and the outsourcing group hierarchy;

the operating group-outsourcing group performance target;

the operating group-outsourcing group aggregated metric, where the operating group-outsourcing group aggregated metric is absent from the second cross hierarchy fact table key;

a memory comprising a performance management reporting program that;

obtains a portfolio view selection from an operator;

retrieves a portion of the performance management data and the aggregated metrics based on the portfolio view selection, including at least one of the geographic-outsourcing group performance target and an operating group-outsourcing group performance target; and

renders the portion of the performance management data as a portfolio view; and

a processor coupled to the database and the memory which executes the performance management program.

2. The performance management system of claim 1, where the geographic-outsourcing group cross hierarchy fact table comprises an area-capability offering cross hierarchy fact table.

3. The performance management system of claim 1, where the operating group-outsourcing group cross hierarchy fact table comprises a client-capability offering cross hierarchy fact table.

4. The performance management system of claim 1, where the operating group-outsourcing group cross hierarchy fact table comprises an operating group-capability offering cross hierarchy fact table.

5. The performance management system of claim 1, where the database further comprises:

a third cross hierarchy between the geographic hierarchy and the operating group hierarchy, the third cross hierarchy comprising;

geographic-operating group cross hierarchy fact table including a geographic-operating group performance target.

6. The performance management system of claim 5, where the geographic-operating group cross hierarchy fact table comprises an engagement-location cross hierarchy fact table.

7. The performance management system of claim 1, where the portfolio view comprises an offering-by-area view.

8. The performance management system of claim 1, where the portfolio view comprises a client-by-offering view.

9. The performance management system of claim 1, where the portfolio view comprises an engagement-by-location view.

10. The performance management system of claim 1, where the outsourcing group hierarchy comprises an outsourcing group-capability offering hierarchy.

11. The performance management system of claim 1, where the operating group hierarchy comprises an operating group-client hierarchy.