Skip to Content
Former Member
Nov 27, 2005 at 07:32 PM

Basic modeling question


Hi all,

I would like to allow reporting of some system logs stored in database tables (header and item) in BW.

I have the choice of storing it in an ODS object or an InfoCube.

Storing them in an ODS object is the first option I could think of, but since I expect users to slice and dice with the data in reports, I am tempted to use an InfoCube with appropriate dimesions designed.

Having said that, I am not still not sure how slice and dice with an InfoCube is faster in this scenario as I will be able to store all data in one flat table in an ODS. With some secondary indexes I should be able to get good performance.

I am not completely sure which approach is correct. Could some one throw some more light on this?