Abstract: A method for sharing access to data from a cloud-based analytics engine may include receiving, at a first client, a message from a second client. The message may include an image of a data presentation and metadata associated with the data presentation. The first client may respond to a selection of the image of the data presentation by accessing the cloud-based analytics engine to retrieve, based on the metadata associated with the data presentation, data associated with the data presentation. The data presentation may generated for display at the first client based on the data retrieved from the cloud-based analytics engine. The data presentation displayed at the first client may be interactive to enable an application of one or more modifications to the data presentation displayed at the first client. Related systems and articles of manufacture are also provided.

Abstract: A method for accessing data stored in a database may include receiving, at an application, a request to load a data story that includes a software widget configured to create, based on a portion of data stored in a database coupled with a cloud-based analytics engine, a data presentation providing a visual representation of the portion of data. In response to the request to load the data story, a scripting engine associated with the application may execute a first programming code associated with the software widget. The first programming code may be executed to retrieve, from the cloud-based analytics engine, visualization data for rendering the data presentation. An in-app web browser associated with the application may execute a second programming code associated with the software widget. The second programming code may be executed to render, based on the visualization data retrieved from the cloud-based analytics engine, the data presentation.

Abstract: According to some embodiments, a business intelligence data store contains semantic layer information. A business intelligence language platform may receive a business intelligence language query expression from a user. The business intelligence language platform may then access the mapping information in the business intelligence model data store to compute an output type describing a result structure entity for the query expression. According to some embodiments, the output type may be used to automatically recommend at least one visualization chart to the user. Moreover, in some embodiments the output type is annotated with meta-data information about a business object.

Abstract: According to some embodiments, an abstraction engine may determine a data manipulation definition generated by a creator platform to accesses a database via a first connection protocol (e.g., ODBC). The abstraction engine may then automatically analyze the data manipulation definition to discover a connectivity parameter (e.g., a DSN, a DBMS type, a DBMS host name, a port, etc.) associated with the access to the database via the first connection protocol. The data manipulation definition may then be stored along with the connectivity parameter as a meta-connection into a metadata repository. A consuming platform may retrieve the meta-connection from the metadata repository translate the meta-connection into the database manipulation definition to accesses the database via a second connection protocol (e.g., JDBC).

Abstract: A method for configuring an algorithm for processing data in a database may include generating a plurality of rules by converting a concrete syntax representation of one or more constraints associated with a parameter of the algorithm into an abstract syntax representation of the constraints. A first input value associated with the first parameter may be received from a client via a user interface at the client. The user interface may be updated based on the first input value. The user interface may be updated by applying a first rule from the plurality of rules. The update to the user interface may include a change to a visibility, a modifiability, and/or an allowed value of a second parameter of the algorithm. Related systems and articles of manufacture, including computer program products, are also provided.

Abstract: A computer-implemented method for disaggregating data in a spreadsheet or other data structure hosted on a client computing device includes providing an analyzer module as a plug-in or add-in to a spreadsheet application on a client computing device. The analyzer module locally performs disaggregation and aggregation processes on data in the spreadsheet on the client computing device. The method includes parsing, by the analyzer module, content entered in a subject cell of the spreadsheet to determine if sets of special syntax characters corresponding to a disaggregation instruction or command precede an amount in the entered content, and accordingly disaggregating or aggregating data in the spreadsheet.

Abstract: Provided are a system and method for semantic generation and enrichment. In one example, the method includes displaying a plurality of tiles on a user interface, each displayed tile visually representing a data entity obtained from a data file, detecting, via the user interface, a selection of a first displayed tile visually representing a first data entity and a second displayed tile visually representing a second data entity, and in response to detecting the selection via the user interface, generating a new data entity based on the first data entity visually represented by the first displayed tile and the second data entity visually represented by the second tile, and displaying a new tile visually representing the newly generated data entity. Accordingly, an end user can provide semantic creation and enrichment to visually displayed data without the need for an administrator.

Abstract: Some embodiments provide a non-transitory machine-readable medium that stores a program executable by at least one processing unit of a first device. The program establishes a collaboration session with a second device. The program also receives, from the second device, analytics data shared through the collaboration session and contextual data associated with the analytics data. The program further provides additional data for display on the first device based on the contextual data associated with the analytics data.

Abstract: Embodiments relate to techniques for performing data blending operations across multiple different data sets comprising data structures with columns and rows. The data sets may be classified and displayed in a visualization (i.e., chart) in a client interface. Columns and rows from the blended data sets may be mapped together (i.e., linked). Updates to the visualization, including adding elements from the data sets, may trigger a data blending process on the backend server in communication with a database. The server may blend the specified data by generating a runtime artifact representing a calculation graph for the blend operation and query the database to retrieve a resulting data set. The data blending operation may comprise collapsing dimensions of a primary data set with linked dimensions of a secondary data sets into a blended column and aggregating values of measures in rows of the blended column of the resulting data structure.

Abstract: Embodiments relate to performing data blending operations across multiple different data sets comprising data structures with columns and rows. Columns of data sets to be blended may be linked together. Filters may be applied to data sets before the data blend operation is performed to specify which columns to be displayed in a visualization at a client interface. A direct filter may be applied to one of the data sets to obtain a filtered resulting data set. Data elements of the filtered resulting data set can be identified that correspond to the linked columns of the data sets to be blended. The results of applying the direct filter may then be used as the filtering criteria for an indirect filter to filter a second data set. The results of applying the direct and indirect filters may then be combined together in the data blending operation.

Abstract: In one embodiment, a method receives a query for data in a database system and calls a plurality of engines to analyze information for the query. A calculation graph is generated from at least a portion of the plurality of engines where each of the at least a portion of the plurality of engines add a node to the calculation graph based on analyzing of the information for the query. Then, the method executes the query by calling the nodes of the calculation graph. Each node uses metadata added to the node from a respective calculation engine to perform a calculation for the node. Then, a result of the query is output based on the respective calculations performed by the nodes.

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