Which type of infocube is used for real time reporting ?
-
Standard Infocube
-
Real Time Infocube
-
Virtual Provider Infocube
-
All of the Above
Virtual Provider InfoCubes are specifically designed for real-time reporting in SAP BW. They allow data to be read directly from the source system without being physically stored in the cube. Standard InfoCubes store data physically and are not real-time capable. Real-time InfoCubes exist but are for planning scenarios, not operational reporting.
A VirtualProvider (Virtual Provider InfoCube) is used for real-time reporting because it doesn't physically store data in BW — it fetches data on-the-fly at query execution time from a remote source (via function module, BAPI, or direct access), so reports always reflect the current live state of the source system rather than a periodically-loaded snapshot. A 'Standard InfoCube' stores physically persisted, batch-loaded data, so it inherently reflects a point-in-time snapshot, not real-time state. 'Real Time Infocube' is a distractor name resembling a planning-enabled InfoCube (used in SEM-BPS/BI-IP for simultaneous read/write during planning), which is a different concept from real-time reporting on external live data. 'All of the Above' is wrong since only the VirtualProvider genuinely provides real-time, non-persisted access.