I have a basic doubt.
ODS stores consolidated data and InfoCube stores aggregated data as per SAP material. I understand that ODS is meant for detailed data in relational format viz-a-viz InfoCube. Infocube is multi-dimensional whereas ODS is not apart from many other differences which are clear.
Now, what's the difference between the two terms - consolidated v/s aggregated?