Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.