why using ods?

[Former Member]

i am entry level of BW, in bw ODS, key valuse are drag into data field, characteristics fileds drag into key fields . why this format using?

please any one reply me for future study. i am waiting for reply

[Former Member]

You need to use a ODS when you have to maintain the data inside BW but in a trasactional way.

The ODS works like a R3 table and maintain the data in that way.ODS doesn not cumulate data as a cube and only maintain certain fields as primary key (like R3 tables).In that way it works as a table and could be the source for an infocube...

Normally tha data in ODS is trasnferred to an infocube in order to report it through a BEX Query.