Abstract: Various embodiments may operate to access individual lines of information included in a file stored in an electronic storage medium, to detect the existence of data clusters in the file based on neighboring cell content in a horizontal direction (corresponding to the individual lines), and in a vertical direction (orthogonal to the horizontal direction), to identify at least some of the data clusters as being associated with predefined table types (comprising vertical tables, horizontal tables, or cross tables), to merge some of the data clusters into section tables having common properties, and to transform the tables resulting from the merging activity, as well as remaining un-merged data clusters, into a single flat table. The stored file may comprise a spreadsheet file.

Abstract: A data transform leverages a known hierarchy within a target data structure, in order to improve query and mapping capabilities and enhance performance. Where a target data structure is hierarchical, output data of that target data structure is often built in the document order of the nodes in the structure (from top down and from left to right). Hence, when the data for a child node in the target structure is being built, the data for the parent nodes of the child node has been built. Embodiments utilize this available portion of the target data in the form of target columns, to increase processing efficiency of the transformation process. Use of target columns according to embodiments may also allow powerful and concise expression of mapping logic in the transform, facilitating the use of functions such as selection (e.g. Where clauses), uniqueness (e.g. DISTINCT), ordering (Order By, Group By), and Aggregation.

Abstract: A computer readable medium includes executable instructions to create a report; augment the report with metadata including a report identifier and parameter information; and export the report and metadata to a non-report electronic document.

Abstract: A computer readable storage medium includes executable instructions to receive from a requester a query for objects within a system. An index for the objects within the system that match the query is generated. The index is segmented into pages. A set of page state queries is returned to the requester. The page state queries specify criteria for retrieving objects from segments of the index.

Abstract: A computer readable storage medium includes executable instructions to retrieve a dataset from a data source, where the dataset includes a first set of categories. A data structure that represents the dataset is built. A first set of merit values for the first set of categories is calculated. The first set of categories is ordered based on a criterion. The first set of categories is returned.

Abstract: Techniques for data classification include receiving, at a local computing system, a query from a remote computing system, the query comprising data associated with a commodity, the data comprising one or more attributes of the commodity; matching the one or more attributes of the commodity with one or more terms of a plurality of terms in a word matrix that includes a plurality of nodes that each include a term of the plurality of terms and a plurality of links that each connect two or more nodes and define a similarity between the two or more nodes; generating, based on the matching, a numerical vector for the business enterprise commodity; identifying one or more classification regions that each define a classification of the commodity; and preparing the classifications for display at the remote computing system.

Abstract: Techniques for information retrieval include receiving a plurality of data records, each data record including data fields associated with a business enterprise, the data fields including a name of the business enterprise; updating a plurality of database records associated with the received plurality of data records stored in a database, each database record including attributes including the name of the business enterprise and an alias associated with the name of the business enterprise; receiving a query for a particular database record, the query including at least one of the name of the business enterprise or the alias associated with the name of the business enterprise; and preparing for display, in response to the query, one or more of the database records based on at least one of the name of the business enterprise or the alias associated with the name of the business enterprise.

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: Methods, non-transitory computer-readable media, and systems for managing business objects data sources. Multiple business objects data sources, each storing multiple data items, are accessed. For each data source, multiple computer-searchable index documents and multiple metadata tables, including master tables and mapping tables, are generated. The multiple computer-searchable index documents and the multiple metadata tables are provided to perform a search for data items in the multiple business objects data sources.

Abstract: Methods, computer-readable media, and systems for managing business objects data sources. A search query that includes multiple query terms is received. Each query term at least partially represents metadata associated with one of multiple business objects data sources that each stores multiple data items. Multiple search index documents are searched to identify one or more business objects data sources that are each associated with metadata at least partially represented by each query term. Multiple metadata tables are searched to identify metadata associated with each identified business objects data source. The identified business objects data sources are searched for data items that satisfy the identified metadata. Representations of the data items and the metadata are provided in response to receiving the search query.

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.

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: A method is provided for forming an entity cluster. In this method, a plurality of entities found in one or more data sources are identified. An entity may represent a word or a phrase found in the one or more data sources. The plurality of entities may then be organized into groups, where each group has a master entity and a set of subordinate entities. The groups are formed using a first comparison criteria. Then, using a second comparison criteria, a first group is associated with a second group. The second comparison criteria may compare the master entities associated with the first and second groups. Based on the association between the first group and the second group, the method can then determine that the first entity is related to the second entity.

Abstract: In an embodiment, a method is provided for providing feedback regarding validity of data referenced in a report. In this method, the report is accessed, and this report references data stored in a data source separate from the report. A profile of metadata associated with referencing the data source is read from the report, and this profile is verified against a current state of the data source. A mismatch is detected based on the verification and a digital watermark is added to a rendering of the report. This digital watermark informs the mismatch associated with the referenced data.

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: Disclosed is a user interface on a display for editing data transformations comprising an ETL process. A first display area presents a data representation of a data transformation. A second display area presents a view of input data, and a third display are presents a view of output data. User input to modify the data transformation is received. In response to receiving the user input, the third display area is updated with output data generated by applying the modified data transformation to the input data.

Abstract: A computer-readable medium includes a report generator configured to process a current version of a data set to generate a report including a data item. The computer-readable medium also includes a report data change tracker configured to identify a change in the data item with respect to a previous version of the data set. The computer-readable medium further includes a report data change presenter configured to superimpose an indication of the change onto the report.

Abstract: Various embodiments may operate to access individual lines of information included in a file stored in an electronic storage medium, to detect the existence of data clusters in the file based on neighboring cell content in a horizontal direction (corresponding to the individual lines), and in a vertical direction (orthogonal to the horizontal direction), to identify at least some of the data clusters as being associated with predefined table types (comprising vertical tables, horizontal tables, or cross tables), to merge some of the data clusters into section tables having common properties, and to transform the tables resulting from the merging activity, as well as remaining un-merged data clusters, into a single flat table. The stored file may comprise a spreadsheet file.

Abstract: Apparatus, systems, and methods may operate to receive an original query plan, to transform the original query plan into an equivalent executable compact query plan, and to store the compact query plan on a machine readable device. Further activities may include computing maximal source sub-queries associated with the compact query plan, and computing semi-join reductions of the maximal source sub-queries to provide an executable derivative query plan, which may also be stored on a machine readable device. Additional apparatus, systems, and methods are disclosed.

Abstract: A computer readable storage medium includes executable instructions to analyze a query associated with a report to identify query clauses. The query is applied against a data source that does not have a specified time dimension. An optimized audit log is formed from an existing audit log to store data changes of interest at the data source and temporal values associated with the data changes, where each data change corresponds to a query clause. A state table is constructed to specify the state of each query clause. Records in the optimized audit log are processed by temporal value to produce updated state tables. Transition tables are derived from the updated state tables to associate temporal values with data changes at the data source that impact a result produced by the query. Trend data is then supplied from the transition tables.