Sap Ag

Sap Se

Stefan Biedenstein

Stefan Dipper

Erich Marschall

Guenter Radestock

Andrew Ross

Olaf Meincke

Klaus Nagel

Karl-Peter Nos

Stefan Unnebrink

Jens-Peter Dittrich

Peter Karlheinz Zimmerer

Stefan Girsig

Rainer Brendle

Wolfgang Pfeifer

Hartmut Koerner

Martin Osterloh

Juergen Alfred Seyfried

Christel Rueger

Stefan Sigg

Silke Gruber

Albrecht Richter

A system may include reception of an instruction to add an extension field to a node of a business object object model, identification of at least one multi-dimensional analytical view object model including a reference field referring to the node of the business object object model, determination of at least one report associated with the determined at least one multi-dimensional analytical view object model, reception of a selection of one of the at least one report, extension of the one of the at least one multi-dimensional analytical view object model associated with the report based on the extension field, and extension of the selected report based on the extension field.

Field extensibility for analytical reports

A system may include reception of a request from a user to start a report associated with a node of a business object object model, where the node of the business object object model is associated with an access control list associating instances of the node with at least one access context restriction, determination of a first access context restriction associated with the user, retrieval of the at least one instance of the node based on the first access context restriction and on the access control list associated with the node, and presentation of an instance of the report to the user, the instance of the report populated with the at least one instance.

Authorizations for analytical reports

A system, method and article for handling ambiguous joins among a plurality of tables based on a query are disclosed. Metadata associated with the plurality tables is generated. The metadata comprises ambiguous join dimensions and special measures, where the ambiguous join dimensions provide a list of all dimensions used in conditions of the query that are ambiguous, and the special measures provide a list of measures that are affected by the ambiguous join dimensions. Data is aggregated in the plurality of tables according to an aggregation level expressed in the query and based on the metadata.

Extended handling of ambiguous joins

Systems and techniques for sequencing transactions and operations. In one aspect, an article includes one or more machine-readable media storing instructions operable to cause one or more machines to perform operations. The operations include identifying a delta of a first data store, and replicating the delta, including the transaction, to a second data store. The delta comprising a collection of changes to the first data store since a previous replication. The delta includes a transaction that began before the previous replication but did not commit before the previous replication replicated data from the first data store.

Sequencing transactions and operations

Methods and apparatus, including computer systems and program products, relating to an information management system and aggregating data by performing table scans. In general, in one aspect, the technique includes receiving a query for a response to a search on a database, loading data from the database into memory, filtering the data based on the query to generate a list of results, buffering at least one key figure corresponding to a result, buffering at least one dimension value corresponding to each key figure, aggregating the dimension values to generate an aggregate key, aggregating key figures corresponding to the sane aggregate key to generate one or more aggregate key figures, and displaying the response to the search on a display device. Loading the data may include compressing the data. Filtering the data may be performed blockwise.

Fast aggregation of compressed data using full table scans

Systems and techniques for the hybrid provision of data are described. In one aspect, a system includes a first collection of information stored in accordance with a reporting data model, a second collection of information setting forth a collection of one or more additive delta records, and an analytic engine to perform queries on the first collection of information and the second collection of information to yield an aggregated result set that is based on the contents of both the first collection of information and the second collection of information. The additive delta records each include a numeric value that characterizes the magnitude of a change to a numeric measure in the first collection and identification information that identifies the numeric measure in the first collection. The identified numeric measure is no longer current.

Hybrid data provider

Systems and techniques relating to local data repository generation facilitate analysis of business activity information. In general, in one implementation, a technique includes: receiving results of an analysis query applied against a business information warehouse, the results including at least one key performance indicator generated in response to the analysis query by an analytical engine of the business information warehouse from other information stored in underlying databases of the business information warehouse; transforming the results such that the results appear to be obtained directly from an underlying relational database source; and sending the transformed results to a software component that generates from the transformed results a local data repository, a self-describing collection of integrated records, wherein the local data repository supports dynamic analytical processing operations on the results of the analysis query.

Local data repository generation

Methods and apparatus, including computer systems and program products, relating to an information management system and aggregating data by performing table scans. In general, in one aspect, the technique includes receiving a query for a response to a search on a database, loading data from the database into memory, filtering the data based on the query to generate a list of results, buffering at least one key figure corresponding to a result, buffering at least one dimension value corresponding to each key figure, aggregating the dimension values to generate an aggregate key, aggregating key figures corresponding to the same aggregate key to generate one or more aggregate key figures, and displaying the response to the search on a display device. Loading the data may include compressing the data. Filtering the data may be performed blockwise.

Growing community of inventors

Bad Schoenborn, Germany

Stefan Biedenstein