Sap Ag

Sap Se

Stefan Unnebrink

Klaus Nagel

Guenter Radestock

Stefan Dipper

Erich Marschall

Andrew Ross

Olaf Meincke

Sebastian Schroetel

Thomas Zurek

Stefan Biedenstein

Jens-Peter Dittrich

Frank Brunswig

Franz Faerber

Andreas Balzar

Peter Weddeling

Michael Wilking

Marco Pesarese

Christian Muenkel

Christian M Bartholomae

Selcuk Imal

Roman Moehl

Atul Rajendra Prasad Tiwari

Dirk Janning

Franz Marschall

Methods, systems, and computer-readable storage media for retrieving metadata associated with data stored within a database system of an enterprise, the metadata being provided in a first format and being used by the first system to store and access the data, providing a document including the metadata provided in an interoperable format, processing, by a deployer, the document to provide analytics engine metadata in a second format, the analytics metadata being stored in the second system and being consumable by the DB-based analytics engine to access the data from the database system of the enterprise, and retrieving, by the DB-based analytics engine, the data from the database system of the enterprise based on the analytics metadata to provide analytics data based on the data.

Enabling data access by external cloud-based analytics system

Methods, systems, and computer-readable storage media for receiving user input indicating a value of a first setting of one or more settings, the first setting defining a data integrity scenario that is be applied during a query session with a database system, the data integrity scenario defining data sources for reading data in response to one or more navigation requests, if a concurrent change occurs in the database system, receiving a query, reading, data from one or more data sources based on the query and the first setting, selectively caching at least a portion of the data based on the first setting, and providing a result for display to a user that submitted the query.

Accommodating concurrent changes in underlying data during reporting

A system and method of key figure data filters are presented. The key figure data filters are implemented in an analytical engine of a business warehouse system. The key figure data filters employ conditions, which can be expressed as a kind of selection that describe a set. A key figure data algorithm can be implemented by the analytical engine using the conditions, yet still respect hierarchies in the business warehouse database.

Key figure data filters in OLAP with hierarchies

In one embodiment, the present invention includes a computer-implemented method comprising receiving a query and generating first and second requests. The first request is sent to an analytic data store and includes a data transfer indicator representing a time period when the data record was received in the analytic data store. The second request is sent to a transactional model proxy and includes a monotonically changing value, such as a timestamp. The transactional model proxy reads data from a transactional data store based on the value in the request. Data from the analytic and transactional data stores may be aggregated and returned in response to the query.

Systems and methods for performing direct reporting access to transaction databases

This disclosure provides various software and systems for efficiently maintaining aggregates. In one aspect, a system performing a computer implemented method identifies a first change to transactional data in a business application and automatically adds an aggregate record to an aggregate data structure based on the first change. The system then identifies a second change to the transactional data in the business application, the second change comprising an update to key figures associated with the first change. The system can prohibit an update to the aggregate record in the aggregate data structure based on the second change and automatically adds a second aggregate record to the aggregate data structure based on the second change to the transactional data, where the second aggregate record comprises the update to the key figures.

Simple aggregate mode for transactional data

Systems and techniques for mapping of a transactional data model to a reporting data model are described. 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 receiving a transactional data model and a view that includes a collection of view fields, each view field referencing an object in the transactional data model, mapping one or more of a plurality of view fields in the collection to one or more of a plurality of data warehouse objects, and grouping the mapped data warehouse objects into a reporting data model.

Mapping of a transactional data model to a reporting data model

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

A first data storage schema in which a characteristic in a first dimension table is mapped by a first table and a second table can be received and a second data storage schema can be received. The first table maps the characteristic to a first object that include attributes to which time information is irrelevant to data processing activities and the second maps the characteristic to a second object that includes attributes to which time information is relevant to data processing activities. The second data storage schema includes a fact table including at least some facts drawn from the first data storage schema and a second dimension table that includes at least some characteristics drawn from at least one of the first object and the second object.

Mapping data structures

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

Neckargemuend, Germany

Stefan Unnebrink