Business Objects Software Limited

Business Objects S.a.

Ricardo Polo-Malouvier

Jean-Yves Yannick Cras

Henri Biestro

Gilles Vergnory-Mion

Grégoire Jean Antoine Cacheux

Charles Arthur Piercey

Mark Allerton

Michael Emmett Thompson

Bruno Dumant

Pierre Saurel

Sébastien Ducaule

Steve Kopp

Stephen Gary Williams

Some aspects include association of fields of a data source with one or more entity identities, one or more relation identities, and one or more attributes corresponding, respectively, to entity identities, relation identities and facet attributes defined in metadata of an enterprise social network, and reception of data from the data source. Also included is a determination, based on the data and the associated fields of the data source, of one or more source entities, one or more source entity identities associated with each of the one or more source entities, one or more source relations, one or more source relation identities associated with each of the one or more source relations, and one or more source facets associated with one or more source entities or source relations. For each determined source entity, it is determined if any of the one or more associated source entity identities is identical to an entity identity of the enterprise social network. A new entity is created in the enterprise social network corresponding to the determined source entity if it is determined that none of the one or more associated source entity identities is identical to an entity identity of the enterprise social network, and, if it is determined that one or more associated source entity identities is identical to an entity identity of the enterprise social network, the enterprise social network is updated with one or more source facets associated with the determined source entity.

Populating a multi-relational enterprise social network with disparate source data

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.

Apparatus and method for generating reports from versioned data

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.

Apparatus and method for receiving a report

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.

Apparatus and method for searching reports

A computer readable medium with executable instructions to analyze a report value, includes executable instructions to select a report value and identify the formula evaluated to produce the report value. Formal parameters associated with the formula are determined. The actual parameters used to compute the report value are located. The formula, the formal parameters and the actual parameters are then displayed.

Apparatus and method for facilitating trusted business intelligence through data context

A computer readable medium includes executable instructions to form a report; process trust values, where each trust value characterizes the accuracy of an attribute of the report; combine trust values to provide an aggregate trust value associated with the report; and supply a user with the report and the aggregate trust value.

Apparatus and method for facilitating trusted business intelligence

A system and a method for creating an analytical report on top of a multidimensional data model built on top of a relational or multidimensional database. The database operates in a computer system and provides returned values responsive to queries. Such a query is generated automatically and is deduced from a report definition. According to one embodiment, a report specification is used by the system and method of the present invention is able to defer the initial query of the data source, as is the case with conventional reporting tools and methods, until after the report has been defined. That is, the manner in which a analytic report is defined provides for an automatically generated query. Once the report has been defined, the data to populate such a report is retrieved to build the document.

Report then query capability for a multidimensional database model

A computer readable storage medium includes executable instructions to extract data model object information and report data values from data model objects in at least one semantic abstraction to define indexed fields. A search query is received. The search query is applied against the indexed fields to define matching data model objects and matching report data values. A proposed abstract query with at least one matching data model object and a corresponding semantic abstraction is generated.

Apparatus and method for generating queries and reports

A Relational Database Management System (RDBMS) having any arbitrary structure is translated into a multi-dimensional data model suitable for performing OLAP operations upon. If a relational table defining the relational model includes any tables with cardinality of 1,1 or 0,1, the tables are merged into a single table. If the relational table is not normalized, then normalization is performed and a relationship between the original table and the normalized table is created. If the relational table is normalized, but not by dependence between columns, such as in the dimension table in a snowflake schema, the normalization process is performed using the foreign key in order to generate the normalized table. Once the normalized table is generated, OLAP measures are derived from the normalized relational table by an automated method. In addition, OLAP dimensions are derived from the normalized relational table and the results of the OLAP measures derivation by an automated method according to the present invention. According to an aspect, it is possible to associate a member of a dimension to another member of the same or another dimension. According to another aspect, it is possible to create a new dimension of analysis, the members of which are all the different values that a scalar expression can take on. According to yet another aspect, it is possible to access the various instances of a Reporting Object as members in an OLAP dimension. According to the yet another aspect, it is possible to apply opaque filters or a combination of them to the data that underlies analysis.

Mapping of an RDBMS schema onto a multidimensional data model

A computer readable medium, system, apparatus and method are disclosed for generating and regenerating query results in reports whereby conditions for filtering a query against multilingual databases are preserved independent of language and/or locale. According to one embodiment of the present invention, a computer readable medium includes executable instructions to specify a language-dependent value for filtering query results during a query. Other executable instructions are included to associate a first locale to the language-dependent value, determine a key based on the language-dependent value and on the first locale, and generate a transformed query, which can include a locale variable configured to indicate a second locale for regenerating the query results to form regenerated query results for the second locale using another language-dependent value.

Computer readable medium, method and apparatus for preserving filtering conditions to query multilingual data sources at various locales when regenerating a report

An analytical reporting functionality provides full-fledged dynamic reporting capabilities on top of a multidimensional data model. A GUI facilitates replicating the same reporting data for various elements of a dimension. Additionally, direct interaction with the report to perform OLAP-style is enabled.

Growing community of inventors

Levallois-Perret, France

Ricardo Polo-Malouvier