Abstract: The invention includes a computer readable medium with executable instructions to receive a query based on nested semantic abstractions for corresponding data sources. Data source specific queries are constructed based on the query by executing the query against the nested semantic abstractions. Each data source specific query is associated with an underlying data source described by a nested semantic abstraction. The data source specific queries are executed to produce results and the results are returned.
Type:
Grant
Filed:
August 31, 2006
Date of Patent:
February 12, 2013
Assignee:
Business Objects Software Ltd
Inventors:
Richard David Webster, Richard Bruce Cameron
Abstract: Apparatus, systems, and methods may operate to receive, sequentially, individual lines of information included in a file stored in an electronic storage medium; to locate one or more tables in a spreadsheet when at least two of the lines in a sequence are consecutive lines that begin with a non-empty cell and have a matching length; to determine a vertical orientation or a horizontal orientation of the tables based on an arrangement of the information within the lines and across the lines; and to create metadata from the information, based on the arrangement. The metadata may comprise object label names, object qualifications, and/or object data types. Additional apparatus, systems, and methods are disclosed.
Abstract: A system to process unstructured data is provided. An example system to process unstructured data comprises a receiver to access a source of unstructured data, an entity type module to determine an entity type, a rules generator to automatically generate a linguistic rule based on the determined entity type, and an entity extractor to obtain an entity from the source of unstructured data, using the linguistic rule. The entity comprises an alpha-numeric string.
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.
Type:
Application
Filed:
May 5, 2011
Publication date:
November 8, 2012
Applicant:
BUSINESS OBJECTS SOFTWARE LTD.
Inventors:
Andrey Belyy, Freda Xu, Thomas Herdan, Min He, Awez Syed, Wu Cao, Monfor Yee
Abstract: A system, computer-readable storage medium including instructions, and a computer-implemented method for manipulating one or more objects in a graphical user interface for a display device is presented. A start of a path selection mode is detected. A first path traversed by a cursor in the graphical user interface is detected, with the first path intersecting one or more objects in a plurality of objects displayed in the graphical user interface of the display device. A curve corresponding to the first path is displayed in the graphical user interface. An end of the path selection mode is detected. A selection state of the one or more objects is updated based on the curve, the selection state including a selected state and a deselected state.
Abstract: A computer readable storage medium includes executable instructions to create a publication object, associate a set of report templates with the publication object, and define a set of recipients for the publication object. A format and a destination for each report template associated with the publication object is defined. A delivery rule for the publication object is also defined, where the delivery rule specifies a condition for delivery of distinct reports to the set of recipients.
Abstract: A computer readable storage medium includes executable instructions to receive a relevancy parameter. The relevancy parameter is searched in a category ensemble including a set of categories, where the category ensemble overlies a dataset. A first order of the set of categories is created based on the relevancy of the relevancy parameter to each category in the set of categories, where the relevancy is a degree of match to the relevancy parameter. A second order of the set of categories is created based on the merit of each category to partition the dataset. The first order and the second order are combined into a final order, which is returned. A measure in the category ensemble is searched based on the relevancy parameter. The measure is returned as a selected measure, where the selected measure is a codomain of a visualization depicting a portion of the dataset.
Abstract: A representative parameterized query in a second database query language is generated from a parameterized query in first database query language. By randomly generating a query in the first database query language, translating this query into the second database query language, and then identifying locations of relevant parameters in the translated query, parameter placeholders can then be substituted at the identified locations to provide a parameterized query in the second database query language. A representative parameterized query in the second database query language can be selected by randomly generating multiple parameterized queries and applying statistical methods including Monte Carlo methods.
Abstract: A method of receiving a report includes submitting a search query, receiving a proposed abstract query and report search results, and accepting a choice between submitting the proposed abstract query to generate a report and designating an existing report from the report search results. A report is then received in accordance with the choice.
Type:
Grant
Filed:
September 29, 2006
Date of Patent:
June 19, 2012
Assignee:
Business Objects Software Ltd.
Inventors:
Ricardo Polo-Malouvier, Grégoire Jean Antoine Cacheux, Gilles Vergnory-Mion, Mark Allerton
Abstract: A computer-readable medium includes executable instructions to define a target value, define an achievement boundary range, define specific values for the achievement boundary range, and combine the target value, achievement boundary range, and specific values associated with the achievement boundary range to form an absolute target metric object.
Abstract: A computer-implemented system member selector module is described. The member selector module comprises presentation module, a request detector, and a tree view updater. The presentation module presents a tree view representing hierarchically organized data comprising a plurality of member nodes. The request detector detects a request to apply a selection function to one or more member nodes. The tree view updater updates the tree view in response to the request and produces an updated tree view that identifies the one or more member nodes as parameters of the selection function.
Abstract: A computer readable storage medium includes executable instructions to retrieve a dataset from a data source. The dataset includes a first set of categories. A data structure with nodes connected by edges is built to represent the dataset. A first set of merit values is calculated for the first set of categories. Each merit value is a measure of how efficient a category is in filtering data. The first set of categories is ordered based on a criterion. The first set of categories is then returned.
Abstract: A computer readable storage medium includes executable instructions to provide a decomposition graph visualization with a set of nodes. A selection of two or more measures is received. A measure visualization is generated for each node to illustrate a relationship between the two or more measures.
Type:
Grant
Filed:
October 12, 2007
Date of Patent:
May 29, 2012
Assignee:
Business Objects Software Ltd
Inventors:
Bruno Andre Marie Dumant, Alexis-Jean Laurent Naïbo, Jean-Claude Grosselin
Abstract: A representative parameterized query in a second database query language is generated from a parameterized query in first database query language. By randomly generating a query in the first database query language, translating this query into the second database query language, and then identifying locations of relevant parameters in the translated query, parameter placeholders can then be substituted at the identified locations to provide a parameterized query in the second database query language. A representative parameterized query in the second database query language can be selected by randomly generating multiple parameterized queries and applying statistical methods including Monte Carlo methods.
Abstract: A computer readable medium includes executable instructions to integrate a write-back module in a report document, to publish to a recipient the report document and metadata identifying the recipient, and to update a data source based on received write-back information, including the metadata identifying the recipient.
Type:
Grant
Filed:
October 12, 2007
Date of Patent:
May 15, 2012
Assignee:
Business Objects Software Ltd.
Inventors:
Todd Russell Hanna, Ryan Wayne Hanna, Ken Chi Ho Wong, Terry Penner
Abstract: A computer-readable medium is configured to receive a report processing request at a hierarchical report processor. The hierarchical report processor includes a parent process and at least one child process executing on a single processing unit, and is configured to process the report processing request as a task on the single processing unit.
Abstract: In a system and a method, a processor-implemented query module identifies a master metadata file. The processor-implemented query module retrieves one or more metadata fragment files having a global identifier matching a global identifier of the master metadata file from a communicatively coupled metadata repository. A processor-implemented generator module combines the master metadata file and the one or more metadata fragment files to form a combined metadata file. The processor-implemented generator module generates a metadata entity from the combined metadata file. The generated metadata entity includes property attributes and property attribute values designated as being owned in each of the master metadata file and the at least one metadata fragment file. A processor-implemented installer module installs the generated metadata entity for consumption by an application.
Abstract: In one embodiment the present invention includes a computer-implemented method for data cleansing using rule based formatting. The method includes tokenizing and parsing a first input data and a second input data. The method further includes including a first token in a first output data if a first formatting rule component in a formatting rule is a first valid index to said first tokenized input data. The method further includes including a second token in a second output data if said first formatting rule component in the formatting rule is a second valid index to said second tokenized input data. The method further includes formatting said first output data and said second output data according to the formatting rule.
Abstract: A computer readable storage medium includes executable instructions to receive data from a data source. Data mutation criteria is applied to designated data elements to produce mutated data that preserves an identifiable relationship between an original designated data element and a corresponding mutated data element. The data mutation criteria also produces mutated data with an identifiable relationship between related mutated data elements. The mutated data is loaded into a report and the report is displayed.
Abstract: A method of searching at least one report includes extracting at least one of report element instance content, report element instance metadata, report element instance data, and at least one of associated report element instance context content, report element instance context metadata and report element instance context data to define indexed fields. A search query is received. The search query is applied against at least one indexed field. Search query results are compiled to produce a list of relevant report element instances.
Type:
Grant
Filed:
September 29, 2006
Date of Patent:
February 28, 2012
Assignee:
Business Objects Software Ltd.
Inventors:
Ricardo Polo-Malouvier, Grégoire Jean Antoine Cacheux, Gilles Vergnory-Mion