Business Objects Software Limited

Sap Se

Viren Suresh Kumar

Ivailo Ivanov

Michael Tsumura

Jason Bedard

Sarah Menard

Flavia Silvana Moser

Johnson Wong

Amir Hajizadeh

A system includes reception of a request to display a first dashboard, transmission of a request for a first dashboard data file associated with the first dashboard from a server system, reception of the first dashboard data file associated with the first dashboard from the server system, issuance a first plurality of queries of the first dashboard data file to the server system, reception of result sets in response to the first plurality of queries, building of results based on the result sets and the model data, rendering of one or more data visualizations based on the results, and presentation of the one or more data visualizations on the display.

Worker thread processing

In some example embodiments, a graphical user interface (GUI) is caused to be displayed on a computing device of a user. The GUI can be configured to enable the user to submit an identification of a dataset and at least one configuration parameter. The identification of the data source, the at least one configuration parameter, and the at least one wrangling parameter can be received via the GUI on the computing device. A sampling algorithm can be configured based on the at least one configuration parameter. A sample of data from the dataset can be generated using the configured sampling algorithm. At least one data wrangling operation can be performed on the sample of data based on the at least one wrangling parameter.

System and method of data wrangling

An improved model-based approach for undoing actions in an application that was not previously configured with an undo feature is disclosed. Object models are constructed for each object invoked by the application. Snapshots of the object model are captured after every action to preserve the object model state at different points in time. The object model includes an object tree data structure having multiple nodes comprising data and metadata for the object. The object model is frozen and editing of the object is only permitted via an undo management engine. In response to edits from the application, the undo management engine responds by unfreezing the path of object nodes from leaf node to root node in the object tree data structure. Edits are applied to the object model at the leaf node. The object model can then be re-frozen to maintain the state of the object after each action.

Model-based system and method for undoing actions in an application

A system includes determination of a first series of data points, each data point of the first series of data points comprising one or more dimension values and a value of a first measure, determination of a second series of data points, each data point of the second series of data points comprising one or more dimension values and a value of a second measure, determination of a condition associated with a relation between the first measure and the second measure and with a visual characteristic, evaluation of the condition with respect to a first portion of the first series of data points and a first portion of the second series of data points, determination of a first visual characteristic of a first area of a visualization based on the evaluation of the condition and the visual characteristic associated with the condition, and generation of a visualization comprising a first visualization of the first series of data points, a second visualization of the second series of data points, and the first area, wherein the first area exhibits the first visual characteristic.

Visualization with conditional characteristic

A system includes reception of a selection of a point of a first data visualization associated with a first measure value, reception of an instruction from the user to create a visualization based on the first measure value, determination of a first context of the first measure value, the first context comprising one or more dimension values, generation of a first numeric point visualization of the first measure value based on the first context, and presentation of a first interface comprising the first data visualization and the first numeric point visualization, where the first numeric point visualization is presented in association with the selected first measure of the first data visualization.

Dynamic chaining of data visualizations

A system includes reception, from a user, elements of a database query including a dimension and a data source, determination of metadata of the data source, the metadata describing a domain of dimension values of the dimension, determination of whether to filter the database query based on the metadata, and, if it is determined to filter the database query, automatic generation of a filtered database query to limit the domain of the dimension values of a corresponding result set to less than the domain of dimension values of the dimension.

Auto-injected query filter

Some embodiments provide a non-transitory machine-readable medium that stores a program. The program provides a first visualization that includes a first set of data from a first data model. The program further provides a second visualization that includes a second set of data from a second data model. The program also receives an association between a first attribute in the first data model and a second attribute in the second data model. The program further receives a filter on the first set of data from the first data model. The program also applies the filter on the first visualization. The program further propagates the filter to the second visualization based on the association.

Filtering for data models

Overlay visualizations are implemented utilizing data of a data layer. A table comprises a measure and two or more different dimensions mapping to a same value range. For visualization, the measure for those dimensions may be plotted along a common axis in a same chart. Accordingly, a query executes a UNION of multiple subqueries. A first subquery aggregates the first dimension over the value range, injecting a constant formula field to identify the original first dimension. A second subquery aggregates the second dimension over the value range, again injecting the constant formula field to identify the original second dimension. UNION of these subquery results presents one larger dataset for input to the overlying visualization layer. The constant formula field may be relied upon to differentiate between the combined dimensions on the common axis, allowing association of the measure values with the original dimensions in the displayed plot (e.g., via coloring).

Overlay visualizations utilizing data layer

In some example embodiments, a graphical user interface (GUI) is caused to be displayed on a computing device of a user. The GUI can be configured to enable the user to submit an identification of a dataset and at least one configuration parameter. The identification of the data source and the at least one configuration parameter can be received via the GUI on the computing device. A sampling algorithm can be configured based on the at least one configuration parameter. A sample of data from the dataset can be generated using the configured sampling algorithm. The time parameter can limit an execution time of the generating of the sample of data to within a maximum amount of time indicated by the user.

A system includes reception of a request from a first execution thread to post a message to a second execution thread, a payload of the message comprising an object including a function and serialized text of the function, and, in response to the request, deletion of the function from the object to create a modified object, and calling of a method to post a second message to the second execution thread, a payload of the second message comprising the modified object and the serialized text of the function. A request is received from the second execution thread to handle the second message, the serialized text of the function is deserialized, and the deserialized text of the function is inserted into the modified object to generate a fourth object.

Function serialization for inter-thread messaging

A client receives data from a server that includes a dashboard generated at the server by converting each of a spreadsheet file and a dashboard structure file into a text-based, language-independent data interchange format. In addition, the dashboard includes at least one component dependent on at least one prompt. Thereafter, the at least one prompt is asynchronously rendered in a graphical user interface at the client. Data is later received that includes answers to one or more prompts. At least one query is subsequently executed based on the received answers. After results of the executed at least one query is received, the component having a corresponding received answer is rendered in the dashboard. Related apparatus, systems, techniques and articles are also described.

Asynchronous dashboard query prompting

A dataset and some user selected columns of the dataset are received by a statistical analysis module for analysis. The statistical analysis module generates a score for each unselected column of the dataset based on statistical analysis of the unselected columns and all or a subset of the selected columns. A ranking of the unselected columns is presented to the user for selection of one additional column of the dataset, after which the remaining unselected columns are re-ranked according to their associated scores and once again displayed to the user. The user may continue selecting from among the ranked columns until a threshold number of columns has been selected, at which point the user may deselect a selected column in order to continue selecting additional columns. A visualization suggestion application program interface then matches the selected columns with compatible visualization configurations and presents some of these visualizations to the user.

Growing community of inventors

Vancouver, Canada

Viren Suresh Kumar