Abstract: Embodiments provide for querying and visualization of query results of graph data. An engine processes graph data to create metadata (e.g., in JSON format) identifying at least different node types and edge types that are present in a graph database. An overview visualization simplifies presentation of graph data by depicting only various different node types and graph types. The overview visualization may form the basis for formulating queries including the metadata, which are then promulgated to the graph database. Returned query results may be visualized as an overview or on a detailed node level, promoting insight and formulation of additional queries including node/edge type metadata. The engine may convert graph data query results into tabular form for consumption by relational database analytical tools. According to particular embodiments, an engine of an in-memory database may be particularly suited to perform graph data visualization, querying, and/or tabular conversion tasks.

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

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

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: Provided are a system and method for generating a preview of master data based on metadata thereof. In one example, a method includes receiving a data file including at least one table, identifying master data included in the at least one table of the data file and identifying metadata of the master data, auto-generating a visual preview of a measure of the master data based on metadata of the measure, and outputting, to a user interface, the visual preview of the measure and metadata values of the measure that are associated with the visual preview and which are capable of being changed via the user interface. The example embodiments allow a user to modify metadata associated with master data and provide a visual preview of the master data based on the changed metadata thereby giving the user instant validation of the change without requiring administrative (IT) assistance.

Abstract: Described herein is a technology for designing a dashboard. In some embodiments, first and second dashboards are provided. Conflict analysis on the first and second dashboard is performed. The conflicts are resolved if any conflicts are detected. The first and second dashboards are merged to form a merged dashboard if no conflicts are detected or after resolving the conflicts.

Abstract: A system may include a database of physical data tables including stored data, and an abstraction layer associated with the stored data. The abstraction layer may include a measure object associated with a measure, a plurality of dimension objects associated with respective dimensions, a first analysis group object linked to the measure object, to a first one or more of the plurality of dimension objects, and to a first portion of the stored data associating the measure with respective dimensions of the first one or more of the plurality of dimension objects, and a second analysis group object linked to the measure object, to a second one or more of the plurality of dimension objects, and to a second portion of the stored data associating the measure with respective dimensions of the first one or more of the plurality of dimension objects and of the second one or more of the plurality of dimension objects.

Abstract: Methods and apparatus, including computer program products, are provided for spatial analytics. The method may include generating a query including spatial context information, the query structured to include a predicate for the query and the spatial context information, the spatial context information including at least one of feature information or geometric information; and sending the query to a spatial query processor including a database in order to generate a query response in accordance with the predicate and spatial context information. Related systems, methods, and articles of manufacture are also disclosed.

Abstract: A system includes reception of a logical schema associated with data stored in a data store, generation of an input schema based on the logical schema, reception of an expression having a type of the input schema and comprising a first expression element defining an object, compilation of the first expression element based on the input schema to generate an output schema, and merger of the output schema and the input schema to generate a second input schema.

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

Abstract: A system and method for determining a set of visualization points from any given two-dimensional dataset to best describe a given visual analytic. A first user selection is received in a data processing apparatus for a chart. A chart type associated with the first user selection is identified for the chart. One or more visualization strategies are accessed from a strategy pool database based on the chart type. A second user selection is received in the data processing apparatus for a two-dimensional dataset from a data provider in communication with the data processing apparatus. The two-dimensional dataset is analyzed to determine a best strategy from the one or more visualization strategies accessed from the strategy pool database. Metadata representing the two-dimensional dataset is generated based on the best strategy, and a display representing the metadata is generated to visualize the two-dimensional dataset according to the best strategy.

Abstract: A system includes reception of a selection of a first object from a plurality of measure objects and dimension objects, determination, for each of a plurality of unselected objects of the plurality of measure objects and dimension objects, of a first number of visualizations which are associated with the first object and with the unselected object, determination of a second number of visualizations which are associated with the first object, determination, for each of the plurality of unselected objects, of a third number of visualizations which are associated with the unselected object, determination of a total number of visualizations, and determination, for each of the plurality of unselected objects, of a value associated with the unselected object based on the first number associated with the unselected object, the second number, the third number associated with the unselected object and the total number.

Abstract: According to some embodiments, information may be received about a non-relational database object, such as an InfoSet, InfoSet query, or Advanced Business Application Programming (“ABAP”) function for an enterprise resource planning system. The non-relational database object may then be mapped into a relational database model, such as a model associated with a business intelligence platform. As a result, Structured Query Language (“SQL”) inputs from a business intelligence platform may be used create reports based on information in an enterprise resource planning system.

Abstract: Embodiments link external widgets to internal data displayed being within a dashboard as part of a story. An interface allows selecting external widget(s) based upon matching with a parameter of internal data being accessed. A user may define in an interactive manner, the behavior of the external widget in terms of characteristics such as data rendering, configurable fields, update behavior, and/or access to external sources (e.g., authentication). In an example, internal geographic dashboard data may serve as a basis for accessing external data such as social media data via a custom widget searching relevant messages combined with keywords (e.g., referring to geography). An external widget may be linked to other (internal/external) widgets through a linking table, such that changed/updated data is propagated for display within the dashboard. External widgets may thus be linked to data currently being viewed in terms of chart selection, data highlighting and data filtering mechanisms.

Abstract: A spreadsheet file and a dashboard structure file characterizing a dashboard are received. These files are then analyzed to determine dependencies. Subsequently, for each determined dependency, an event listener is registered for a dependent component that corresponds to the determined dependency. These event listeners are notified of an event from an event source when a corresponding dependee is changed. Dependent components are then updated using data from a corresponding dependee in response to event notifications so that each updated dependent component can be rendered within the dashboard. Related apparatus, systems, techniques and articles are also described.

Abstract: A system includes identification of two or more information models of a database schema, where each of the two or more information models includes a plurality of dimensions and a respective measure, and is not joined to any other of the two or more information models, generation, for each of the two or more information models, of an auto join on a dimension included in the information model, reception of an object-based query including one or more objects of the two or more information models, generation of one structured language query for each of the two or more information models, obtaining of a result set for each of the two or more structured language queries, and aggregation of the result sets into an aggregated result set.

Abstract: A method for performing an iterative operation using columnar data on a massively parallel processing system includes arranging data from a data source in a columnar table format, receiving tabular data containing data points representing a forecast of future values, receiving instructions to perform an iterative calculation on the data points, and for a predetermined selection of the columnar data points, assigning portions of the predetermined selection to a parallel processing system and applying structured query language operators to the columnar data and the tabular data to calculate results of the iterative calculation. The method also includes analyzing the iterative operation to identify at least one invariant function, and creating a columnar data having data points representing the invariant function. A system for implementing the method and a non-transitory computer readable medium are also disclosed.

Abstract: In one embodiment, metadata associated with a document is received. At least one keyword is extracted from the received metadata, wherein the at least one keyword include at least one of actionable information and non-actionable information. Further, an interactive graphical document insight element is generated including a representation of the non-actionable information and one or more interactive icons representing the actionable information. The generated interactive graphical document insight element is rendered on a computer generated user interface.

Abstract: In one embodiment, a selection of a process component associated with a process flow is received. Further, a check is made to determine whether a graphical editor includes process components associated with the process flow. If the graphical editor does not include process components, the selected process component is placed on the graphical editor. If the graphical editor includes the process components, then compatibility of the selected process component with at least one of the one or more process components is determined by identifying cardinality and type of the process component. Further, the selected process component is connected to the process flow on the graphical editor based on the determined compatibility.

Abstract: Various embodiments of systems and methods for visual tracking of report changes are described herein. The used technique adds transitions between all steps of modification to a report document instead of static new pages. A classification module classifies the modifications and an identification module selects a visual effect to be used as transition state according to the classified modification.