System and method for integrated real time reporting and analytics across networked applications

Patent metadata

Field	Value
Publication number	US-9508048-B2
Application number	US-97781810-A
Country	US
Kind code	B2
Filing date	Dec 23, 2010
Priority date	Dec 23, 2010
Publication date	Nov 29, 2016
Grant date	Nov 29, 2016

Abstract

Embodiments of the present invention may provide a system and method for providing real time analytics and reporting across networked applications. The real time analytics and reporting across networked applications may be provided by extending the reporting metadata and the corresponding design- and runtime-tools. Based on a cross NWAs MDAV-Definition, the corresponding metadata (subview and subquery definitions) may be generated and assigned to the corresponding NWA-Layer (NWA software component). At deployment and configuration time, the relevant views may be activated depending availability of underlying data. At runtime, an MDAV executer (e.g., a MDAV runtime engine) may run a distributed and optimized provisioning of reporting and analytics data. The data provisioning scheme may depend on selection parameters, filters, join conditions between parts in different NWAs, analytical functions defined in the report, and the locality of the data (local or remote).

First claim

What is claimed is:

1. A non-transitory computer-readable storage medium embodied with program instructions for causing a computer to execute a method for generating a report or analytics based on real time data across a first and second networked application (NWA), the method comprising:
defining a first transactional data multi-dimensional analytical view (MDAV), belonging to a metadata repository, associated with the first NWA and a local database tenant, wherein the local database tenant stores data associated with the first NWA and the first transactional data MDAV is based on data distributed across the local database tenant;
defining a second transactional data MDAV, belonging to the metadata repository, associated with the second NWA and a remote database tenant, wherein the remote database tenant stores data associated with the second NWA and the second transactional data MDAV is based on the data distributed across the remote database tenant;
defining a first master data MDAV, belonging to the metadata repository, associated with the first NWA and the local database tenant, wherein the first master data MDAV is joined to each of the transactional data MDAVs and the first master data MDAV contains display only attributes;
defining a second master data MDAV, belonging to the metadata repository, associated with the second NWA and the remote database tenant, wherein the second master data MDAV is joined to each of the transactional data MDAVs and the second master data MDAV contains display only attributes; and
in response to receipt of a user query subsequent to the defining of the first and second transactional MDAVs and the first and second master data MDAVs:
defining a third transactional data MDAV, belonging to the metadata repository, associated with both NWAs and both of the database tenants, wherein:
the first transactional data MDAV is combined with the third transactional data MDAV in a first union operation to allow the first and third transactions data MDAVs to share data;
the second transactional data MDAV is combined with the third transactional data MDAV in a second union operation to allow the second and third transactional data MDAVs to share data; and
generating the report of analytics using a first MDAV runtime engine associated with the first NWA, wherein:
a remote filter is applied to the remote database tenant using a second MDAV runtime engine associated with the second NWA to generate a remote set of results; and
data in the remote set of results is used to apply a local filter to the local database tenant using the first MDAV runtime engine associated with the first NWA to generate the report or analytics.

2. The non-transitory computer-readable storage medium of claim 1 , wherein each NWA is built on top of a common application platform layer, wherein the metadata repository and the first and second MDAV runtime engines form part of the common application platform layer.

3. The non-transitory computer-readable storage medium of claim 2 , wherein the common application platform layer includes a foundation business object that defines a foreign key relationship between data of two business objects, the first business object being associated with the first NWA and the second business object being associated with the second NWA.

4. The non-transitory computer-readable storage medium of claim 3 , wherein the first and second business objects are stored in different database tenants corresponding to the first and second NWAs respectively.

5. The non-transitory computer-readable storage medium of claim 1 , wherein the MDAVs are defined in a cross-NWA consolidation software layer on top of the NWAs to be combined at development time.

6. The non-transitory computer-readable storage medium of claim 1 , wherein, in response to the user query, a remote filter is applied remotely first and only data satisfying the remote filter is fetched.

7. The non-transitory computer-readable storage medium of claim 1 , wherein, in response to the user query, a local filter is applied locally first and only data satisfying the local filter is fetched.

8. An apparatus for local process integration, comprising:
a memory to store computer program instructions; and
a processor configured to execute the computer program instructions to execute a method for generating a report or analytics based on real time data across a first and second networked application (NWA), the method comprising:
defining a first transactional data multi-dimensional analytic view (MDAV), belonging to a metadata repository, associated with the first NWA and a local database tenant, wherein the local database tenant stores data associated with the first NWA and the first transactional data MDAV is based on the data distributed across the local database tenant;
defining a second transactional data MDAV, belonging to the metadata repository, associated with the second NWA and a remote database tenant, wherein the remote database tenant stores data associated with the second NWA and the second transactional data MDAV is based on the data distributed across the remote database tenant;
defining a first master data MDAV, belonging to the metadata repository, associated with the first NWA and the local database tenant, wherein the first master data MDAV is joined to each of the transactional data MDAVs and the first master data MDAV contains display attributes;
defining a second master data MDAV, belonging to the metadata repository, associated with the second NWA and the remote database tenant, wherein the second master data MDAV is joined to each of the transactional data MDAVs and the second master data MDAV contains display attributes; and
in response to the receipt of a user query subsequent to the defining of the first and second transactional MDAVs and the first and second master data MDAVs:
defining a third transactional data MDAV, belonging to the metadata repository, associated with both NWAs and both of the database tenants, wherein:
the first transactional data MDAV is combined with the third transactional MDAV in a first union operation to allow the first and third transactional data MDAVs to share data,
the second transactional data MDAV is combined with the third transactional data MDAV in a second union operation to allow the second and third transactional data MDAV to share data;
generating a report or analytics using a first MDAV runtime engine associated with the first NWA, wherein:
 a remote filter is applied to the remote database tenant using a second MDAV runtime engine associated with the second NWA to generate a remote set of results, and
 data in the remote set of results used to apply a local filter to the local database tenant using the first MDAV runtime engine associated with the first NWA to generate the report analytics.

9. The apparatus of claim 8 , wherein each NWA is built on top of a common application platform layer, wherein the metadata repository and the first and second MDAV runtime engines form part of the common application platform layer.

10. The apparatus of claim 9 , wherein the common application platform layer includes a foundation business object that defines a foreign key relationship between data of two business objects, the first business object being associated with the first NWA and the second business object being associated with the second NWA.

11. The apparatus of claim 10 , wherein the first and second business objects are stored in different database tenants corresponding to the first and second NWAs respectively.

12. The apparatus of claim 8 , wherein the MDAVs are defined in a cross-NWA consolidation software layer on top of th

Assignees

• Said Bare
• Teichmann Jan
• Sap Se

Inventors

• Said Bare
• Teichmann Jan

Classifications

• G06F16/24547

  Optimisations to support specific applications; Extensibility of optimisers · CPC title

• G06F16/2272

  Management thereof · CPC title

• G06F16/20

  of structured data, e.g. relational data · CPC title

• G06F16/24544

  Join order optimisation · CPC title

• G06F16/2264

  Multidimensional index structures · CPC title