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]

hi venkat..

welcome to sdn..

There could be many reasons

- when you want to laod document level record and reporting performance is not important

- when you need use the overwrite feature in update rules

- when you have large number of characteristics and key figures all of which are not used in reports, but you do want them to be pulled to BW

- when you want an additional datastaging which can help in creating more update rules at different levels

for more n more details

http://help.sap.com/saphelp_bw33/helpdata/en/f9/45503c242b4a67e10000000a114084/content.htm

http://help.sap.com/saphelp_bw33/helpdata/en/bd/c627c88f9e11d4b2c90050da4c74dc/content.htm

ODS stores the data in 2 dimensional format , It also contain Granular , Detailed data . But Cube will have only summarised data .

So if you need a Report that should show detailed data , Then created a qury based on Cube ans Do an RRI jump to the ODS to show the detailed report .

Eg :

Cube output :

SD NO Net Sales

00001 10000

If you press SD no you can see the item details from the ODS content like ..

ODS output

SD NO Item No Sales

00001 1 2500

00001 2 2500

00001 3 2500

00001 4 2500

Every ODS object is represented on the database by three transparent tables:

Active data: A table containing the active data (A table)

Activation queue: For saving ODS data records that are to be updated but that have not yet been activated. The data is deleted after the records have been activated.

Change log: For updating delta from the ODS Object into other data targets, such as ODS Objects or InfoCubes for example.

We do reporting from ods active table (/bic/A[odsname]00 for our own created or /bi0/A[odsname]00 for business content)

The uses of ODS:

1) It can be used as a Backup of raw data.(ODS AS PSA)

2) It can be used to provide the delta functionality, if the DS is not supporting this

3) Overwrite Functionality will be used ,if any report requirement lead to have it.

4) Some complex logic of transformations(or caluculations) can not be possible at each record level(i.e for ex: storing of Marks on the basis of Sales/returns for a month). Here we need to divide the logic into two steps. part of logic will be executed in the update rules of ODS and remaining part will be executed records comes from ODS)

More details here:

Have a look at these links which have some examples:

http://help.sap.com/saphelp_bw33/helpdata/en/10/54853b175d214ee10000000a11402f/frameset.htm

http://help.sap.com/saphelp_bw33/helpdata/en/a9/49453cabf4ef6fe10000000a114084/frameset.htm

Also Refrer this link

http://help.sap.com/saphelp_nw04/helpdata/en/0e/19b33b90131e73e10000000a11402f/content.htm

Assign points if useful