Business Objects Software Limited

Business Objects S.a.

Sap Se

Sap France S.a.

Sap Ag

Sap France

Jean-Yves Yannick Cras

Ricardo Polo-Malouvier

Henri Biestro

Helmut Petritsch

Gilles Vergnory-Mion

Charles Arthur Piercey

Juan Francisco Calvente

Marie-Aude Aufaure

Bogdan Marinoiu

Serge Thepaut

Gilles Vergnory Mion

Damien Guinan

Yann Le Biannic

Michael Emmett Thompson

Pierre Saurel

Raphael Thollot

Didier Bolf

Sébastien Ducaule

Rodolphe Boixel

Raphaël Thollot

Yucheng Sha

A system includes reception of a logical schema associated with data stored in a data store, generation of an input schema based on the logical schema, reception of an expression having a type of the input schema and comprising a first expression element defining an object, compilation of the first expression element based on the input schema to generate an output schema, and merger of the output schema and the input schema to generate a second input schema.

Personal objects using data specification language

Business groups are created to secure business entities of a BI data model. In one aspect, a user to be secured is selected and a business group of the BI model is retrieved. Based on the business group, access to a business entity of the BI model is secured. The business group is associated with the business entity it secures. A value of the secured business entity is selected. A user is secured by assigning the user to the business group for the selected value. The value of the secured business entity is assigned to the user. In one aspect, requests from the user to access the secured business entity are filtered based on the assigned, to the user, value of the business entity.

Automated and delegated model-based row level security

A system includes reception of text, extraction of a plurality of linguistic entities and associated linguistic entity categories based on the text; determination of one or more semantic objects of a semantic layer based on the linguistic entity categories, and generation of a query of the semantic layer based on the plurality of linguistic entities, the associated linguistic entity categories, and the one or more semantic objects. The extraction of the plurality of linguistic entities may include identification of the plurality of linguistic entities from a plurality of semantic object-independent linguistic entity categories and a plurality of semantic object-dependent linguistic entity categories, the plurality of semantic object-dependent linguistic entity categories may be associated with the semantic layer, each of the plurality of semantic object-dependent linguistic entity categories may be associated with a respective semantic object of the semantic layer and each entity of each semantic object-dependent linguistic entity category may be associated with a value of its respective semantic object.

Deduction of analytic context based on text and semantic layer

A computer readable storage medium includes executable instructions to specify a set of database tables defining vertices and database joins defining oriented edges to form a graph. The oriented edges specify directionality characterizing dependent relationships between database tables. A query path in the graph is identified. The graph is split into a set of directed acyclic graphs. Each directed acyclic graph has a single root vertex that does not form a path to itself through oriented edges. Selected oriented edges are removed from each directed acyclic graph to form a tree corresponding to each directed acyclic graph. The tree is a sub-graph of a directed acyclic graph without loops and one list of joins relates any two database tables in the tree. A database query is generated for each tree. The database query is applied to database tables to form query results. The query results are displayed.

Processing queries using oriented query paths

Situational recommendations in heterogeneous system environment are described herein. An event is received, where the event represents an interaction between an agent and a first resource from a number of resources available at the heterogeneous system environment. At least one impacted situation of a number of situations is determined based on the event. At least one operator from a number of operators is determined to apply on the at least one impacted situation. The at least one operator updates the at least one impacted situation. Recommendation of a second resource from the number of resources is generated based on the updated situation.

Situational recommendations in heterogenous system environment

A system includes reception of a logical schema associated with a data store, generation of an input schema based on the logical schema, reception of an expression having a type of the input schema and representing the topology of a data set, the data set being an instance of the input schema, compilation of the expression to a data specification based on the input schema, and generation of a plan to execute on the data store based on the data specification.

Data schema and language

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 computer-implemented system may include determination of a similarity of a semantic projection of a set of interests of a first user to a semantic projection of a first resource, wherein the semantic projection of the set of interests of the first user and the semantic projection of the first resource conforms to a common semantic projection model. Also included may be determination of a semantic interest of the first user for the first resource in a first context based on the similarity of the semantic projection of the set of the interests of the first user to the semantic projection of the first resource, and determination of an interest measure associated with the first user, the first resource and the first context based on a rating prediction for the first user to the first resource in the first context and on the determined semantic interest of the first user for the first resource in the first context.

Situational resource rating

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.

Functionally-dependent analysis objects

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. A dynamic representation of the logical database schema is modified to include an alias of the first one of the plurality of objects, the query is modified to include the alias, one or more functional dependencies of the abstraction to be enforced are determined based on the modified query, the modified dynamic representation of the logical database schema is edited based on the determined one or more functional dependencies, and a database query is generated based on the modified query and the edited dynamic representation.

Generation of logical database schema representation based on symbolic business intelligence query

A system includes determination of a name of a semantic object associated with a semantic layer, determination of a linguistic entity category associated with the name, and storage, in association with the semantic layer, of an association between the semantic object and the linguistic entity category. Also included may be determination of a plurality of values associated with the semantic object, and creation of a custom linguistic entity category associated with the semantic object and comprising a plurality of entities, wherein each of the plurality of entities corresponds to a respective one of the plurality of values.

Association of semantic objects with linguistic entity categories

A computer readable storage medium includes executable instructions to receive a semantic abstraction describing at least one underlying data source. The semantic abstraction includes at least one dimension with at least one dimension value. Unstructured text is parsed into parsed text units. A dimension value is matched to a parsed text unit to form matched content. An indication of the matched content is stored.

Apparatus and method for associating unstructured text with structured data

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 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.

Growing community of inventors

Levallois Perret, France

Jean-Yves Yannick Cras