Drew T Lettington

US Patent:

7861253, Dec 28, 2010

Filed:

Nov 18, 2004

Appl. No.:

10/991089

Inventors:

Drew Thomas Lettington - San Diego CA, US
Jeffrey Bedell - Arlington VA, US
Gail Marie Hurn - Poway CA, US
Anna Victoria Duyongco - San Diego CA, US

Assignee:

Microstrategy, Inc. - McLean VA

International Classification:

G06F 13/00

US Classification:

719328, 719311, 715700

Abstract:

A multi-level interface client for business productivity clients such as spreadsheet, word processor, presentation, database and email clients. The multi-level interface client provides backend functionality permitting a business intelligence server, such as an OLAP system to be accessed directly from the productivity client. Reports displayed in the documents native to the productivity client can be updated directly in the client by executing operations on the business intelligence server through the interface client. Layout and formatting information specific to the client is stored as persistence information by interface client in the productivity client document file and is used to refresh the displayed report in the file without a loss of formatting or layout properties.

US Patent:

58324968, Nov 3, 1998

Filed:

Oct 31, 1996

Appl. No.:

8/742006

Inventors:

Tejwansh S. Anand - Roswell GA
Glenn K. Wikle - Sante Fe NM
Marshall P. Lindsay - San Diego CA
Richard N. Schubert - San Diego CA
Drew T. Lettington - San Diego CA
Jeffrey P. Ludwig - San Diego CA

Assignee:

NCR Corporation - Dayton OH

International Classification:

G06F 1700

US Classification:

707102

Abstract:

A system and method for performing intelligent analysis and for generating a report for a user which allows the user to make decisions, without requiring the user to understand or interpret data itself. A database computer includes a database containing the data. The data includes a collection of information about an enterprise of the user. A server computer is coupled to the database computer and executes a database management program. A client computer is coupled to the server and executes an application program. The application program allows a user to define predetermined data types, to define relationships between the data types, to define parameters for the report, to define a method of analysis for the report, and to create the report. The report summarizes the data in terms of the data types, the data relationships, and the method of analysis.

US Patent:

56921810, Nov 25, 1997

Filed:

Oct 12, 1995

Appl. No.:

8/542267

Inventors:

Tejwansh S. Anand - Roswell GA
Michael A. Georgantos - San Diego CA
Yih-Shiuan Hu - Alpharetta GA
James F. Knutson - Roswell GA
Drew T. Lettington - San Diego CA
Marshall P. Lindsay - San Diego CA
Alan J. Meyer - Riverside CA
Kenneth W. O'Flaherty - Del Mar CA
Richard N. Schubert - San Diego CA
Peter G. Selfridge - Watchung NJ

Assignee:

NCR Corporation - Dayton OH

International Classification:

G06F 1730

US Classification:

395613

Abstract:

A system and method for generating a report for a user which allows the user to make decisions, without requiring the user to understand or interpret data itself. A method of creating data types and data relationships within a database for generating the report for the user includes the steps of organizing the data within the database into columns of tables, providing a computer coupled to the database that executes an application program that generates the report, recording a business concept by the application program, recording an attribute associated with the business concept by the application program, displaying a list of the columns of tables in the database by the computer, recording a mapping of the attribute to one of the columns in the list, displaying a list of business indicators by the computer, recording a mapping of one of the business indicators to the column, joining the attribute table with the business indicator table so that the application program can use the additional table to create the report.

US Patent:

57219036, Feb 24, 1998

Filed:

Oct 12, 1995

Appl. No.:

8/545048

Inventors:

Tejwansh S. Anand - Roswell GA
Michael A. Georgantos - San Diego CA
Yih-Shiuan Hu - Alpharetta GA
James F. Knutson - Roswell GA
Drew T. Lettington - San Diego CA
Marshall P. Lindsay - San Diego CA
Alan J. Meyer - Riverside CA
Kenneth W. O'Flaherty - Del Mar CA
Richard N. Schubert - San Diego CA
Peter G. Selfridge - Watchung NJ

Assignee:

NCR Corporation - Dayton OH

International Classification:

G06F 1730

US Classification:

395605

Abstract:

A system and method for generating a report for a user which allows the user to make decisions, without requiring the user to understand or interpret data itself. A database management program executed by a server within a system for generating the report for the user includes a first subsystem for translating user requests for data, for generating dimensional queries for retrieving data from a database, and for processing user modifications to data types used in generating the report. A second subsystem coupled to the first subsystem reads data from the database, creates the data types, creates a mapping of the data types to the data, uses the mapping to translate user-initiated dimensional queries received from the first subsystem into Structured Query Language (SQL), and returns query results to the first subsystem. A third subsystem creates the report at a predetermined time.

US Patent:

57109001, Jan 20, 1998

Filed:

Oct 12, 1995

Appl. No.:

8/542268

Inventors:

Tejwansh S. Anand - Roswell GA
Michael A. Georgantos - San Diego CA
Yih-Shiuan Hu - Alpharetta GA
James F. Knutson - Roswell GA
Drew T. Lettington - San Diego CA
Marshall P. Lindsay - San Diego CA
Alan J. Meyer - Riverside CA
Kenneth W. O'Flaherty - Del Mar CA
Richard N. Schubert - San Diego CA
Peter G. Selfridge - Watchung NJ

Assignee:

NCR Corporation - Dayton OH

International Classification:

G06F 300

US Classification:

395339

Abstract:

A system and method for generating a report for a user which allows the user to make decisions, without requiring the user to understand or interpret data itself. An application within the system includes a graphical user interface (GUI) which allows the user to select and specify the parameters for the report, display the report, print the report, and save the report. A folder management subsystem allows the user to create a folder object for storing the report within the database, store the report within the folder object, and retrieve the report from the folder object using the GUI. A business information setup subsystem allows the user to create data types and create and constrain relationships between the data types. An analyst definition subsystem allows the user to select an analyst representing a method of analysis to use in generating the report using the GUI. Finally, a viewer module displays the report.