Apparatus and method for searching reports

• US 8,126,887 B2
• Filed: 09/29/2006
• Issued: 02/28/2012
• Est. Priority Date: 09/29/2006
• Status: Active Grant

• Current Assignee: Business Objects Incorporated (SAP SE)
• Original Assignee: Business Objects Incorporated (SAP SE)
• Inventors: Polo-Malouvier, Ricardo, Cacheux, Grégoire Jean Antoine, Vergnory-Mion, Gilles
• Primary Examiner(s): Cottingham, John R.
• Assistant Examiner(s): Richardson, James E.
• Application Number:
  US11/537,597
• Publication Number:
  US 20080082495A1
• Time in Patent Office: 1,978 Days
• Field of Search: 707741-743, 707/729, 707/769, 707/912, 715/219, 715/220
• US Class Current: 707/729
• CPC Class Codes: G06F 16/2264 Multidimensional index structures
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06Q 10/10 Office automation; Time management

Abstract

A method of searching at least one report includes extracting at least one of report element instance content, report element instance metadata, report element instance data, and at least one of associated report element instance context content, report element instance context metadata and report element instance context data to define indexed fields. A search query is received. The search query is applied against at least one indexed field. Search query results are compiled to produce a list of relevant report element instances.

Claims

1. A non-transitory computer readable medium storing executable instructions to:

store a plurality of reports in a repository, wherein each report includes information automatically retrieved from a data source, where the information is structured in accordance with a report schema that specifies the form in which the information should be presented, wherein the report schema defines separate report elements as structural components found inside a report;

extract, from each report of the plurality of reports, report element instance context metadata and report element instance context data to define indexed fields, wherein the report element instance context metadata specifies metadata that affects evaluation of a report element instance including context comprising a combination of parameters and the report element instance context data specifies data that affects evaluation of the report element instance;

receive a search query;

apply the search query against the indexed fields; and

compile search query results to produce a list of relevant report element instances, wherein each report element instance is a single occurrence of a report element in a report and reports are ranked based on a composite ranking factor, the composite ranking factor being compiled from two or more ranking methods including a method based on a report element instance'"'"'s level of hierarchy in a report or sub-report.

2. The computer readable medium according to claim 1 further comprising executable instructions to store a reference to a report containing each report element instance.

3. The computer readable medium according to claim 1 further comprising executable instructions to store a reference to a report and a section of a report containing each report element instance.

4. The computer readable medium according to claim 1 wherein further comprising executable instructions to store a reference to at least one data source for each report element instance.

5. The computer readable medium according to claim 1 wherein the query results further comprise a list of references to a report and section of a report containing each relevant report element instance.

6. The computer readable medium according to claim 1 further comprising executable instructions to store the indexed fields in a database.

7. The computer readable medium according to claim 1 wherein the search query is received from a user.

8. The computer readable medium according to claim 1 wherein the search query is automatically generated.

9. The computer readable medium according to claim 1 further comprising executable instructions to return compiled search query results to a user.

10. The computer readable medium according to claim 1 further comprising executable instructions to return compiled search query results to a processing module.

11. A method implemented on a computer, comprising:

storing a plurality of reports in a repository, wherein each report includes information automatically retrieved from a data source, where the information is structured in accordance with a report schema that specifies the form in which the information should be presented, wherein the report schema defines separate report elements as structural components found inside a report, the report interpreting the information from the data source and performs calculations based on at least one calculation model;

extracting, from each report of the plurality of reports in the report repository, report element instance context metadata and report element instance context data to define indexed

fields, wherein the report element instance context metadata specifies metadata that affects evaluation of a report element instance according to the at least one calculation model including context with information used to calculate a report element instance and the report element instance context data specifies data that affects evaluation of the report element instance;

receiving a search query;

applying the search query against the indexed fields; and

compiling search query results to produce a list of relevant report element instances, wherein each report element instance is a single occurrence of a report element in a report and reports are ranked based on a composite ranking factor, the composite ranking factor being compiled from two or more ranking methods including a method based on a report element instance'"'"'s level of hierarchy in a report or sub-report.

12. The method according to claim 11 further comprising storing a reference to a report containing each report element instance.

13. The method according to claim 11 further comprising storing a reference to a report and to a section of a report containing each report element instance.

14. The method according to claim 11 further comprising storing a reference to at least one data source for each report element instance.

15. The method according to claim 11 wherein the query results further comprise a list of references to a report and section of a report containing each relevant report element instance.

16. The method according to claim 11 further comprising storing the indexed fields in a database.

17. The method according to claim 11 wherein the search query is received from a user.

18. The method according to claim 11 wherein the search query is automatically generated.

19. A system comprising:

at least one data processor;

memory coupled to the at least one data processor storing instructions, which when executed cause the at least one data processor to;

store a plurality of reports in a repository, wherein each report includes information automatically retrieved from a data source, where the information is structured in accordance with a report schema that specifies the form in which the information should be presented, wherein the report schema defines separate report elements as structural components found inside a report;

extract, from each report of the plurality of reports, report element instance context metadata and report element instance context data to define indexed fields, wherein the report element instance context metadata specifies metadata that affects evaluation of a report element instance including context comprising a combination of parameters and the report element instance context data specifies data that affects evaluation of the report element instance;

receive a search query;

apply the search query against the indexed fields; and

compile search query results to produce a list of relevant report element instances, wherein each report element instance is a single occurrence of a report element in a report and reports are ranked based on a composite ranking factor, the composite ranking factor being compiled from two or more ranking methods including a method based on a report element instance'"'"'s level of hierarchy in a report or sub-report.