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 includes reception of metadata associated with one or more measures, determination of a compatibility of the two or more measures based on the metadata, and determination of a first score associated with a first visualization based on the compatibility. Some aspects include determination of a second score associated with a second visualization based on the compatibility, comparison of the first score and the second score, and recommendation of one of the first visualization or the second visualization based on the comparison.
Abstract: Providing input data in a user interface includes presenting previous data states of the user interface. One or more selections of input controls from previous data states of the user interface can be received. Data associated to those selections of input controls can be associated with corresponding input controls in a current session dialog of the user interface.
Type:
Application
Filed:
March 21, 2011
Publication date:
September 27, 2012
Applicant:
Business Objects Software Limited, an Irish Corporation
Abstract: A system may include a database of physical data tables, a logical database schema of logical entities associated with the physical data tables, and an abstraction layer comprising a plurality of dimension objects mapped to the logical entities, at least one of the plurality of dimension objects comprising one or more properties associating the at least one of the plurality of dimension objects to one or more others of the plurality of dimension objects.
Type:
Grant
Filed:
May 11, 2009
Date of Patent:
September 4, 2012
Assignee:
Business Objects Software Limited
Inventors:
Jean-Yves Cras, Serge Thepaut, Gilles Vergnory-Mion, Juan Francisco Calvente
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: 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: Some aspects relate to reception of a selection of a business intelligence report element in a first business intelligence report of a first file format, creation of a serialized description of the business intelligence report element in a second file format based on a business intelligence report element data model, reception of an instruction to add the business intelligence report element to a second business intelligence report of a third file format, and addition of the business intelligence report element to the second business intelligence report in the third file format based on the serialized description of the business intelligence report element.
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 system to query a database based on a logical schema of the database and an abstraction of the logical database schema, the abstraction including a plurality of objects and one or more properties associating one or more of the plurality of objects to one or more others of the plurality of objects. The system includes reception of a query including a first plurality of objects of the abstraction, a first one or more properties associating one of the first plurality of objects with another one of the plurality of objects, and two or more instances of a first one of the first plurality of objects.
Type:
Grant
Filed:
May 11, 2009
Date of Patent:
July 24, 2012
Assignee:
Business Objects Software Limited
Inventors:
Jean-Yves Cras, Juan Francisco Calvente, Yucheng Sha, Serge Thepaut
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 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 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 system and method to detect database schema changes are described. In various embodiments, a method of the embodiments detects database schema changes via triggers. In various embodiments, the changes are detected by comparing database schemas and determining modifications to database tables and database columns thereof. In various embodiments, the detected changes are applied to a report by generating a parse tree relevant for the modifications to database tables and columns; and traversing the tree to produce a statement to change the report to be relevant for the modifications to database tables and columns.
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: Aspects may include determination of a first security profile associated with a user and an information space, the information space comprising metadata indicating a plurality of objects mapped to logical entities of a hierarchical data structure, reception of a request from the user for an interface for creating queries to the hierarchical data structure, and determination, based on the first security profile, of a first subset of the plurality of objects based on which the user is allowed to create queries. A query is executed based on one or more of the first subset of objects, data of the hierarchical data structure is received in response to execution of the query, a second subset of the received data which the user is allowed to view is determined based on the first security profile, and the second subset of the received data is presented to the user.
Type:
Grant
Filed:
November 24, 2009
Date of Patent:
May 29, 2012
Assignee:
Business Objects Software Limited
Inventors:
Christian Ah-Soon, Marc Ferenczi, Fabien Kobus
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 dashboard evaluator is disclosed. The dashboard evaluator evaluates a dashboard design for its effectiveness in providing the information. The dashboard evaluator determines a level of compliance with dashboard design principles. The design principles may be tailored to a specific purpose and/or user.