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?