SAP RemoteCube 
Definition
An SAP RemoteCube is a RemoteCube that allows the definition of queries with direct access to transaction data in other SAP systems.
Use
Use SAP RemoteCubes if:
· You need very up-to-date data from an SAP source system
· You only access a small amount of data from time to time
· Only a few users execute queries simultaneously on the database.
Do not use SAP RemoteCubes if:
· You request a large amount of data in the first query navigation step, and no appropriate aggregates are available in the source system
· A lot of users execute queries simultaneously
· You frequently access the same data
Structure
SAP RemoteCubes are defined based on an InfoSource with flexible updating. They copy the characteristics and key figures of the InfoSource. Master data and hierarchies are not read directly in the source system. They are already replicated in BW when you execute a query.
The transaction data is called during execution of a query in the source system. During this process, the selections are provided to the InfoObjects if the transformation is only simple mapping of the InfoObject. If you have specified a constant in the transfer rules, the data is transferred only if this constant can be fulfilled. With more complex transformations such as routines or formulas, the selections cannot be transferred. It takes longer to read the data in the source system because the amount of data is not limited. To prevent this you can create an inversion routine for every transfer routine. Inversion is not possible with formulas, which is why SAP recommends that you use formulas instead of routines.
Integration
To be assigned to an SAP RemoteCube, a source system must meet the following requirements:
· BW Service API functions (contained in the SAP R/3 plug-in) are installed.
· The Release status of the source system is at least 4.0B
· In BW, a source system ID has been created for the source system
· DataSources from the source system that are released for direct access are assigned to the InfoSource of the SAP RemoteCube. There are active transfer rules for these combinations.
See also: