Abstract: Systems and methods for converting structured data into database entries include receiving data values and metadata elements that form a data structure for the data values. The data values are converted into entries in database tables that are related according to the data structure formed by the metadata elements. The database table entries may be used to generate a webpage configured to report a metric of the data values.

Abstract: Techniques for data classification include matching one or more attributes of a commodity with one or more terms of a plurality of terms in a word matrix; generating, based on the matching, a vector for the commodity; and identifying, based on the vector, one or more classification regions that each define a classification of the commodity.

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: In an example embodiment, a method of automatically generating data validation rules from data stored in a column of a table is provided. Outliers for the data are determined by analyzing a profiling statistic for the data, the profiling statistic having a type. Then it is determined if a predefined limit is exceeded, based on a quantity of the outliers determined for the data through the analysis of the profiling statistic. A data validation rule is then automatically generated based on non-outliers detected in the data through the analysis of the profiling statistic, the generated data validation rule also being based on the type of the profiling statistic. The data validation rule can then be applied to data subsequently entered for the column, causing at least a portion of the data subsequently entered for the column to be rejected.

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: Parallel co-ordinates associated with a business scenario represent underlying data of the business scenario. Based upon associated categorical variables, the parallel co-ordinates are divided into a plurality of segments. Each segment includes a pair of continuous variables represented as a pair of axes of the parallel co-ordinates. The pairs of axes of the parallel co-ordinates are fragmented to generate bi-variant bins. The bi-variant bines include continuous values corresponding to each fragment of the pair of axis. An associated backend database is queried to determine aggregated tuples of continuous values between each bi-variant bin of the corresponding pair of axes. Based on the aggregated tuples, a statistical visualization of the aggregated tuples between the bi-variant bins for the axes is generating. The statistical visualization includes a distribution of the tuples for the plurality of segments corresponding to the parallel co-ordinates.

Abstract: A method and system of transforming a query at a web server are provided. An abstract syntax tree representing the query can be traversed from the top down, for each node in the abstract syntax tree: labeling the node as being in a conjunct position when the node's parent is a WHERE node; labeling the node as being not in a conjunct position when the node's parent is an OR node; and labeling the node identically to the node's parent node when the node's parent is an AND node. Then any IN node in the abstract syntax tree can be transformed to an INNER JOIN node when the IN node is labeled as being in a conjunct position. The abstract syntax tree can be converted into a Structured Query Language (SQL) query, which can then be passed to a database for processing.

Abstract: Example systems and methods of generating and distributing user-specified application information are presented. In one example, an informational code to be generated during execution of a software application is accessed. A character string specified by a first user of the software application that is descriptive of the informational code is received. The informational code and the character string are stored in a data storage device, which stores a plurality of information codes in association with corresponding character strings for the software application. The informational code is received in response to the first information code being generated during execution of the software for a second user. The character string is retrieved from the data storage device after the execution of the application based on the informational code, and transmitted for display to the second user.

Abstract: Techniques for managing content on a computing device include identifying a data object including business data values defined in a structured format, the structured format including the business data values defined by two or more first dimensions and one or more second dimensions; determining a particular first dimension of the two or more first dimensions and a particular second dimension of the one or more second dimensions; generating a display grid that is displayable on a computing device, the display grid including a portion of the business data values corresponding to the particular first dimension and the particular second dimension; and preparing the display grid for display on the computing device.

Abstract: The suggestions of objects in a real-time collaboration tool can be accomplished by first forming a first vector representing an object utilized in the real-time collaboration tool. The vector can then be compared to a plurality of vectors representing a plurality of objects stored in a database to locate one or more vectors similar to the first vector. One or more of the plurality of objects stored in the database can be recommended to a user of the real-time collaboration tool based on the comparing.

Abstract: A system and method of querying data. The method includes transforming first data according to a unified data model. The unified data model has a hierarchical structure with tree nodes and leaf nodes. A leaf node contains a table. The method further includes executing a unified data model query on the first data (having been transformed) to result in second data. The method further includes outputting the second data.

Abstract: Described herein is a technology for facilitating searching and matching of data. In accordance with one implementation, first and second feature sets are extracted. The first feature set is associated with an input data string including one or more first ideographic elements, while the second feature set is associated with a candidate string including one or more second ideographic elements. A match score of the candidate string is determined based on the first and second feature sets.

Abstract: According to some embodiments, a system, method, means, and/or computer program code are provided to facilitate use of a spreadsheet application to access information stored in a multidimensional data source. Some embodiments include determining, at an add-in module, that a local member is to be attached to an attachment element of a report generated based on the multidimensional data source. The add-in module may receive a refresh indication from the spreadsheet application and dynamically update a reference in a spreadsheet cell based on a change associated with the attachment element.

Abstract: A system to determine a hierarchical model comprising two or more associated nodes, each of the nodes associated with one or more message producers and one or more message consumers, receive a message from one of the one or more message producers; and route the message to one or more of the one or more message consumers based on the hierarchical model. The hierarchical model may include a root node and a plurality of nodes descending from the root node, the plurality of nodes including the two or more associated nodes, wherein each of the plurality of nodes is associated with a topic, a parent node, one or more child nodes, one or more message producers, and one or more message consumers. Routing the message may comprise traversing two or more nodes of the hierarchical model based on first logic.

Abstract: Apparatus, systems, and methods may operate to receive a first identification of two or more records that match and to search at least two sources of data to locate a set of potential matching records, based on element transformation to determine common characteristics of the two or more records. Further activities may include publishing the set of potential matching records, receiving a second identification of matching members of the set, and searching at least one repository to locate further matching records based on the second identification and the common characteristics. Additional apparatus, systems, and methods are disclosed.

Abstract: Described herein is a technology for facilitating process driven business intelligence. In one implementation, context data generated by a business process tool is received. One or more relevant application programming interfaces (APIs) are identified by matching the APIs with the current attribute associated with the context data. The APIs are executable by a processor to retrieve source data from an information source and provide business intelligence based on the source data.

Abstract: Various embodiments of systems and methods for providing a set of placement options to a user when a new report object is requested to be placed in an area of the report are described herein. One or more existing report objects are associated with the area of the report. The set of placement options are determined based on at least one of the following: area type of the area in which the new report object is requested to be placed and a semantic relationship between the new report object and the one or more existing report objects. In one embodiment, the area of the report includes a sub-area. The set of placement options for a sub-area is determined based on the semantic relationship of new report objects and the existing report objects associated with the area and the sub-area.

Abstract: Systems and methods of searching by a processor are described herein. In accordance with one aspect of the present disclosure, a master index having a plurality of index documents corresponding to artifacts stored in a repository is generated. An index document maps contents from a source artifact to index categories having different default boost values indicating relative importance of the index categories. A search query is fired by a user to search the master index. A result list of artifacts having contents matching (hit) the search query is generated. Artifacts are ranked in the list based on hit scores according to number of hits, which categories the hits occurred and the default boost values of the index categories.

Abstract: In one embodiment, a plurality of objects associated with a dataset and a specified number of nearest objects to be identified are received. The received objects are sorted in a structured format. Further, a key object and a number of adjacent objects corresponding to the key object are selected from the sorted plurality of objects, wherein the number of adjacent objects is selected based on the specified number of nearest objects to be identified. Furthermore, distances between the key object and the number of adjacent objects are determined to identify the specified number of nearest objects, wherein the distances are determined until the specified number of nearest objects is identified. Based on the determined distances, the specified number of nearest objects in the dataset is identified for data analysis.

Abstract: Systems and methods for generating dynamic hierarchical facets from business intelligence artifacts are described herein. In accordance with one aspect of the present disclosure, grouping information is extracted from one or more business intelligence artifacts or a semantic layer. Facets or categories are dynamically linked based on the extracted grouping information to generate one or more hierarchical facets. The hierarchical facets may be incorporated in search results to facilitate ease of navigation.