Business Objects Software Limited

Sap Ag

Sap France S.a.

Madison Poon

Ken Wong

Ashley Gadd

Julian Gosper

David Mosimann

Ryan Wayne Hanna

Huma Zaidi

Mark Siegel

William Justin Cox

Yahui Lu

Sylvie Denis

David Jordan Dalley

Gerrit Richard Neve

Lu Yahui

Christopher Harasemchuk

Marjolein Visser

Jonathan Tiu

Chun Pong Chan

James Cochrane

Embodiments effect the combination of data from different tables (e.g., of an underlying database), and the visualization of that combined table data in an incremental manner. Columns from a second table may be selectively combined with those of a first table, manually by user selection and/or automatically by best guess matching. Such matching may be based upon commonalities between table column headers. A menu may allow user selection of specific table(s)/table column(s) to be combined with a first table, as well as a manner of that combination (e.g., particular types of SQL join operations). The table data combination process is visualized step-by-step (e.g., allowing toggling and forward/backward navigation between interface screens), ensuring the user is able to follow data migration in the combined workflow, and appreciate/recognize changing values resulting therefrom. Particular embodiments may leverage the processing power of an in-memory database engine to accomplish combination and/or visualization of table data.

Visualization of combined table data

Various embodiments of systems and methods for extrapolating tabular structure to facilitate manipulation of elements in the freeform document are described herein. The freeform document includes an unstructured canvas providing users the ability to place one or more elements in the canvas. A primary column is determined by the selection of at least one element in the freeform document. Further, one or more secondary columns in the freeform document corresponding to the primary column are determined. A tabular structure in the freeform document is extrapolated based on the determined primary column and the one or more secondary columns to facilitate manipulation of elements in the freeform document, such as reordering, resizing and deleting the one or more elements, and inserting one or more new elements in the freeform document.

Extrapolating tabular structure in a freeform document

Various embodiments of systems and methods for providing a semantic guidance in a report are described herein. A mismatch is identified between a report object positioned at a location on the report and the area with which the location is associated. The mismatch is identified based on the metadata of the report object and the attribute of the area with which the location is associated. In one embodiment, the identified mismatch is displayed to a user in a tooltip. In one embodiment, if an attribute of an area of the report is changed, the mismatch is identified between the report object present in the area and the changed attribute.

Detection and display of semantic errors in a reporting tool

Parental dependency information for various data fields may be analyzed to create a data field hierarchy. Each of the data fields may be presented in a selectable list through an interface. Once a data field is selected, any immediate parent(s) and/or child(ren) field(s) of the active data element may be demarcated in the list according to the hierarchy. Additional data entry fields relating to the selected data field and its familial fields may also be displayed. Data in each of data fields may also be analyzed to identify fields with incomplete data. Systems and methods are provided.

Progressive exploration of data relationships

A computer readable storage medium includes executable instructions to calculate a default number of major tick marks as a function of a minimum distance between major tick marks and the length of a GUI control. A whole number of major tick marks that evenly divides a range of values to be mapped along the length of the GUI control is iteratively searched. A whole number of major tick marks is displayed along the length of the GUI control. The default number of major tick marks is the origin from which the search begins.

Apparatus and method for automatic scaling of tick marks

Growing community of inventors

Vancouver, Canada

Madison Poon