Abstract: In some embodiments, a method receives a connection to a data source. The method analyzes metadata of the data source to determine a first type of metadata for a first type of database access and a second type of metadata for a second type of database access. The first type of metadata and the second type of metadata are combined into a data structure. Then, the method stores the data structure where the data structure is used to analyze a query to determine which of the first type of database access and the second type of database access to use for the query.

Abstract: An example method and system for display of out-of-window status indicators in a virtual shelf of a diagram window. A diagram framework displays a first portion of a diagram within a diagram window of a display device. The diagram comprises a set of shapes and a set of connectors representing a corresponding set of relationships between a set of objects. The framework detects that a first shape of the set of shapes at a first position of the first shape and a first status indicator associated with the first shape at a first position of the first status indicator are at least partially outside a first visible portion of the diagram within the diagram window. The diagram framework determines a second position of the first status indicator within the diagram window. The first status indicator at the second position of the first status indicator is displayed within the diagram window.

Abstract: The present disclosure involves systems, software, and computer implemented methods for ranking time dimensions. One example method includes receiving a request for an insight analysis for a dataset that includes a value dimension and a set of multiple date dimensions. Each date dimension is converted into a time series and a value quality factor is determined for each time series that represents a level of data quality for the time series. A time series informative factor is determined for each time series that represents how informative the time series is within a specified time window. An insight score is determined, for each time dimension, based on the determined value quality factors and the determined time series informative factors. The insight score for the time dimension is provided, for at least some of the time dimensions.

Abstract: Provided is a system and method for building context from software applications and applying the context to visual settings in a graphical user interface. In one example, the method may include receiving an identification of actions performed by a user with respect to a user interface of a software application, receiving application metadata of the actions from the software application, the application metadata providing context associated with the actions, training one or more predictive models to predict user interface preferences for the user based on the actions and the application metadata, and storing the one or more trained predictive models via a storage device.

Abstract: Provided is a system and method for combining feature sets of data via single vertical union operation. In one example, the method may include receiving a plurality of tables corresponding to a plurality of features observed from a dataset for use in machine learning, identifying columns of features within the plurality of tables which are to be combined, concatenating the identified columns of the features based on a union operation which sequentially appends the identified columns to each other, and storing the concatenated columns of the features as a combined dataset.

Abstract: Examples of dynamic database query efficiency improvement are provided herein. Query portions of a received database query can be identified as candidates for replacement. The candidates for replacement can be query portions that reduce the efficiency of the query. Alternative queries can be determined that include substitute query portion(s) in place of candidate(s) for replacement. An expected performance of the alternative queries can be determined. Based at least in part on the expected performance of the alternative queries, one or more alternative queries can be selected as replacement database queries for the received database query.

Abstract: Disclosed are systems, methods, and non-transitory computer-readable media for a continuous software development and delivery system. Currently, the software development and delivery process is complicated and time consuming. The process requires multiple checkpoints and human intervention to ensure that software updates do not cause errors in the existing software when implemented. Coordination throughout the development process is also problematic as developers may be using varying development environment that are different than the environment used to test and produce the software. The continuous development and delivery system of the present disclosure remedies these issues by providing a consistent development environment throughout the development process. This reduces issues that may arise from use of inconsistent development environments and allows for automation of previously manual portions of the software development and delivery process.

Abstract: A report repository may store report results, and a web intelligence report server may include an SDK component to manage sessions, states, security, and resource access and to receive web intelligence data model authoring information, associated with a document, via an authoring API. The web intelligence report server may further include data sources associated with a plurality of data source types and data access associated with a plurality of data layers. A compound database platform of an in-memory database may create a report result via a data flow merge operation that combines multiple data sources into a single data source, based on the web intelligence data model authoring information, the data sources, and the data access. The report result may be stored in the report repository, and the web intelligence data model may be associated with a Web intelligence document as a data Source (“WaaS”) reusable in other documents.

Abstract: The present disclosure involves systems, software, and computer implemented methods for automatically recommending one or more frequencies for time series data. One example method includes receiving a request for an insight analysis for an input time series included in a dataset. For each of multiple frequencies to analyze, the input time series is transformed into a frequency time series. An absolute percentage change impact factor and an absolute trend impact factor are determined for each frequency time series. A frequency interest score is determined based on the determined absolute percentage change factors and the determined absolute trend impact factors, for each time frequency time series. The frequency interest score is provided for at least some of the frequency time series.

Abstract: Techniques for implementing nested group hierarchies for analytics applications are disclosed. In some embodiments, a computer-implemented method comprises: creating a hierarchy object in a semantic layer based on a request comprising a definition for a nested group hierarchy, the definition specifying a hierarchical relationship structure for non-leaf group nodes and at least one leaf node, the non-leaf group nodes and the leaf node(s) corresponding to data stored in a data source in a non-hierarchical structure, the hierarchy object specifying the hierarchical relationship structure based on the definition; generating a query result based on a request comprising an indication of the hierarchy object using the hierarchy object from the semantic layer to retrieve the data from the data source; and causing the query result to be displayed on a computing device using the hierarchy object to display the retrieved data in a hierarchical format indicating the hierarchical relationship structure.

Abstract: Some embodiments provide a non-transitory machine-readable medium that stores a program executable by at least one processing unit of a device. The program renders a visualization that includes a first set of visual elements. The program further receives a request for measure values categorized according to the first level of dimension values in the first hierarchy of dimension values and a second level of dimension values in the second hierarchy of dimension values. The program also generates a query for a second set of data from the dataset. The program further sends the query to a computing system configured to manage the dataset. The program also receives the second set of data from the computing system. The program further renders a second set of visual elements. The program also replaces the first set of visual elements in the visualization with the second set of visual elements.

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 embodiments provide a program. The program receives a visualization collection definition specifying a plurality of visualization definitions for a plurality of visualization definitions. Each visualization definition in the plurality of visualization definitions specifies a multi-dimensional array of data definition. The program further identifies a set of multi-dimensional array of data definitions specified in the plurality of visualization definitions of the visualization collection definition. The program also sends a request for the set of multi-dimensional array of data definitions to a computing system. The program further receives the set of multi-dimensional array of data definitions from the computing system. The program also stores the set of multi-dimensional array of data definitions in a cache storage of the mobile device for later use.

Abstract: A system includes reception of a request to execute queries associated with an interactive data visualization, building, based on the request, of all queries required by the interactive data visualization on a background thread, reception of a query response associated with each built query on the background thread, building of a final response on the background thread based on the received query responses, and rendering, on a main thread, of the interactive data visualization based on the final response.

Abstract: A system includes reception of a filter on a first dimension of a first data model, determination of an association between a second dimension of the first data model and a first dimension of a second data model, generation of a calculated dimension based on the second dimension, the rows of the calculated dimension being identical to the rows of the first dimension, application of the filter to the rows of the calculated dimension to generate filtered rows of the calculated dimension, execution of an inner join between the filtered rows of the calculated dimension and a fact table of the second data model to generate a result table including one or more measure values of the second data model, and generation of a visualization including the result table.

Abstract: A system includes reception of an input string of words, determination, for each subset of consecutive one or more words in the input string, of one or more phrase types based on the subset, on a dictionary describing a plurality of entities, each of the plurality of entities associated with an entity type, and on a grammar describing a plurality of phrase types, each of the plurality of phrase types associated with one or more conditions, and determination of a plurality of candidate queries based on the determined phrase types.

Abstract: In some example embodiments, an indication of a selected data point of a current visualization can be received. A context of the selected data point can be determined based on a dimension of the data point, and explanation candidates can be generated based on the context of the selected data point. Each exploration candidate can have a different dimension context that is within the context of the selected data point and a corresponding value for the dimension context. For each one of the explanation candidates, a corresponding score can be generated based on a difference between the value for the explanation candidate and an average value of all the values of the explanation candidates. The explanation candidates can be ranked based on the scores. At least one of the explanation candidates can be selected based on the ranking, and selectable explanation(s) for the selected explanation candidate(s) can be displayed.

Abstract: Methods, systems, and apparatus, including computer programs encoded on a computer storage medium, to predict future Day Sales Outstanding (DSO) forecasts for a number of future time periods. In one aspect, a method includes receiving open receivables financial line item data and revenue financial line item data, providing the open receivables financial line item data to a DSO predictor engine to generate a predicted open receivables that includes a multi-step time series forecasting regression generated from the open receivables financial line item data, providing the revenue financial line item data to the DSO predictor engine to generate a predicted revenue comprising the multi-step time series forecasting regression generated from the revenue financial line item data; generating a predicted DSO with the predicted open receivables and predicted revenue, and providing the predicted DSO to a client device.

Abstract: Embodiments provide an overview visualization of graph data by rendering a graph's structure based upon different node/edge types, rather than upon a total number of nodes and/or edges. These node/edge types are recognized based upon associated metadata. The small number of different node/edge types of a typical graph reduces components for representation in the overview, simplifying that visualization and facilitating user interaction. A user can switch between the graph overview, and a different view affording node-level details. In analysis and/or querying, switching between the overview and the detailed visualization can afford natural and intuitive control over data granularity. For example the overview visualization of graph data may allow a user to initially filter on particular node types, with the subsequent node-level view permitting exploration of finer details while maintaining the overall context of the original graph.

Abstract: Some embodiments provide execution of a query on a target data model which is filtered on a measure of a source data model, even if the source data model and the target data model are not logically linked. Some embodiments further support execution of a query on a target data model which is filtered on a measure of a source data model and on a dimension filter of another data model. Some embodiments provide for a substantial amount of query execution to occur on the backend, thereby freeing client resources in comparison to prior approaches.