which on is better-ODS/INFOCUBE for reporting

[Former Member]

Hello expert's

1.I want to know which one ODS or INFOCUBES are better (technically/functionally) for reporting purpose in BW.if some one is having any comparisons on ODS/INFOCUBE then plz pass on to me.

2.Are Z tables reliable in case of data updation and fetching when we create ODS/INFOCUBE.

3.HOW RELIABLE THE "Z"(*TABLES/REPORTS) are in SAP-BW/R/3-ABAP.

[Former Member]

Hi Gaurav,

1.The choice of ODS or cube for reporting depends upon your requirements. It depends upon several factors like the details in which you want to see the reports, the amount of data you will be looking at etc. Since ODS is a flat structure (transparent table), you can not store large amounts of data. If you want to see some reports which contains data for several years (huge), you are better off running a report on a cube. Otherwise, reporting on ODS is ok. It all depends on your requirement.

2. You definitely can extract data from Z tables in R/3. Again the type of extraction depends upon the design of the R/3 table. You should not have any problem in extracting the data from R/3 Z tables into an ODS or cube.

3. When you say Z tables/reports, they are totally custom made. So, if they are used regularly in R/3, i think they must be reliable. If they are not reliable, they would not use them in the production server.

Hope this helps.

Thanks and Regards

Subray Hegde