Business Objects Software Limited

Ali Moosavi

Alfred Fung

David Mosimann

Jung-Rung Han

Erik Schmidt

Justin Wong

Saeed Jahankhani

Embodiments relate to techniques for performing data blending operations across multiple different data sets comprising data structures with columns and rows. The data sets may be classified and displayed in a visualization (i.e., chart) in a client interface. Columns and rows from the blended data sets may be mapped together (i.e., linked). Updates to the visualization, including adding elements from the data sets, may trigger a data blending process on the backend server in communication with a database. The server may blend the specified data by generating a runtime artifact representing a calculation graph for the blend operation and query the database to retrieve a resulting data set. The data blending operation may comprise collapsing dimensions of a primary data set with linked dimensions of a secondary data sets into a blended column and aggregating values of measures in rows of the blended column of the resulting data structure.

System and method for performing blended data operations

Embodiments relate to performing data blending operations across multiple different data sets comprising data structures with columns and rows. Columns of data sets to be blended may be linked together. Filters may be applied to data sets before the data blend operation is performed to specify which columns to be displayed in a visualization at a client interface. A direct filter may be applied to one of the data sets to obtain a filtered resulting data set. Data elements of the filtered resulting data set can be identified that correspond to the linked columns of the data sets to be blended. The results of applying the direct filter may then be used as the filtering criteria for an indirect filter to filter a second data set. The results of applying the direct and indirect filters may then be combined together in the data blending operation.

Indirect filtering in blended data operations

Data blending operations are disclosed configured to blend data from a primary data set and a secondary data set. Primary and secondary data structure models are generated reflecting selected dimensions and measures of the primary and secondary data structure models upon which the data blending operation is to be performed. Each dimension and measure in the primary and secondary data structure models includes a local identifier. Unique global identifiers are assigned to each local identifier of the primary and secondary data structure models. Client queries are generated and communicated to a backend server to perform data blending on the selected dimensions and measures of the primary data set and the secondary data set. The client queries may comprise the global identifiers and mapping information between the global identifiers and local identifiers. The backend system retrieves a resulting data set in response to the data blending operation based on this mapping.

Growing community of inventors

Vancouver, Canada

Ali Moosavi