Data Retrieval path when bex query executed on an info cube
when a bex query is executed on an info cube,how is the data fetched for the characteristics and key figures.
Jorge Castillo Medina replied
BW310 is the document that describes this. To know this, it's important to know the technical implementation of tables that cube has. .I could send you some documentation for this by mail.
A resume is:
- Fact table: One for cube with key figures and SID IDs
- SID tables: One for dimension
- InfoObject tables: Some tables for attributes, time-dependant attributes, texts
The Key Figures are fetched from fact table and aggregated with the SID IDs selected from SID tables and InfoObject tables.