System and Method for Integrated Real Time Reporting and Analytics Across Networked Applications

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 the NWAs to be combined.

13. The apparatus of claim 8 , wherein, in response to the user query, a remote filter is applied remotely first and only data satisfying the remote filter is fetched.

14. A computer implemented method being implemented by one or more data processors forming part of at least one computing device for local process integration, the method comprising: defining, by at least one data processor in a graphical user interface, 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 the data distributed across the local database tenant; defining, by at least one data processor in the graphical user interface, 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 transactions data MDAV is based on the data distributed across the remote database tenant; defining, by at least one data processor in the graphical user interface, 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, by at least one data processor in the graphical user interface, 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 a 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, by at least one data processor in the graphical user interface, a third transactional data MDAV, belonging to the metadata repository, associated with the first NWA and the local database tenant, wherein: the first transactional data MDAV is combined with the third transactional data MDAV in a first union operation to allow the first and the 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 MDAVs to share data; and generating, by at least one data processor in the graphical user interface, the 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 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 analytic.

15. The computer implemented method of claim 14 , 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.

16. The computer implemented method of claim 15 , 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.

17. The computer implemented method of claim 16 , wherein the first and second business objects are stored in different database tenants corresponding to the first and second NWAs respectively.

18. The computer implemented method of claim 14 , wherein the MDAVs are defined in a cross-NWA consolidation software layer on top of the NWAs to be combined.

19. The computer implemented method of claim 14 , wherein a remote filter is applied remotely first using the second MDAV runtime engine associated with the second NWA and only data satisfying the remote filter is fetched and combined with related data in the first tenant database by the first MDAV runtime engine.

20. The computer implemented method of claim 14 , wherein a local filter is applied locally first using the first MDAV runtime engine associated with the first NWA and only data satisfying the local filter is fetched and combined with related data in the second tenant database by the first MDAV runtime engine.