An SAP BEx query is a query against an SAP OLAP cube (InfoCube that is) as well as the report layout (think: alerters, crosstab, grouping of dimension values or key figures, for example). An SAP Bex query is created with the SAP Query Designer Tool. SAP BEx queries use ABAB code.
An SAP InfoCube is essetially SAP’s version of a star-model:
An SAP BW info cube includes a fact table and up to 16 dimension tables, 3 of which are predefined, i.e. Time, Unit, and Info Packages (defines extraction order and selection criteria for data load). In SAP BW, Info Cubes may be either a basic Cube, a Multi Cube, or a Remote Cube.
[/quote]
[quote:3ad6b6b22f=“http://www.big4guy.com/index.php/2006/10/25/sap_bw_infocubes_beginners_guide_to_info”]In its esence, Infocube is a data container. Data containers are used as a basis for analysis and reporting processes in SAP BW. Infocubes in SAP BW serve exactly this purpose. Infocubes in SAP consist of Key figures and characteristics. You can find some detailed information on key figures here. Simply speaking, infocube is any repository which contains data. Moving on to the types of infocubes. In SAP BW, there are basically two classes of infocubes
[/quote]