cancel
Showing results for 
Search instead for 
Did you mean: 

Differences between an InfoCube and ODS object

Former Member
0 Kudos

Hello All,

I am always hearing that an ODS overwrites data while a cube adds data loaded, and an ODS is a flat table etc.

Does anyone have a comprehensive document/article on how they differ so that I can be weary when doing data loads etc and be in a better position to not make a mistake when deleting data out of the targets etc, especially since financial data is so sensitive.

Thank you and kind regards,

Keith Kibuuka

Accepted Solutions (1)

Accepted Solutions (1)

srikanthbwbw
Active Participant
0 Kudos

Hi

ODS holds transactional level data..Its just as a flat table..its not based on multidimensional model. ODS have three tables

1. Active table

2. change log

3. New table

Cube holds aggregated data which is not as detailed as ODS. Cube is based on multidimensional model. Cube have 2 tables

1. E table

2. F table.

Data cleansing takes place in ODS. Its has overwrite functionality where as cube doenst. for ex

s/o number: 1001

Material :M100

Price :1000

Quantity: 50Kgs

Quantity delivered :25kgs

You loaded this is cube and ODS

Next day you delivered remaiing 25 kgs and loaded the data into ODS and Cube

In ODS because of overwrite functinality. the data will store in this way

s/o number: 1001

Material :M100

Price :1000

Quantity: 50Kgs

Quantity delivered :50kgs

Where as in cube the first time you loaded

s/o number: 1001

Material :M100

Price :1000

Quantity: 50Kgs

Quantity delivered :25kgs

when you load for the second time it will be displayed because of no overwriting functinality

s/o number: 1001

Material :M100

Price :2000

Quantity: 100Kgs

Quantity delivered :50kgs

Hope its clear

Regards

Rak

Former Member
0 Kudos

Hi,

Go thru these links

-Shreya

Former Member
0 Kudos

Hello Srikanth, example given by u is really good...

thnxxx

Nita.

Message was edited by:

nitu s

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Keith,

I found below data on another site..

-


The most important difference between ODS and BW is the existence of key fields in the ODS. In the ODS you can have up to 16 info objects as key fields. Any other info objects will either be added or overwritten! So if you have flat files and want to be able to upload them multiple times you should not load them directly into the info cube, otherwise you need to delete the old request before uploading a new one. There is the disadvantage that if you delete rows in the flat file the rows are not deleted in the ODS.

I also use ODS-Objects to upload control data for update or transfer routines. You can simply do a select on the ODS-Table /BIC/A<ODSName>00 to get the data.

-


ODS is used as an intermediate storage area of operational data for the data ware house . ODS contains high granular data . ODS are based on flat tables , resulting in simple modeling of ODS .

we can cleanse transform merge sort data to build staging tables that can later be used to populate INOFCUBE .

Thanks

-


An infocube is a multidimentionsl dat acontainer used as a basis for analysis and reporting processing. The infocube is a fact table and their associated dimension tables in a star schema. It looks like a fact table appears in the middle of the graphic, along with several surrounding dimension tables. The central fact is usually very large, measured in gigabytes. it is the table from which you retrieve the interesting data. the size of the dimension tables amounts to only 1 to 5 percent of hte size of the fact table. common dimensions are unit & time etc. There are different type of infocubes in BW, such as basic infocubes, remote infocubes etc.

An ODS is a flat data container used for reporting and data cleansing/quality assurance purpose. They are not based on star schema and are used primaily for detail reporting rather than for dimensional analyais.

-


An infocube has a fact table, which contains his facts (key figures) and a relation to dimension tables. This means that an infocube exists of more than one table. These tables all relate to each other. This is also called the star scheme, because the dimension tables all relate to the fact table, which is the central point. A dimension is for example the customer dimension, which contains all data that is important for the customer.

An ODS is a flat structure. It is just one table that contains all data.

Most of the time you use an ODS for line item data. Then you aggregate this data to an infocube.

-


cheers,

Vishvesh

0 Kudos