Abstract: The present disclosure involves systems, software, and computer-implemented methods for merging object hierarchies. An example method includes identifying a first object hierarchy including one or more objects, each of the one or more objects representing a query associated with a data set; identifying a second object hierarchy including one or more objects; and generating a merged object hierarchy including the one or more objects from the first object hierarchy and the one or more objects from second object hierarchy, the merged hierarchy combining objects from the first and second object hierarchies that match and share a common parent object, and separately maintaining objects from the first and second object hierarchies that match and do not share a common parent object.

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

Abstract: A method and system for highlighting portions of a graph based on exception highlight rules is described. Highlight rules for a graph are received from a selection of a portion of an axis of the graph. Portions of the graph satisfying the highlight rules are identified. Visualization on the graph is generated to highlight the identified portions of the graph satisfying the highlight rules.

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: The present disclosure describes methods, systems, and computer program products for dynamic generation and modification of input schemas. One computer-implemented method includes receiving event data from a data source with an event collector, the data source registered with the event collector to transmit event data to the event collector, transmitting the received event data for analysis, saving the transmitted event data, determining whether to create or update a business intelligence view, determining whether to create or update an input schema based on the saved event data, and providing, by a computer, an input schema describing how data is represented in the database to a query generation engine.

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: Methods, systems, and computer program products for visually representing and displaying data are described. The visual representation may be a data animation. A data query may be submitted, a time measurement for processing the query may be obtained, and a sample size of the query may be adjusted based on the time measurement and a frame refresh rate of a data animation. A data animation may be generated based on one or more results of the query.

Abstract: A user may provide input to search an existing visualization (e.g., bar chart, graph) of a dataset returned in response to database querying. A highlighted visualization may then provide additional insight into relationships within the dataset. The highlighting may comprise changes to the appearance (e.g., size, color, background) of visualization elements. The search and highlighting may be executed by a functional module in an application layer of a local client in communication with database on a remote server. A search engine of the functional module may perform searching of dimension names, dimension values, and measure names within the dataset, identifying particular elements of the data set that are relevant to a search term (e.g., “q1”). Based upon recognition of relevant dataset data, a visualization engine may highlight particular elements of the visualization (e.g., changing an appearance of vertical bars showing first quarter revenue relative to vertical bars for other quarters).

Abstract: Example embodiments involve a system, computer-readable storage medium storing at least one program, and computer-implemented method for behaviorally consistent data wrangling. A local client device selects a set of raw sample data from a remote datastore. A local execution engine then applies one or more local data wrangling operations to the raw sample data. If the results of the local data wrangling operations are satisfactory, the local data wrangling operations may then be transferred to a remote data wrangling cluster. A remote execution engine being executed by the remote data wrangling cluster then applies the data wrangling operations to the larger set of raw data from which the sample raw data was obtained. As the remote execution engine and the local execution engine are of the same type, the data wrangling behavior exhibited by the local execution engine is reflected in the data wrangling behavior of the remote execution engine.

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

Abstract: Some examples of visualizing relationships in data sets can be implemented as a method by one or more computer systems. Dimension objects and multiple measure objects are displayed adjacent to a cause region and an effect region in a user interface. Each dimension object represents an input category associated with an input quantity that contributes to a total quantity in a data set. Each measure object represents an output category associated with an output quantity based on an input category. A dimension object and a measure object can be moved into the cause region and the effect region, respectively, in response to input. From the data set, an output quantity associated with the measure object is determined based on an input quantity associated with the dimension object from the total quantity in the data set. A result representing the output quantity is displayed in the measure object.

Abstract: The present disclosure describes methods, systems, and computer program products for inheriting metadata concepts from product resources into a semantic model. One computer-implemented method includes defining a plurality of core data foundations, defining a derived data foundation by linking the plurality core data foundations to the derived data foundation, defining a plurality of core business layers, defining a derived business layer by linking the plurality of core business layers to the derived business layer, and compiling, by a computer, the derived business layer with the derived business layer as a universe.

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 computer implemented system comprises one or more computer processors and a non-transitory computer-readable storage medium. The non-transitory computer-readable storage medium comprises instructions, that when executed, control the one or more computer processors to be configured for receiving a first input representative of associating the text object and the graphical representation, determining a relationship between the text object and the graphical representation, converting the text object to a control variable according to the relationship, and linking the control variable to the graphical representation, wherein the graphical representation is dynamically updated when a second input is received that modifies the control variable.

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: Embodiments provide a data caching mechanism based on a user's request (query) to a remote database, and the corresponding response (query result) received therefrom. As part of a database query, the user can define cache parameter(s). When a viable communications link becomes available to access the remote database, volumes of relevant data are returned as a query result and cached locally according to those predefined cache parameter(s). Embodiments are particularly suited to allow a mobile device to interact with data of a remote database in an efficient and reliable manner. The mobile device's small form factor, may preclude local storage of large volumes of remotely stored data. However, this can be compensated for by selectively storing data in the cache memory according to user-specified parameters, allowing the mobile device to continue to have access to relevant information in the event that communication with the remote database is degraded or lost.

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.