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.