Sap Se

Business Objects Software Limited

Houman Ghaemi

Mark Obad

Darryl Eckstein

Justin Wong

Veljko Jovanovic

Manuel Dewald

Steve Norton

Derrick Wan

Irena Kofman

Bill (Peng Hong) Chen

Peter Tippet

Seyedhassan Mousavijavardi

The present disclosure provides improved systems, methods, and computer readable media for blending data from data sets that reside on different systems. This is done by generating subqueries from a main data model blend query, sending the subqueries to respective separate systems, accessing the results to all subqueries at a primary system, and performing a blend based on the main data model blend query at the primary system.

Remote data blending

A system includes reception of a first query of a transaction table from a first client system, generation of a first result set based on the first query, transmission of the first result set to the first client system, reception of a first subset of the first result set from the first client system, the first subset of the first result set associated with a first user, determination of whether to present a first stored comment to the first user based on the first subset of the first result set, a first context associated with the first stored comment, and data security information associated with the first user, and, if it is determined to present the first stored comment to the first user, transmission of the first stored comment to the first client system.

Context-aware data commenting system

A system includes determination of a plurality of queries, each of the plurality of queries indicating a first object as a data source, generation of a first query on the first object based on a first two or more of the plurality of queries, modification of each of the first two or more queries to indicate the first query as the data source, requesting of execution of the first query and the modified first two or more queries, and reception of a result set associated with each of the first two or more queries.

Microcubes

A system includes reception, from a client device, a database query over a first data source and a second data source, the first data source comprising a first linking entity and the second data source comprising a second linking entity, the first linking entity identified by two or more columns of the first data source defining a first hierarchy, linking of the first data source and the second data source on the first linking entity and the second linking entity, execution of a blended query on the linked data sources based on the database query to generate a result set, and transmission of the result set to the client device.

Hierarchical blending

The present disclosure describes methods, systems, and computer program products for positioning user-created data in an Online Analytical Processing (OLAP) database. A method may comprise receiving, at a server and from a client computing device, a query specifying one or more anchor members in a first hierarchy of the database and one or more user-created members to be positioned in the first hierarchy in relation to the anchor members according to a user-specified order, the first hierarchy of the database including members arranged in positions specified by the server; positioning, by the server, the user-created members in the first hierarchy of the database in relation to the anchor members according to the user-specified order, wherein the positioning comprises: determining a rank position for each of the anchor members; creating, for each of the user-created members, an auxiliary calculated member on an ancillary hierarchy, the auxiliary calculated member indicating the respective user-created member and the rank position of the associated anchor member.

Growing community of inventors

Vancouver, Canada

Houman Ghaemi