International Business Machines Corporation

Jeffrey G Willets

Debra A Parmeter

Theresa W Broden

Scotty J Reynolds

James W Nugent

Michelle D Campbell

Robert W Guse

A system and method for generating a report by a reporting tool of the Systems Applications and Products (SAP) online financial software. An SAP-readable Aspect file is generated and transmitted to the SAP system where the Aspect file may be queried for generating the report. The Aspect file may be generated by a non-SAP bridge program that utilizes a dataset which may be in a SAP or a non-SAP format. Processing the dataset to generate the Aspect file may include data filtration based on selection rules, and may additionally include rolling up the data of the dataset. Two or more of such datasets may be collectively used to form corresponding Aspect files for generating a report based on a query that relates to the corresponding Aspect files. The Aspect file may include procurement data such as purchase order data and invoice data.

General business report generation

A method and system for updating and deleting records in a tableset T of a family having M tables (M&gE;1). A set S of N source files (N&gE;1) are embodied in fileset S at time t and in fileset S at time t . S is logically associated with T. The family has a common family key K across the M tables and across the N source files. A Delta program generates a dataset D having non-redundant family keyvalues embodying K . Each non-redundant family keyvalue is drawn from selected Update or Delete records of S relative to S . For Updates, a Trigger program generates fileset &Dgr;S from records of S having a family key in D, and a Bridge program generates fileset &Dgr;T that includes &Dgr;S data in a form compatible with T. A Load program updates and deletes records in T based on the non-redundant family keyvalues.

Changing table records in a database management system

Growing community of inventors

Apalachin, NY, United States of America

Jeffrey G Willets