Abstract: A method for accessing data stored in a database may include receiving a query to generate, based on blended data, a visualization. The blended data may include a first set of data from a first data source and a second set of data from a second data source. The query may also include a payload. The method may also include accessing the first set of data by injecting, into the payload, the first permission, and transmitting, to the first data source, the payload including the first permission. The method may also include accessing the second set of data by injecting, into the payload, the second permission, and transmitting, to the second data source, the payload including the first permission, the first set of data, and the second permission. The method may also include causing, using the blended data, presentation of the visualization. Related systems and articles of manufacture are provided.

Abstract: Systems, methods, and computer media for visualizing data are provided herein. The described examples allow one-dimensional data visualizations generated using visualization tools and backend components to be displayed in response to a request to view data that includes one or more sets of Cartesian columns. A data visualization request can specify data for inclusion in a data visualization and properties for the visualization, including transpose factors for data sources. The data sources having transpose factors can be cloned to represent respective combinations of the data source with each transpose factor, and then joined to other cloned or non-cloned data sources to generate the resulting one-dimensional visualization.

Abstract: A method for accessing data stored in a database may include receiving a query to generate, based on blended data, a visualization. The blended data may include a first set of data from a first data source and a second set of data from a second data source. The query may also include a payload. The method may also include accessing the first set of data by injecting, into the payload, the first permission, and transmitting, to the first data source, the payload including the first permission. The method may also include accessing the second set of data by injecting, into the payload, the second permission, and transmitting, to the second data source, the payload including the first permission, the first set of data, and the second permission. The method may also include causing, using the blended data, presentation of the visualization. Related systems and articles of manufacture are provided.

Abstract: Systems, methods, and computer media for visualizing data are provided herein. The described examples allow one-dimensional data visualizations generated using visualization tools and backend components to be displayed in response to a request to view data that includes one or more sets of Cartesian columns. A data visualization request can specify data for inclusion in a data visualization and properties for the visualization, including transpose factors for data sources. The data sources having transpose factors can be cloned to represent respective combinations of the data source with each transpose factor, and then joined to other cloned or non-cloned data sources to generate the resulting one-dimensional visualization.

Abstract: The disclosure generally describes methods, software, and systems, including a method for caching information. A request for information is received at a staging layer. A determination is made whether the requested information already exists entirely in a cache. In response to determining that the requested information does not exist entirely in the cache, at least some of the requested information from the underlying database layer is retrieved. A completeness level to which the requested information exists in the cache is determined. In response to determining that the requested information exists partially in the cache, cache-nonresident information is retrieved from the underlying database layer and merged with information in the cache. In response to determining that none of the requested information exists in the cache, the request is forwarded to the underlying database layer. The requested information is provided by the staging layer to a presentation layer.

Abstract: Various embodiments of systems and methods to render data visualizations in different analytical applications are described herein. In one aspect, a request is received to render at least a portion of data visualization by an analytical application. A visualization type and one or more data attributes are retrieved from metadata corresponding to at least the portion of the data visualization. Further, a supporting visualization type is identified in the analytical application corresponding to the visualization type of at least the portion of the data visualization. The retrieved one or more data attributes are mapped to equivalent one or more data attributes in a data source associated with the analytical application. At least the portion of the data visualization is rendered based on the supporting visualization type and the mapped one or more data attributes in a graphical user interface of the analytical application.

Abstract: The disclosure generally describes methods, software, and systems, including a method for caching information. A request for information is received at a staging layer. A determination is made whether the requested information already exists entirely in a cache. In response to determining that the requested information does not exist entirely in the cache, at least some of the requested information from the underlying database layer is retrieved. A completeness level to which the requested information exists in the cache is determined. In response to determining that the requested information exists partially in the cache, cache-nonresident information is retrieved from the underlying database layer and merged with information in the cache. In response to determining that none of the requested information exists in the cache, the request is forwarded to the underlying database layer. The requested information is provided by the staging layer to a presentation layer.

Abstract: Various embodiments of systems and methods to render data visualizations in different analytical applications are described herein. In one aspect, a request is received to render at least a portion of data visualization by an analytical application. A visualization type and one or more data attributes are retrieved from metadata corresponding to at least the portion of the data visualization. Further, a supporting visualization type is identified in the analytical application corresponding to the visualization type of at least the portion of the data visualization. The retrieved one or more data attributes are mapped to equivalent one or more data attributes in a data source associated with the analytical application. At least the portion of the data visualization is rendered based on the supporting visualization type and the mapped one or more data attributes in a graphical user interface of the analytical application.

Abstract: Disclosed are systems and methods for extracting data from a report document for analysis. A report document is retrieved from a group of report documents. Data present in the report document may include fields and associated metadata. The fields and the associated metadata present in the report are categorized as corresponding data source parameters. The data source parameters are rendered on a user interface, to receive a user definition of a scope for analyzing the data present in the report document. The data source parameters associated with the user definition are qualified to rendered result objects for each associated data source parameter. Based upon the result objects, a query is generated to define the data for analyzing the report document. Based upon a user input to the query, the data present in the report document associated to the query is extracted to generate a multi-dimensional result data.