Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Apparatus and method for creating new reports from a consolidated data mart

a technology of consolidated data and reports, applied in the field of apparatus and methods for creating new reports from consolidated data marts, can solve the problems of slowing down the report generation process, difficult decentralization of database activity, complex and time-consuming, etc., and achieves the effect of facilitating the decentralization of database computational activity and the creation of reports

Inactive Publication Date: 2006-01-05
BUSINESS OBJECTS SOFTWARE
View PDF20 Cites 15 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Benefits of technology

[0011] The invention provides a technique that allows data from individual reports to be accessible by standard reporting tools. That is, the selection of data from individual reports to form a consolidated data mart results in a data repository that can be used by standard reporting tools. The invention facilitates the creation of reports that show trends across data found in various reports. The invention is able to access and process snapshots of data. The invention allows the merging of data from multiple databases, having either similar or disparate formats. In addition, the invention facilitates the decentralization of database computational activity.

Problems solved by technology

This can result in large numbers of database accesses that slow down the report generation process.
In addition, since a single database is used, it is difficult to decentralize database activity.
Another limitation associated with existing report generation tools is that the creation of a new form of report commonly requires the rebuilding of the database schema, which can be complex and time consuming.
Another problem with existing report generation tools is that they have difficulty merging data from multiple databases into a single report.
This problem is especially acute in the case where the databases are from different vendors (e.g., Oracle®, IBM®, Microsoft®).
While this is important from the standpoint of data consistency, it creates difficulties in obtaining snapshots of data at different points in time.

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Apparatus and method for creating new reports from a consolidated data mart
  • Apparatus and method for creating new reports from a consolidated data mart
  • Apparatus and method for creating new reports from a consolidated data mart

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028]FIG. 1 illustrates the operation of consolidated report generation in accordance with an embodiment of the invention. In accordance with the prior art, a database 20 is accessed by a conventional report generation tool 22 to produce a set of reports 24A-24N. In the prior art, if a new report is to be created, the report generation tool 22 must be used to access the database 20 to create a new report.

[0029] In accordance with the invention, a consolidated report generator 26 is used to produce a consolidated report 28 based upon the information contained in the previously generated reports 24A-24N. In other words, the consolidated report generator 26 does not access the data in the database 20; rather, the consolidated report generator 26 uses the data in the reports 24A-24N as a data source to produce a new consolidated report 28.

[0030]FIG. 2 illustrates processing operations associated with an embodiment of the invention. Initially, a report repository of individual reports...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention includes a computer readable memory with a consolidated data mart generator to generate a consolidated data mart based upon an analysis of a repository of individual reports. A report generation tool produces a report via access to the consolidated data mart.

Description

[0001] This application is a continuation-in-part of pending U.S. Ser. No. 10 / 328,744, filed Dec. 23, 2002, entitled “Apparatus and Method for Creating New Reports from Discrete Reports”.BRIEF DESCRIPTION OF THE INVENTION [0002] This invention relates generally to the generation of reports. More particularly, this invention relates to a technique for using reports as a data source in order to create consolidated reports based upon individual reports. BACKGROUND OF THE INVENTION [0003] There are a number of commercially available products to create reports from data stored in a database. Business Objects Americas of San Jose, Calif., sells a number of widely used report generation products, including Crystal Reports™, Crystal Analysis™, Crystal Enterprise™, and Business Objects Enterprise™. [0004] Known report generation tools access a database each time a report needs to be generated. This can result in large numbers of database accesses that slow down the report generation process....

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(United States)
IPC IPC(8): G06F17/00G06F17/24
CPCG06F17/24G06F17/2229G06F40/131G06F40/166
Inventor WU, JUAMA, RONALDO
Owner BUSINESS OBJECTS SOFTWARE
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com