Generating business warehouse reports
AssigneeSap SE
InventorsLorenz E. Wiest, Kai Wachter, Karim Mohraz
Life of this patent
Estimating the term…
Abstract
Techniques for generating a report of a plurality of business warehouse system queries are described. Such techniques may identify one or more row types for each query. Thereafter, a template may be defined for each row type within a query that defines a format and a pattern for the row type. The template may be applied to query data for each query according to the row type to generate a sub-report. The sub-reports may be combined to generate an aggregated reports. Related apparatus and computer program products are also provided.
Claims20
A computer-implemented method comprising:
- initiating a plurality of business warehouse system queries;
- associating each type of query with a category;
- during runtime of each query, identifying one or more row types for each query, and defining a template for each row type within a query from the identified row types, the template defining a format and a pattern for the row type;
- applying the template to query data for each query according to the row type to generate a sub-report;
- combining at least two sub-reports to generate an aggregated report, the sub-reports being positioned relative to each other within the aggregated report based on the associated category;
- and
- displaying the aggregated report.
A system for generating a report of a plurality of business warehouse system queries, the system comprising:
- a database to store business warehouse data from a plurality of heterogeneous data providers;
- a computing system to execute a report designer program, the report designer program
- being responsive to user input from an input device, to:
- associate each query with a category;
- identify one or more row types for each query;
- define a template for each row type from the identified row types, wherein the template defines a format and a pattern for the row type;
- apply the template to query data for each query according to the row type to generate a sub-report;
- and
- combine at least two sub-reports to generate an aggregate report based on two or more queries, the sub-reports being positioned relative to each other within the aggregated report based on the associated category;
- and
- a display, coupled to the computing system, configured to display the aggregated report.
A computer program product, stored on a tangible machine-readable medium, the computer program product comprising instructions operable to cause data processing apparatus to:
- design, by the data processing apparatus, a report of a plurality of business warehouse queries comprising:
- for each query:
- associate the query with a category;
- identify a row type for a row or a row group in a report;
- define a row pattern template for each row type;
- identify one or more structural elements of the query, wherein the one or more structural elements comprise a dimension, a structure, and a hierarchy;
- associate a structural template for each of the one or more structural elements;
- and
- render a sub-report associated with the query according to one or more templates, wherein the one or more templates comprise any of the row pattern template and the structural template;
- and
- combine, by the data processing apparatus, each of the sub-reports to generate an aggregated report, the sub-reports being positioned relative to each other within the aggregated report based on the associated category;
- and
- display the aggregated sub-report.
Dependencies are inferred from the claim text.