US 12,259,902 B1
Federating multidimensional OLAP data from different sources
Olivier Tsoungui, Viry Chatillon (FR); and Christian Ah-Soon, Carrieres-sur-Seine (FR)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on Mar. 5, 2024, as Appl. No. 18/596,085.
Int. Cl. G06F 16/24 (2019.01); G06F 16/22 (2019.01); G06F 16/2453 (2019.01); G06F 16/25 (2019.01)
CPC G06F 16/254 (2019.01) [G06F 16/2264 (2019.01); G06F 16/24542 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A system of comprising:
at least one hardware processor; and
a non-transitory computer-readable medium storing executable instructions that, when executed, cause the at least one hardware processor to perform computer operations comprising:
creating a first view of a first data source in a data foundation layer of an application platform based on a first user input, the first data source comprising a first online analytical processing (OLAP) cube;
creating a second view of a second data source in the data foundation layer based on a second user input, the second data source being different from the first data source;
combining the first view of the first data source and the second view of the second data source in the data foundation layer;
creating metadata objects for elements of the first view of the first data source and the second view of the second data source in the data foundation layer;
generating a query execution plan based on a user-defined query specification and the metadata objects in the data foundation layer, the query execution plan comprising a first native query and a second native query;
executing the first native query on the first data source to retrieve a first dataset from the first data source;
executing the second native query on the second data source to retrieve a second dataset from the second data source; and
generating a federated dataset using the first dataset and the second dataset.