difference between ODS and CUBE

[Former Member]

Hi All,

I am SAP BW learner. I want to difference between ODS and INFOCUBE. I am getting confused in which one data will overwrite and in which duplicate data is available...

Your help is very much appreciated

Sreenath.

[Former Member · Accepted solution]

Hi Sreenath,

There are a lot of topics similar to this. Just perform a 'Search Forum' operation.

Anyway, one major difference is the manner of data storage. In ODS, data is stored in flat tables. By flat we mean to say ordinary transparent table whereas in a CUBE, it composed of multiple tables arranged in a STAR SCHEMA joined by SIDs. The purpose is to do MULTI-DIMENSIONAL Reporting

Another difference is : In ODS, you can update an existing record given the KEY. In CUBES, theres no such thing. It will accept duplicate records and during reporting, SUM the keyfigures up. Theres no EDIT previous record contents just ADD. With ODS, the procedure is UPDATE IF EXISTING (base from the Table Key) otherwise ADD RECORD.

If I have helped, just click on the Yellow Star up there...

Cheers!

--Jkyle