Posted by SAP BI-BO on Thursday, September 23, 2010
The main difference in Reporting from Info cube and ODS/DSO is that InfoCube is meant for Multi-Dimensional reporting while ODS/DSO reporting is like 2 dimensional reporting.
There are many points which will clearly state that reporting from Info cube is far better than that from DSO.Some major differences:
- Detailed form of data
- Flat file formate structure
- Two dimentional
- Performance is less as compared to cube
- Overwrite data functionality
- Summerised form of data
- Star schema
- 16 dimentional
- Additive data functionality
- Performance is better as compared to ods
InfoCube is prepared to visualize aggregation data and with the star schema relational tables, the data is accessed in better ways in terms of performance.
So if you use report in DSO performance is very slow compared to performance in InfoCubes.Also chk this link: