US20040123246A1 - Apparatus and method for creating new reports from discrete reports - Google Patents
Apparatus and method for creating new reports from discrete reports Download PDFInfo
- Publication number
- US20040123246A1 US20040123246A1 US10/328,744 US32874402A US2004123246A1 US 20040123246 A1 US20040123246 A1 US 20040123246A1 US 32874402 A US32874402 A US 32874402A US 2004123246 A1 US2004123246 A1 US 2004123246A1
- Authority
- US
- United States
- Prior art keywords
- report
- repository
- data
- reports
- consolidated
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Abandoned
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/12—Use of codes for handling textual entities
- G06F40/131—Fragmentation of text files, e.g. creating reusable text-blocks; Linking to fragments, e.g. using XInclude; Namespaces
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
Definitions
- 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.
- Crystal Decisions, Inc. of Palo Alto, Calif. sells a number of widely used report generation products, including Crystal ReportsTM, Crystal AnalysisTM, and Crystal EnterpriseTM.
- 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®).
- Databases have their data updated on a regular basis. While this is important from the standpoint of data consistency, it creates difficulties in obtaining snapshots of data at different points in time.
- the invention includes a method of forming a report by defining a report repository with individual reports formed from database information.
- the database information may be from a set of databases with different formats. Consolidated report criteria are selected. Based upon the consolidated report criteria, individual reports within the report repository are analyzed to generate a consolidated report. A report field of the consolidated report may be linked to an individual report that is the source of the report field.
- the invention also includes a method of forming a report without accessing a database.
- a repository of individual reports is analyzed.
- the repository of individual reports may be created by processing data from databases with different formats.
- a new report is generated from data collected during the analysis of the individual reports. Data in the new report is linked to source data within an individual report of the repository.
- the invention also includes a computer readable memory storing a consolidated report generator with executable instructions to analyze a repository of individual reports.
- the consolidated report generator produces a new report from data analyzed within the repository of individual reports.
- the computer readable memory also includes a query module to create the repository of individual reports by processing data within a database or a set of databases with different formats.
- the invention facilitates a technique for generating new reports without accessing a database. Therefore, new reports are available without rebuilding a database schema.
- the invention facilitates the creation of reports that show trends across data found in other reports. Thus, 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.
- the invention reduces database accesses.
- the invention facilitates the decentralization of database computational activity.
- FIG. 1 illustrates the operation of consolidated report generation in accordance with an embodiment of the invention.
- FIG. 2 illustrates processing operations performed in accordance with an embodiment of the invention.
- FIG. 3 is an example of portions of reports used to create a consolidated report in accordance with an embodiment of the invention.
- FIG. 4 illustrates a user interface that may be used to create a consolidated report in accordance with an embodiment of the invention.
- FIG. 5 illustrates another user interface that may be used to create a consolidated report in accordance with an embodiment of the invention.
- FIGS. 6 - 9 illustrate specific reports that may be used to create a consolidated report in accordance with an embodiment of the invention.
- FIG. 10 illustrates a consolidated report created from the information of the specific reports of FIGS. 6 - 9 in accordance with an embodiment of the invention.
- FIG. 11 illustrates the operation of expanding information in a consolidated report in accordance with an embodiment of the invention.
- FIG. 12 illustrates the result of drilling through information within the report of FIG. 11 to obtain a detailed base report.
- FIG. 13 illustrates a computer network architecture that may be utilized to implement embodiments of the invention.
- FIG. 14 illustrates a consolidated report architecture that utilizes a report as a root object in accordance with an embodiment of the invention.
- FIG. 15 illustrates a consolidated report architecture that utilizes a root object in accordance with an embodiment of the invention.
- FIG. 1 illustrates the operation of consolidated report generation in accordance with an embodiment of the invention.
- a database 20 is accessed by a conventional report generation tool 22 to produce a set of reports 24 A- 24 N.
- the report generation tool 22 must be used to access the database 20 to create a new report.
- a consolidated report generator 26 is used to produce a consolidated report 28 based upon the information contained in the previously generated reports 24 A- 24 N.
- 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 24 A- 24 N as a data source to produce a new consolidated report 28 .
- FIG. 2 illustrates processing operations associated with an embodiment of the invention.
- a report repository of individual reports is created or defined from database information (block 30 ).
- a report repository is simply a collection of reports.
- the individual reports may be created with a conventional report generation tool, such as Crystal ReportsTM, Crystal AnalysisTM, or Crystal EnterpriseTM, sold by Crystal Decisions, Inc., Palo Alto, Calif.
- FIG. 3 illustrates four individual reports 32 A- 32 D.
- Each individual report provides information for a quarter of a calendar year.
- each report 32 has a customer field 34 , an employee field 36 , an employee address field 38 , and an orders field 40 , as shown in FIG. 3.
- the orders field 40 has a set of sub-fields, including an order ID field 42 , an order amount field 44 , a customer ID field 46 , a quarter sales field 48 , an order date field 50 , a required date field 52 , a ship date field 54 , a courier website field 56 , a ship via field 58 , a shipped field 60 , a Purchase Order number field 62 , and a payment received field 64 .
- FIG. 4 illustrates a graphical user interface 72 that may be used in accordance with an embodiment of the invention to facilitate this operation.
- the graphical user interface 72 may be used to display a series of reports in a repository of reports.
- the available reports 32 A- 32 D correspond to the reports 32 A- 32 D shown in FIG. 3.
- specific fields in the selected reports are then selected.
- the graphical user interface 74 of FIG. 5 shows a set of fields corresponding to the fields illustrated in the exemplary reports of FIG. 3. In this example, the quarter sales filed 48 is selected.
- a prompt is provided for a data source.
- the data source may be a report file path or a path of a directory that contains multiple report files.
- a data context for a report path can be defined to limit the amount of viewed information.
- a special character e.g., “?”
- This example assumes a base report that is grouped by country and customer. Specifying the sum of sales in a country within the base report results a consolidated report listing this information.
- a consolidated report of the invention is created through the following instruction sequence:
- a consolidated data source is ready for use as any other data source for report creation. If the Reports node in the Field Explorer is expanded, the fields from each report specified as a data source may be displayed.
- special fields are provided to track specific information about the report fields in the data source.
- Example special fields include:
- Report Path This field shows the path and name of the report for the current record.
- Group Path This field shows the group level and record number of the current record in the report.
- Record Number This field shows the record number of the current record in the report.
- Data Date This field shows the date the data was last refreshed in the report.
- next processing operation is to analyze individual reports within a report repository based upon selected consolidated report criteria (block 80 ).
- Executable code is invoked to perform this operation. This results in the generation of a consolidated report (block 82 ).
- FIG. 3 illustrates a consolidated report 28 .
- the figure illustrates a consolidated report 28 with a first quarter sales field 90 , a second quarter sales field 92 , a third quarter sales field 94 , a fourth quarter sales field 96 , and a total sales field 98 , which represents the sum of the individual sales fields.
- the consolidated report 28 was created based upon data in individual reports 32 A- 32 D, instead of accessing a database. Therefore, a new report is available without rebuilding the database schema.
- the consolidated report 28 shows trends across data found in time stamped instances of other reports.
- the consolidated report 28 has captured snapshots of data over an extended period of time.
- the database source of the individual reports used to generate the consolidated report 28 is irrelevant.
- the consolidated report 28 can be created from individual reports that were derived from disparate databases. Accordingly, the invention allows the merging of data from multiple databases, having either similar or disparate formats. It can also be appreciated that the invention reduces database accesses as new reports are generated from individual reports, not database accesses.
- the invention facilitates the decentralization of database computational activity. For example, individual reports may be created in branch offices and then transmitted to a central office. At the central office, a consolidated report is generated based upon the received reports from the branch offices.
- a final optional operation is displayed.
- an operation may be implemented to drill through to a source report (block 100 ).
- each field in a consolidated report 28 has an associated link to its source report. By activating this link, the user is returned to the source report, thereby allowing drill down processing.
- Arrow 102 of FIG. 3 illustrates a link between the first quarter sales field 90 and its corresponding field 48 in source report 32 A.
- FIG. 6 illustrates a quarterly sales report.
- this sales report specifies quarterly sales for North America (NA), Europe (EU), and the Asia Pacific (Asia Pac).
- the report window 104 illustrates a breakdown for North American sales by country, including the U.S. and Canada.
- the report also reflects a total sales amount for North America for the first calendar quarter ending Mar. 31, 2002.
- the report reflects a breakdown for European sales by country, including England, France, and Germany.
- a total sales volume for the European region for the first quarter is also supplied. Similar information is provided for the Asia Pacific region.
- FIGS. 7 - 9 reflect the same information for the subsequent quarters of 2002.
- a consolidated report can be produced from the individual reports of FIGS. 6 - 9 .
- the resultant consolidated report is shown in FIG. 10.
- the consolidated report 105 of FIG. 10 illustrates quarterly sales and total sales for each region (i.e., Asia Pacific, Europe, and North America).
- the tabular numeric data is also supplied in a graph 106 in this example.
- the reports used to generate the regional data can be invoked.
- FIG. 11 illustrates an expanded regional data report 107 .
- the expanded regional data is for Europe and includes individual quarterly and total sales for England, France, and Germany.
- further expansion or drill through to source reports can be accomplished. For example, if the link associated with the third quarter sales for France is activated, then the user receives the report of FIG. 8. If the user activates the France link 108 of FIG. 8, then a detailed sales report for France in the third quarter is supplied, as shown in FIG. 12. The detailed report 109 of FIG. 12 provides information on the individual sales transactions that produced the third quarter sales total (i.e., $765,332.34) for France.
- FIG. 13 illustrates a computer network architecture that may be utilized to implement embodiments of the invention.
- the computer network architecture 110 includes a client computer 112 .
- the client computer has a central processing unit 114 connected to a network connection circuit 116 via a bus 118 .
- the network connection circuit 116 is also connected to a network transport medium 119 , which may be any wired or wireless transport medium.
- a set of input/output devices (not shown) is also attached to the bus 118 to allow a user to input and view data.
- a memory 120 is also connected to the bus 118 .
- the memory 120 stores a set of executable programs.
- One executable program is a query module 122 (e.g., a report generation tool).
- the query module 122 utilizes standard techniques to produce a set of reports 124 A- 124 N.
- the query module 122 may access one or more databases resident on the client computer 112 . However, in this example, the query module 122 accesses one or more databases resident on server computer 130 .
- Server computer 130 includes a central processing unit 132 connected to a network connection circuit 134 via a bus 136 .
- the network connection circuit 134 is also connected to the network transport medium 119 .
- a set of input/output devices (not shown) is also attached to the bus 136 to allow a user to ipnut and view data.
- a memory 138 is also connected to the bus 136 .
- the memory 138 stores one or more databases 140 A- 140 N.
- a consolidated report generator 150 may be executed from either the server computer 130 or the client computer 112 .
- the client computer 112 includes a consolidated report generator 150 with executable instructions to implement the operations described herein. This results in the creation of one or more consolidated reports 152 A- 152 N. Additional consolidated reports may be formed from the information contained in individual consolidated reports.
- FIG. 14 illustrates a consolidated report architecture that utilizes a report as a root object in accordance with an embodiment of the invention.
- a report object 160 is used to produce report instances 162 A- 162 N.
- the consolidated report generator 150 uses the report object 160 to define fields for a consolidated report, as discussed in connection with FIGS. 3 - 5 .
- the consolidated report generator 150 also produces a consolidated report 164 based upon data contained within the report instances 162 A- 162 N, as previously discussed.
- FIG. 15 illustrates a consolidated report architecture that utilizes a root object in accordance with an embodiment of the invention.
- a report object 160 is used to produce report instances 162 A- 162 N.
- the consolidated report generator 150 is used to produce a first instance of a consolidated report 164 and a second instance of a consolidated report 166 based upon the data in the report instances 162 .
- a consolidated report object 168 operates as a parent object to the consolidated report instances 164 , 166 .
- consolidated reports can be programmed to run at a scheduled time. At the scheduled time, the new object inherits the superset of all instances of the parent. Security may also be implemented through various object architectures. For example, a user may be prohibited from generating a consolidated report unless the individual has access to the parent object.
- An embodiment of the present invention relates to a computer storage product with a computer-readable medium having computer code thereon for performing various computer-implemented operations.
- the media and computer code may be those specially designed and constructed for the purposes of the present invention, or they may be of the kind well known and available to those having skill in the computer software arts.
- Examples of computer-readable media include, but are not limited to: magnetic media such as hard disks, floppy disks, and magnetic tape; optical media such as CD-ROMs and holographic devices; magneto-optical media such as floptical disks; and hardware devices that are specially configured to store and execute program code, such as application-specific integrated circuits (“ASICs”), programmable logic devices (“PLDs”) and ROM and RAM devices.
- ASICs application-specific integrated circuits
- PLDs programmable logic devices
- Examples of computer code include machine code, such as produced by a compiler, and files containing higher-level code that are executed by a computer using an interpreter.
- machine code such as produced by a compiler
- files containing higher-level code that are executed by a computer using an interpreter.
- an embodiment of the invention may be implemented using Java, C++, or other object-oriented programming language and development tools.
- Another embodiment of the invention may be implemented in hardwired circuitry in place of, or in combination with, machine-executable software instructions.
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
- 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.
- There are a number of commercially available products to create reports from data stored in a database. Crystal Decisions, Inc. of Palo Alto, Calif., sells a number of widely used report generation products, including Crystal Reports™, Crystal Analysis™, and Crystal Enterprise™.
- 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. 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®).
- Databases have their data updated on a regular basis. While this is important from the standpoint of data consistency, it creates difficulties in obtaining snapshots of data at different points in time.
- In view of the foregoing, it would be highly desirable to provide an improved technique for generating reports to overcome some of the limitations associated with existing report generation tools.
- The invention includes a method of forming a report by defining a report repository with individual reports formed from database information. The database information may be from a set of databases with different formats. Consolidated report criteria are selected. Based upon the consolidated report criteria, individual reports within the report repository are analyzed to generate a consolidated report. A report field of the consolidated report may be linked to an individual report that is the source of the report field.
- The invention also includes a method of forming a report without accessing a database. A repository of individual reports is analyzed. The repository of individual reports may be created by processing data from databases with different formats. A new report is generated from data collected during the analysis of the individual reports. Data in the new report is linked to source data within an individual report of the repository.
- The invention also includes a computer readable memory storing a consolidated report generator with executable instructions to analyze a repository of individual reports. The consolidated report generator produces a new report from data analyzed within the repository of individual reports. The computer readable memory also includes a query module to create the repository of individual reports by processing data within a database or a set of databases with different formats.
- The invention facilitates a technique for generating new reports without accessing a database. Therefore, new reports are available without rebuilding a database schema. The invention facilitates the creation of reports that show trends across data found in other reports. Thus, 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. The invention reduces database accesses. In addition, the invention facilitates the decentralization of database computational activity.
- The invention is more fully appreciated in connection with the following detailed description taken in conjunction with the accompanying drawings, in which:
- FIG. 1 illustrates the operation of consolidated report generation in accordance with an embodiment of the invention.
- FIG. 2 illustrates processing operations performed in accordance with an embodiment of the invention.
- FIG. 3 is an example of portions of reports used to create a consolidated report in accordance with an embodiment of the invention.
- FIG. 4 illustrates a user interface that may be used to create a consolidated report in accordance with an embodiment of the invention.
- FIG. 5 illustrates another user interface that may be used to create a consolidated report in accordance with an embodiment of the invention.
- FIGS.6-9 illustrate specific reports that may be used to create a consolidated report in accordance with an embodiment of the invention.
- FIG. 10 illustrates a consolidated report created from the information of the specific reports of FIGS.6-9 in accordance with an embodiment of the invention.
- FIG. 11 illustrates the operation of expanding information in a consolidated report in accordance with an embodiment of the invention.
- FIG. 12 illustrates the result of drilling through information within the report of FIG. 11 to obtain a detailed base report.
- FIG. 13 illustrates a computer network architecture that may be utilized to implement embodiments of the invention.
- FIG. 14 illustrates a consolidated report architecture that utilizes a report as a root object in accordance with an embodiment of the invention.
- FIG. 15 illustrates a consolidated report architecture that utilizes a root object in accordance with an embodiment of the invention.
- Like reference numerals refer to corresponding parts throughout the several views of the drawings.
- 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 conventionalreport generation tool 22 to produce a set ofreports 24A-24N. In the prior art, if a new report is to be created, thereport generation tool 22 must be used to access thedatabase 20 to create a new report. - In accordance with the invention, a consolidated
report generator 26 is used to produce a consolidatedreport 28 based upon the information contained in the previously generatedreports 24A-24N. In other words, the consolidatedreport generator 26 does not access the data in thedatabase 20; rather, the consolidatedreport generator 26 uses the data in thereports 24A-24N as a data source to produce a new consolidatedreport 28. - FIG. 2 illustrates processing operations associated with an embodiment of the invention. Initially, a report repository of individual reports is created or defined from database information (block30). A report repository is simply a collection of reports. The individual reports may be created with a conventional report generation tool, such as Crystal Reports™, Crystal Analysis™, or Crystal Enterprise™, sold by Crystal Decisions, Inc., Palo Alto, Calif.
- By way of example, FIG. 3 illustrates four
individual reports 32A-32D. Each individual report provides information for a quarter of a calendar year. Thus, there is afirst quarter report 32A, asecond quarter report 32B, athird quarter report 32C, and afourth quarter report 32D. In this example, each report 32 has acustomer field 34, anemployee field 36, anemployee address field 38, and anorders field 40, as shown in FIG. 3. The orders field 40 has a set of sub-fields, including anorder ID field 42, anorder amount field 44, acustomer ID field 46, aquarter sales field 48, anorder date field 50, a requireddate field 52, aship date field 54, acourier website field 56, a ship viafield 58, a shippedfield 60, a PurchaseOrder number field 62, and a payment receivedfield 64. - Returning to FIG. 2, the next processing operation is to select consolidated report criteria (block70). FIG. 4 illustrates a
graphical user interface 72 that may be used in accordance with an embodiment of the invention to facilitate this operation. Thegraphical user interface 72 may be used to display a series of reports in a repository of reports. In this example, theavailable reports 32A-32D correspond to thereports 32A-32D shown in FIG. 3. In one embodiment of the invention, specific fields in the selected reports are then selected. Thegraphical user interface 74 of FIG. 5 shows a set of fields corresponding to the fields illustrated in the exemplary reports of FIG. 3. In this example, the quarter sales filed 48 is selected. - Alternate techniques may be used to select consolidated report criteria. In another embodiment of the invention, a prompt is provided for a data source. For example, the data source may be a report file path or a path of a directory that contains multiple report files. Preferably, a data context for a report path can be defined to limit the amount of viewed information. For example, a special character (e.g., “?”) can be appended to a report path to limit information to selected fields of a report. Thus, for example, assuming a base report grouped by region, to see only the Quarterly sales records for the U.S. in a report, the following report path and data context can be used: c:\\Directory Name\ReportName.rpt?datacontext=/Country[US]. This example assumes a base report that is grouped by country and customer. Specifying the sum of sales in a country within the base report results a consolidated report listing this information. One can generate trend data for all countries (e.g., datacontext=/Country[*]) or trend data for a selected country (e.g., datacontext=/Country[US]).
- In one embodiment of the invention, a consolidated report of the invention is created through the following instruction sequence:
- 1. On a standard toolbar, click New.
- 2. In a Reports Gallery, click As a Blank Report and then OK.
- 3. In a Database dialog box, expand Create New Connection and click OLE DB.
- 4. From a Provider list, select a Rowset Provider and click Next.
- 5. In a Data Source field, enter the name of the reports file(s) to use in the consolidated report.
- 6. Click Finish. (A data source called Reports is added to the OLE DB folder.)
- 7. Add the Reports data source to the Selected Tables area and click OK.
- At this point, a consolidated data source is ready for use as any other data source for report creation. If the Reports node in the Field Explorer is expanded, the fields from each report specified as a data source may be displayed.
- Preferably, special fields are provided to track specific information about the report fields in the data source. Example special fields include:
- Report Path—This field shows the path and name of the report for the current record.
- Group Path—This field shows the group level and record number of the current record in the report.
- Record Number—This field shows the record number of the current record in the report.
- Data Date—This field shows the date the data was last refreshed in the report.
- Data Time—This field shows the time the data was last refreshed in the report.
- Returning now to FIG. 2, the next processing operation is to analyze individual reports within a report repository based upon selected consolidated report criteria (block80). Executable code is invoked to perform this operation. This results in the generation of a consolidated report (block 82).
- FIG. 3 illustrates a
consolidated report 28. In particular, the figure illustrates aconsolidated report 28 with a firstquarter sales field 90, a secondquarter sales field 92, a thirdquarter sales field 94, a fourthquarter sales field 96, and atotal sales field 98, which represents the sum of the individual sales fields. Observe here that theconsolidated report 28 was created based upon data inindividual reports 32A-32D, instead of accessing a database. Therefore, a new report is available without rebuilding the database schema. - The
consolidated report 28 shows trends across data found in time stamped instances of other reports. Thus, theconsolidated report 28 has captured snapshots of data over an extended period of time. It should be further appreciated that the database source of the individual reports used to generate theconsolidated report 28 is irrelevant. Thus, theconsolidated report 28 can be created from individual reports that were derived from disparate databases. Accordingly, the invention allows the merging of data from multiple databases, having either similar or disparate formats. It can also be appreciated that the invention reduces database accesses as new reports are generated from individual reports, not database accesses. In addition, the invention facilitates the decentralization of database computational activity. For example, individual reports may be created in branch offices and then transmitted to a central office. At the central office, a consolidated report is generated based upon the received reports from the branch offices. - Returning once again to FIG. 2, a final optional operation is displayed. In particular, an operation may be implemented to drill through to a source report (block100). Preferably, each field in a
consolidated report 28 has an associated link to its source report. By activating this link, the user is returned to the source report, thereby allowing drill down processing.Arrow 102 of FIG. 3 illustrates a link between the firstquarter sales field 90 and its correspondingfield 48 in source report 32A. - Now that the general features of the invention have been described, attention turns to a more specific example for the purpose of more fully illustrating the features and advantages of the invention. FIG. 6 illustrates a quarterly sales report. As shown in the design/
preview window 103, this sales report specifies quarterly sales for North America (NA), Europe (EU), and the Asia Pacific (Asia Pac). Thereport window 104 illustrates a breakdown for North American sales by country, including the U.S. and Canada. The report also reflects a total sales amount for North America for the first calendar quarter ending Mar. 31, 2002. Similarly, the report reflects a breakdown for European sales by country, including England, France, and Germany. A total sales volume for the European region for the first quarter is also supplied. Similar information is provided for the Asia Pacific region. FIGS. 7-9 reflect the same information for the subsequent quarters of 2002. - Using the previously described techniques, a consolidated report can be produced from the individual reports of FIGS.6-9. The resultant consolidated report is shown in FIG. 10. The
consolidated report 105 of FIG. 10 illustrates quarterly sales and total sales for each region (i.e., Asia Pacific, Europe, and North America). The tabular numeric data is also supplied in agraph 106 in this example. - In accordance with an embodiment of the invention, the reports used to generate the regional data can be invoked. By way of example, FIG. 11 illustrates an expanded regional data report107. In this example, the expanded regional data is for Europe and includes individual quarterly and total sales for England, France, and Germany.
- In accordance with an embodiment of the invention, further expansion or drill through to source reports can be accomplished. For example, if the link associated with the third quarter sales for France is activated, then the user receives the report of FIG. 8. If the user activates the France link108 of FIG. 8, then a detailed sales report for France in the third quarter is supplied, as shown in FIG. 12. The
detailed report 109 of FIG. 12 provides information on the individual sales transactions that produced the third quarter sales total (i.e., $765,332.34) for France. - FIG. 13 illustrates a computer network architecture that may be utilized to implement embodiments of the invention. The computer network architecture110 includes a
client computer 112. The client computer has acentral processing unit 114 connected to anetwork connection circuit 116 via abus 118. Thenetwork connection circuit 116 is also connected to anetwork transport medium 119, which may be any wired or wireless transport medium. A set of input/output devices (not shown) is also attached to thebus 118 to allow a user to input and view data. - A
memory 120 is also connected to thebus 118. Thememory 120 stores a set of executable programs. One executable program is a query module 122 (e.g., a report generation tool). Thequery module 122 utilizes standard techniques to produce a set ofreports 124A-124N. - The
query module 122 may access one or more databases resident on theclient computer 112. However, in this example, thequery module 122 accesses one or more databases resident onserver computer 130.Server computer 130 includes acentral processing unit 132 connected to anetwork connection circuit 134 via abus 136. Thenetwork connection circuit 134 is also connected to thenetwork transport medium 119. A set of input/output devices (not shown) is also attached to thebus 136 to allow a user to ipnut and view data. Amemory 138 is also connected to thebus 136. Thememory 138 stores one ormore databases 140A-140N. - A
consolidated report generator 150 may be executed from either theserver computer 130 or theclient computer 112. In this example, theclient computer 112 includes aconsolidated report generator 150 with executable instructions to implement the operations described herein. This results in the creation of one or more consolidated reports 152A-152N. Additional consolidated reports may be formed from the information contained in individual consolidated reports. - FIG. 14 illustrates a consolidated report architecture that utilizes a report as a root object in accordance with an embodiment of the invention. A
report object 160 is used to producereport instances 162A-162N. Theconsolidated report generator 150 uses thereport object 160 to define fields for a consolidated report, as discussed in connection with FIGS. 3-5. Theconsolidated report generator 150 also produces aconsolidated report 164 based upon data contained within thereport instances 162A-162N, as previously discussed. - FIG. 15 illustrates a consolidated report architecture that utilizes a root object in accordance with an embodiment of the invention. A
report object 160 is used to producereport instances 162A-162N. Theconsolidated report generator 150 is used to produce a first instance of aconsolidated report 164 and a second instance of aconsolidated report 166 based upon the data in the report instances 162. Aconsolidated report object 168 operates as a parent object to theconsolidated report instances - Different object architectures can be used to implement various consolidated report functionality. For example, consolidated reports can be programmed to run at a scheduled time. At the scheduled time, the new object inherits the superset of all instances of the parent. Security may also be implemented through various object architectures. For example, a user may be prohibited from generating a consolidated report unless the individual has access to the parent object.
- An embodiment of the present invention relates to a computer storage product with a computer-readable medium having computer code thereon for performing various computer-implemented operations. The media and computer code may be those specially designed and constructed for the purposes of the present invention, or they may be of the kind well known and available to those having skill in the computer software arts. Examples of computer-readable media include, but are not limited to: magnetic media such as hard disks, floppy disks, and magnetic tape; optical media such as CD-ROMs and holographic devices; magneto-optical media such as floptical disks; and hardware devices that are specially configured to store and execute program code, such as application-specific integrated circuits (“ASICs”), programmable logic devices (“PLDs”) and ROM and RAM devices. Examples of computer code include machine code, such as produced by a compiler, and files containing higher-level code that are executed by a computer using an interpreter. For example, an embodiment of the invention may be implemented using Java, C++, or other object-oriented programming language and development tools. Another embodiment of the invention may be implemented in hardwired circuitry in place of, or in combination with, machine-executable software instructions.
- The foregoing description, for purposes of explanation, used specific nomenclature to provide a thorough understanding of the invention. However, it will be apparent to one skilled in the art that specific details are not required in order to practice the invention. Thus, the foregoing descriptions of specific embodiments of the invention are presented for purposes of illustration and description. They are not intended to be exhaustive or to limit the invention to the precise forms disclosed; obviously, many modifications and variations are possible in view of the above teachings. The embodiments were chosen and described in order to best explain the principles of the invention and its practical applications, they thereby enable others skilled in the art to best utilize the invention and various embodiments with various modifications as are suited to the particular use contemplated. It is intended that the following claims and their equivalents define the scope of the invention.
Claims (18)
Priority Applications (8)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US10/328,744 US20040123246A1 (en) | 2002-12-23 | 2002-12-23 | Apparatus and method for creating new reports from discrete reports |
AU2003297463A AU2003297463A1 (en) | 2002-12-23 | 2003-12-19 | Apparatus and method for creating new reports from discrete reports |
EP03814307A EP1576505A4 (en) | 2002-12-23 | 2003-12-19 | Apparatus and method for creating new reports from discrete reports |
CA002510593A CA2510593A1 (en) | 2002-12-23 | 2003-12-19 | Apparatus and method for creating new reports from discrete reports |
PCT/US2003/040928 WO2004059439A2 (en) | 2002-12-23 | 2003-12-19 | Apparatus and method for creating new reports from discrete reports |
US11/166,335 US20050289137A1 (en) | 2002-12-23 | 2005-06-24 | Apparatus and method for creating from discrete reports new reports with differentiated data |
US11/166,039 US7580928B2 (en) | 2002-12-23 | 2005-06-24 | Method for creating from individual reports a consolidated data set with metadata including information about the last presentation format of data within the individual reports |
US11/182,486 US20060004842A1 (en) | 2002-12-23 | 2005-07-14 | Apparatus and method for creating new reports from a consolidated data mart |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US10/328,744 US20040123246A1 (en) | 2002-12-23 | 2002-12-23 | Apparatus and method for creating new reports from discrete reports |
Related Child Applications (3)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US11/166,335 Continuation-In-Part US20050289137A1 (en) | 2002-12-23 | 2005-06-24 | Apparatus and method for creating from discrete reports new reports with differentiated data |
US11/166,039 Continuation-In-Part US7580928B2 (en) | 2002-12-23 | 2005-06-24 | Method for creating from individual reports a consolidated data set with metadata including information about the last presentation format of data within the individual reports |
US11/182,486 Continuation-In-Part US20060004842A1 (en) | 2002-12-23 | 2005-07-14 | Apparatus and method for creating new reports from a consolidated data mart |
Publications (1)
Publication Number | Publication Date |
---|---|
US20040123246A1 true US20040123246A1 (en) | 2004-06-24 |
Family
ID=32594571
Family Applications (4)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US10/328,744 Abandoned US20040123246A1 (en) | 2002-12-23 | 2002-12-23 | Apparatus and method for creating new reports from discrete reports |
US11/166,335 Abandoned US20050289137A1 (en) | 2002-12-23 | 2005-06-24 | Apparatus and method for creating from discrete reports new reports with differentiated data |
US11/166,039 Expired - Lifetime US7580928B2 (en) | 2002-12-23 | 2005-06-24 | Method for creating from individual reports a consolidated data set with metadata including information about the last presentation format of data within the individual reports |
US11/182,486 Abandoned US20060004842A1 (en) | 2002-12-23 | 2005-07-14 | Apparatus and method for creating new reports from a consolidated data mart |
Family Applications After (3)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US11/166,335 Abandoned US20050289137A1 (en) | 2002-12-23 | 2005-06-24 | Apparatus and method for creating from discrete reports new reports with differentiated data |
US11/166,039 Expired - Lifetime US7580928B2 (en) | 2002-12-23 | 2005-06-24 | Method for creating from individual reports a consolidated data set with metadata including information about the last presentation format of data within the individual reports |
US11/182,486 Abandoned US20060004842A1 (en) | 2002-12-23 | 2005-07-14 | Apparatus and method for creating new reports from a consolidated data mart |
Country Status (5)
Country | Link |
---|---|
US (4) | US20040123246A1 (en) |
EP (1) | EP1576505A4 (en) |
AU (1) | AU2003297463A1 (en) |
CA (1) | CA2510593A1 (en) |
WO (1) | WO2004059439A2 (en) |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20040193644A1 (en) * | 2003-03-31 | 2004-09-30 | Baker William P. | Exposing a report as a schematized queryable data source |
US20050278304A1 (en) * | 2004-05-28 | 2005-12-15 | Cognos Incorporated | System and method for business intelligence metadata exchange |
US20080082495A1 (en) * | 2006-09-29 | 2008-04-03 | Business Objects, S.A. | Apparatus and method for searching reports |
US20120246260A1 (en) * | 2011-03-24 | 2012-09-27 | Alon Kama | Methods and systems for creating business-oriented report entities |
Families Citing this family (41)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7650576B2 (en) * | 2002-03-07 | 2010-01-19 | Business Objects Americas | Method and system for creating graphical and interactive representations of input and output data |
US9081863B2 (en) * | 2005-06-03 | 2015-07-14 | Adobe Systems Incorporated | One-click segmentation definition |
US7647423B2 (en) * | 2005-04-29 | 2010-01-12 | Morgan Stanley | Workflow based and metadata driven reporting system |
US7895578B2 (en) * | 2005-06-13 | 2011-02-22 | Business Objects Software Ltd. | Apparatus and method for using connector components to provide connectivity to interactive graphics representative of input and output data |
US9508077B2 (en) * | 2005-07-29 | 2016-11-29 | At&T Intellectual Property I, L.P. | Podcasting having inserted content distinct from the podcast content |
US20110145689A1 (en) * | 2005-09-09 | 2011-06-16 | Microsoft Corporation | Named object view over multiple files |
US7805400B2 (en) * | 2006-01-31 | 2010-09-28 | Microsoft Corporation | Report generation using metadata |
WO2008033415A2 (en) * | 2006-09-12 | 2008-03-20 | Morgan Stanley | Dynamic accessible reporting tool (dart) |
US20080086485A1 (en) * | 2006-10-06 | 2008-04-10 | Paper Thomas M | Process and system for tracking, combining and reporting on data from multiple organizations |
US20080120323A1 (en) * | 2006-11-17 | 2008-05-22 | Lehman Brothers Inc. | System and method for generating customized reports |
US20080208805A1 (en) * | 2007-02-28 | 2008-08-28 | Business Objects, S.A. | Apparatus and method for remote querying of data sources |
US8479093B2 (en) * | 2007-03-01 | 2013-07-02 | Microsoft Corporation | Metamodel-based automatic report generation |
US20080222098A1 (en) * | 2007-03-06 | 2008-09-11 | Bellsouth Intellectual Property Corporation | Methods, systems, and computer program products for providing consolidated order information |
US11403581B2 (en) * | 2007-03-07 | 2022-08-02 | Blue Yonder Group, Inc. | Sentient optimization for continuous supply chain management |
US20080271127A1 (en) * | 2007-04-24 | 2008-10-30 | Business Objects, S.A. | Apparatus and method for creating stand-alone business intelligence widgets within an authentication framework |
US8640033B2 (en) | 2007-06-29 | 2014-01-28 | Microsoft Corporation | Unified user experience using contextual information, data attributes and data models |
US8452636B1 (en) | 2007-10-29 | 2013-05-28 | United Services Automobile Association (Usaa) | Systems and methods for market performance analysis |
FR2925838A1 (en) * | 2007-12-28 | 2009-07-03 | Univ Franche Comte Etablisseme | AUTOMATED ANCILLARY INSERTION AND FIXATION BY STAPLING AN ANNULAR BODY, IN PARTICULAR A PROSTHESIS, ON AN ANNULAR RESILIENT VOLUME |
US20090300524A1 (en) * | 2008-05-30 | 2009-12-03 | Microsoft Corporation | Automatically assigning data bindings in visual designers |
US20090300047A1 (en) * | 2008-05-30 | 2009-12-03 | Microsoft Corporation | Automatically assigning data bindings in visual designers |
US20110153611A1 (en) * | 2009-12-22 | 2011-06-23 | Anil Babu Ankisettipalli | Extracting data from a report document |
US8819041B2 (en) * | 2009-12-22 | 2014-08-26 | Business Objects Software Limited | Analyzing data within a data report |
US20110202831A1 (en) * | 2010-02-15 | 2011-08-18 | Microsoft Coproration | Dynamic cache rebinding of processed data |
US20110238653A1 (en) * | 2010-03-25 | 2011-09-29 | Microsoft Corporation | Parsing and indexing dynamic reports |
US9747270B2 (en) | 2011-01-07 | 2017-08-29 | Microsoft Technology Licensing, Llc | Natural input for spreadsheet actions |
US8667020B2 (en) * | 2011-04-01 | 2014-03-04 | Microsoft Corporation | Placement goal-based database instance dynamic consolidation |
US8667019B2 (en) * | 2011-04-01 | 2014-03-04 | Microsoft Corporation | Placement goal-based database instance consolidation |
US8484206B2 (en) * | 2011-07-13 | 2013-07-09 | Sap Ag | Generating report of identifiers and time values |
US20130111393A1 (en) * | 2011-10-28 | 2013-05-02 | Sap Ag | Modeling reports directly from data sources |
US9053083B2 (en) | 2011-11-04 | 2015-06-09 | Microsoft Technology Licensing, Llc | Interaction between web gadgets and spreadsheets |
US9171099B2 (en) | 2012-01-26 | 2015-10-27 | Microsoft Technology Licensing, Llc | System and method for providing calculation web services for online documents |
US9372603B2 (en) * | 2013-03-12 | 2016-06-21 | Air Liquide Large Industries U.S. Lp | Data sampling method for determining salient values in a large data stream |
US10664652B2 (en) | 2013-06-15 | 2020-05-26 | Microsoft Technology Licensing, Llc | Seamless grid and canvas integration in a spreadsheet application |
US9946804B2 (en) | 2013-08-19 | 2018-04-17 | Business Objects Software Ltd | Displaying historical data associated with data values within business intelligence reports |
US9471382B2 (en) * | 2013-10-23 | 2016-10-18 | International Business Machines Corporation | Optimization of job scheduling in a computing environment |
US20160004741A1 (en) * | 2014-07-01 | 2016-01-07 | Encompass Corporation Pty Ltd. | Method and apparatus for managing corporate data |
US20170139891A1 (en) * | 2015-11-13 | 2017-05-18 | Sap Se | Shared elements for business information documents |
US20170371942A1 (en) * | 2016-06-22 | 2017-12-28 | Sap Se | Migrating of user interfaces using an enhanced unified metadata repository |
AU2017265144B2 (en) | 2016-12-02 | 2022-04-14 | Encompass Corporation Pty Ltd | Information retrieval |
US10860738B2 (en) * | 2018-01-30 | 2020-12-08 | Hewlett Packard Enterprise Development Lp | Augmented metadata and signatures for objects in object stores |
US20220019977A1 (en) * | 2020-07-17 | 2022-01-20 | Asmau Ahmed | System For Measuring And Promoting Diversity And Inclusion |
Citations (21)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5212788A (en) * | 1990-05-22 | 1993-05-18 | Digital Equipment Corporation | System and method for consistent timestamping in distributed computer databases |
US5710900A (en) * | 1995-10-12 | 1998-01-20 | Ncr Corporation | System and method for generating reports from a computer database |
US5787416A (en) * | 1994-07-29 | 1998-07-28 | Borland International, Inc. | Methods for hypertext reporting in a relational database management system |
US5899988A (en) * | 1997-02-28 | 1999-05-04 | Oracle Corporation | Bitmapped indexing with high granularity locking |
US6094655A (en) * | 1995-06-07 | 2000-07-25 | International Business Machines Corporation | Method of creating and using notes decision capsules |
US6393422B1 (en) * | 1998-11-13 | 2002-05-21 | International Business Machines Corporation | Navigation method for dynamically generated HTML pages |
US6418450B2 (en) * | 1998-01-26 | 2002-07-09 | International Business Machines Corporation | Data warehouse programs architecture |
US20020138746A1 (en) * | 2001-03-23 | 2002-09-26 | Mark Buttner | Method of generating a secure output file |
US6539370B1 (en) * | 1998-11-13 | 2003-03-25 | International Business Machines Corporation | Dynamically generated HTML formatted reports |
US6549906B1 (en) * | 2001-11-21 | 2003-04-15 | General Electric Company | System and method for electronic data retrieval and processing |
US6604110B1 (en) * | 2000-08-31 | 2003-08-05 | Ascential Software, Inc. | Automated software code generation from a metadata-based repository |
US6643635B2 (en) * | 2001-03-15 | 2003-11-04 | Sagemetrics Corporation | Methods for dynamically accessing, processing, and presenting data acquired from disparate data sources |
US6647392B1 (en) * | 2000-02-04 | 2003-11-11 | International Business Machines Corporation | Method and apparatus for the request brokering of standardized reports |
US6775675B1 (en) * | 2001-04-04 | 2004-08-10 | Sagemetrics Corporation | Methods for abstracting data from various data structures and managing the presentation of the data |
US6801910B1 (en) * | 2001-06-19 | 2004-10-05 | Microstrategy, Incorporated | Method and system for guiding drilling in a report generated by a reporting system |
US6925468B1 (en) * | 1999-10-29 | 2005-08-02 | Computer Sciences Corporation | Configuring systems for generating business transaction reports using processing relationships among entities of an organization |
US6941291B1 (en) * | 2000-12-07 | 2005-09-06 | Cisco Technology, Inc. | Method and device for a user profile repository |
US7000186B1 (en) * | 1999-05-03 | 2006-02-14 | Amicas, Inc. | Method and structure for electronically transmitting a text document and linked information |
US7015911B2 (en) * | 2002-03-29 | 2006-03-21 | Sas Institute Inc. | Computer-implemented system and method for report generation |
US7117208B2 (en) * | 2000-09-28 | 2006-10-03 | Oracle Corporation | Enterprise web mining system and method |
US7565394B1 (en) * | 2000-09-07 | 2009-07-21 | ReportEdge, LLC | Distributed report processing system and methods |
Family Cites Families (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6185560B1 (en) * | 1998-04-15 | 2001-02-06 | Sungard Eprocess Intelligance Inc. | System for automatically organizing data in accordance with pattern hierarchies therein |
US7225249B1 (en) * | 1997-09-26 | 2007-05-29 | Mci, Llc | Integrated systems for providing communications network management services and interactive generating invoice documents |
US6195653B1 (en) * | 1997-10-14 | 2001-02-27 | International Business Machines Corporation | System and method for selectively preparing customized reports of query explain data |
WO2001061544A1 (en) * | 2000-02-16 | 2001-08-23 | Bea Systems, Inc. | Open market collaboration system for enterprise wide electronic commerce |
US6643661B2 (en) * | 2000-04-27 | 2003-11-04 | Brio Software, Inc. | Method and apparatus for implementing search and channel features in an enterprise-wide computer system |
US6738798B1 (en) * | 2000-06-01 | 2004-05-18 | Ge Medical Technology Services, Inc. | Automated monitoring of collection of operational data from medical imaging devices |
US7058843B2 (en) * | 2001-01-16 | 2006-06-06 | Infonet Services Corporation | Method and apparatus for computer network analysis |
US7051038B1 (en) * | 2002-06-28 | 2006-05-23 | Microsoft Corporation | Method and system for a reporting information services architecture |
-
2002
- 2002-12-23 US US10/328,744 patent/US20040123246A1/en not_active Abandoned
-
2003
- 2003-12-19 WO PCT/US2003/040928 patent/WO2004059439A2/en not_active Application Discontinuation
- 2003-12-19 CA CA002510593A patent/CA2510593A1/en not_active Abandoned
- 2003-12-19 AU AU2003297463A patent/AU2003297463A1/en not_active Abandoned
- 2003-12-19 EP EP03814307A patent/EP1576505A4/en not_active Withdrawn
-
2005
- 2005-06-24 US US11/166,335 patent/US20050289137A1/en not_active Abandoned
- 2005-06-24 US US11/166,039 patent/US7580928B2/en not_active Expired - Lifetime
- 2005-07-14 US US11/182,486 patent/US20060004842A1/en not_active Abandoned
Patent Citations (21)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5212788A (en) * | 1990-05-22 | 1993-05-18 | Digital Equipment Corporation | System and method for consistent timestamping in distributed computer databases |
US5787416A (en) * | 1994-07-29 | 1998-07-28 | Borland International, Inc. | Methods for hypertext reporting in a relational database management system |
US6094655A (en) * | 1995-06-07 | 2000-07-25 | International Business Machines Corporation | Method of creating and using notes decision capsules |
US5710900A (en) * | 1995-10-12 | 1998-01-20 | Ncr Corporation | System and method for generating reports from a computer database |
US5899988A (en) * | 1997-02-28 | 1999-05-04 | Oracle Corporation | Bitmapped indexing with high granularity locking |
US6418450B2 (en) * | 1998-01-26 | 2002-07-09 | International Business Machines Corporation | Data warehouse programs architecture |
US6393422B1 (en) * | 1998-11-13 | 2002-05-21 | International Business Machines Corporation | Navigation method for dynamically generated HTML pages |
US6539370B1 (en) * | 1998-11-13 | 2003-03-25 | International Business Machines Corporation | Dynamically generated HTML formatted reports |
US7000186B1 (en) * | 1999-05-03 | 2006-02-14 | Amicas, Inc. | Method and structure for electronically transmitting a text document and linked information |
US6925468B1 (en) * | 1999-10-29 | 2005-08-02 | Computer Sciences Corporation | Configuring systems for generating business transaction reports using processing relationships among entities of an organization |
US6647392B1 (en) * | 2000-02-04 | 2003-11-11 | International Business Machines Corporation | Method and apparatus for the request brokering of standardized reports |
US6604110B1 (en) * | 2000-08-31 | 2003-08-05 | Ascential Software, Inc. | Automated software code generation from a metadata-based repository |
US7565394B1 (en) * | 2000-09-07 | 2009-07-21 | ReportEdge, LLC | Distributed report processing system and methods |
US7117208B2 (en) * | 2000-09-28 | 2006-10-03 | Oracle Corporation | Enterprise web mining system and method |
US6941291B1 (en) * | 2000-12-07 | 2005-09-06 | Cisco Technology, Inc. | Method and device for a user profile repository |
US6643635B2 (en) * | 2001-03-15 | 2003-11-04 | Sagemetrics Corporation | Methods for dynamically accessing, processing, and presenting data acquired from disparate data sources |
US20020138746A1 (en) * | 2001-03-23 | 2002-09-26 | Mark Buttner | Method of generating a secure output file |
US6775675B1 (en) * | 2001-04-04 | 2004-08-10 | Sagemetrics Corporation | Methods for abstracting data from various data structures and managing the presentation of the data |
US6801910B1 (en) * | 2001-06-19 | 2004-10-05 | Microstrategy, Incorporated | Method and system for guiding drilling in a report generated by a reporting system |
US6549906B1 (en) * | 2001-11-21 | 2003-04-15 | General Electric Company | System and method for electronic data retrieval and processing |
US7015911B2 (en) * | 2002-03-29 | 2006-03-21 | Sas Institute Inc. | Computer-implemented system and method for report generation |
Cited By (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20040193644A1 (en) * | 2003-03-31 | 2004-09-30 | Baker William P. | Exposing a report as a schematized queryable data source |
US20050278304A1 (en) * | 2004-05-28 | 2005-12-15 | Cognos Incorporated | System and method for business intelligence metadata exchange |
US8229882B2 (en) * | 2004-05-28 | 2012-07-24 | International Business Machines Corporation | System and method for business intelligence metadata exchange |
US20080082495A1 (en) * | 2006-09-29 | 2008-04-03 | Business Objects, S.A. | Apparatus and method for searching reports |
US8126887B2 (en) * | 2006-09-29 | 2012-02-28 | Business Objects Software Ltd. | Apparatus and method for searching reports |
US20120246260A1 (en) * | 2011-03-24 | 2012-09-27 | Alon Kama | Methods and systems for creating business-oriented report entities |
US9135587B2 (en) * | 2011-03-24 | 2015-09-15 | Emc Corporation | Methods and systems for creating business-oriented report entities |
Also Published As
Publication number | Publication date |
---|---|
WO2004059439A3 (en) | 2005-02-24 |
US20050289137A1 (en) | 2005-12-29 |
AU2003297463A8 (en) | 2004-07-22 |
WO2004059439A2 (en) | 2004-07-15 |
CA2510593A1 (en) | 2004-07-15 |
US20060004842A1 (en) | 2006-01-05 |
EP1576505A2 (en) | 2005-09-21 |
EP1576505A4 (en) | 2010-06-09 |
AU2003297463A1 (en) | 2004-07-22 |
US20050289136A1 (en) | 2005-12-29 |
US7580928B2 (en) | 2009-08-25 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US20040123246A1 (en) | Apparatus and method for creating new reports from discrete reports | |
US6189004B1 (en) | Method and apparatus for creating a datamart and for creating a query structure for the datamart | |
US10042955B2 (en) | System and method for non-programmers to dynamically manage multiple sets of XML document data | |
US8126887B2 (en) | Apparatus and method for searching reports | |
US6366922B1 (en) | Multi-dimensional data management system | |
US9195728B2 (en) | Dynamically filtering aggregate reports based on values resulting from one or more previously applied filters | |
US6161103A (en) | Method and apparatus for creating aggregates for use in a datamart | |
US6594672B1 (en) | Generating multidimensional output using meta-models and meta-outlines | |
US7149752B2 (en) | Method for simplifying databinding in application programs | |
US7966356B2 (en) | Apparatus and methods for displaying and determining dependency relationships among subsystems in a computer software system | |
US7925658B2 (en) | Methods and apparatus for mapping a hierarchical data structure to a flat data structure for use in generating a report | |
US7899837B2 (en) | Apparatus and method for generating queries and reports | |
US7739224B1 (en) | Method and system for creating a well-formed database using semantic definitions | |
WO2008094852A2 (en) | Apparatus and method for analyzing impact and lineage of multiple source data objects | |
US7243106B2 (en) | Static drill-through modelling | |
US8204895B2 (en) | Apparatus and method for receiving a report | |
US20060129572A1 (en) | Complex data access | |
US20090199158A1 (en) | Apparatus and method for building a component to display documents relevant to the content of a website | |
EP1634192B1 (en) | Data processing system and method for application programs in a data warehouse | |
US20070094233A1 (en) | Translating time-independent data using database operations | |
WO2008094851A2 (en) | Apparatus and method for analyzing relationships between multiple source data objects | |
EP1374090A2 (en) | Computer method and device for transporting data | |
Mitrpanont et al. | Design and development of a multiversion OLAP application | |
Wolfe | Ad Hoc Query: a reusable database access capability | |
US20060080271A1 (en) | Dynamic reporting tool for a fact warehouse, a fact contained within the fact warehouse, and a method for refreshing the fact warehouse |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
AS | Assignment |
Owner name: CRYSTAL DECISIONS, INC., CALIFORNIA Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:WU, JU;REEL/FRAME:013969/0725 Effective date: 20030317 |
|
AS | Assignment |
Owner name: BUSINESS OBJECTS AMERICAS, CALIFORNIA Free format text: MERGER;ASSIGNOR:CRYSTAL DECISIONS, INC.;REEL/FRAME:016153/0256 Effective date: 20031211 |
|
AS | Assignment |
Owner name: BUSINESS OBJECTS, S.A., FRANCE Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:BUSINESS OBJECTS AMERICAS;REEL/FRAME:016195/0671 Effective date: 20050427 |
|
AS | Assignment |
Owner name: BUSINESS OBJECTS SOFTWARE LTD., IRELAND Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:BUSINESS OBJECTS, S.A.;REEL/FRAME:020156/0411 Effective date: 20071031 Owner name: BUSINESS OBJECTS SOFTWARE LTD.,IRELAND Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:BUSINESS OBJECTS, S.A.;REEL/FRAME:020156/0411 Effective date: 20071031 |
|
STCB | Information on status: application discontinuation |
Free format text: ABANDONED -- FAILURE TO RESPOND TO AN OFFICE ACTION |