Difference between BEX query and INFO cube ?

hello friends

i wanna know what is BEX query ?? used for creating what ? and what its exact function ??

coming to info cube please mention me what is that actually .
do info cube and bex having any relation in any aspects

My doubt may be silly but your answers may be helpful to me
Thanks in advance everyone :+1:


silverware (BOB member since 2011-08-25)

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:

[quote:3ad6b6b22f=“http://erp.wu-wien.ac.at/sapbw/08_infocube.htm”]Creating an Info Cube

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]


Andreas :de: (BOB member since 2002-06-20)

thank you very much man loved your explanation :yesnod:


silverware (BOB member since 2011-08-25)