Summarizing tabular data across multiple projects using user-defined attributes

US10997556B2 · kind B2 · utility

Assignee

• Oracle International Corporation · US

Inventors

• David J. Scott · Gilroy, US
• John David Bilthuis · Highlands Ranch, US
• David Wayne Nowakowski · Thornton, US
• Lynn J. KELLEHER · Conifer, US
• Scott Gene Buss · Centennial, US
• Michael Donald EIDE · Lafayette, US
• Deborah Marie LIVINGSTON · Littleton, US
• Maria Leonor CABALLERO RUIZ · Denver, US
• John Craig Spencer · Denver, US
• Beverly Lynn NICOL · Lafayette, US
• Andrew Yung Ern Tan · Grafton, GB

Key dates

• Filing date: Apr 7, 2014
• Grant date: May 4, 2021
• Expiry date: Nov 8, 2037

Classification

• Technology area (CPC G): Physics
• CPC primary: G06Q20/381
• WIPO field: IT methods for management
• WIPO sector: Electrical engineering

Abstract

A method, system, and computer program product for enterprise applications. Embodiments commence by accessing a first database table having columns pertaining to one or more cost items of a first project and accessing a second database table having columns pertaining to cost items of a second project. A user interface aids definition of user-defined inter-project attributes, wherein the user-defined inter-project attributes relate a database table column of the first project to a database table column of the second project. The user-defined inter-project attributes are used in preparing display information pertaining to at least two projects such that in response to a single action being performed under control of a client system, the prepared display information is sent to a display unit. In some cases, the prepared display information comprises a summary of values, and in some cases, an alert icon is displayed based on a summary value exceeding a threshold.