Question Re: ODS table in Technology Q&A

ODS table

Former Member — Tue, 28 Feb 2006 04:37:36 GMT

Hi Gurus,

From which table ODS updates data into a cube?

is it activa table or change log.

Thanks,

Ram

Re: ODS table

Former Member — Tue, 28 Feb 2006 04:42:08 GMT

Hi ram

Please go throught the following link it will give gull idea about ODS Technology

http://help.sap.com/saphelp_bw31/helpdata/en/ad/6b023b6069d22ee10000000a11402f/frameset.htm

Regards,

PRK

Message was edited by: PRK

Re: ODS table

Former Member — Tue, 28 Feb 2006 04:47:58 GMT

hi ram,

There r three tables associated with ods

1.active table is the table where active data is stored in ods.The data from this table only updates in to ods

2. new data table: A table with new or modified data since the last activation

3. changelog table : a table which contains which contains the changelog for update from one ods to another ods or data target

Regards

ravi

Pls reward with pts for the answer which are useful.

Pls .dont forget to reward pts for the previous threads u had posted.

Re: ODS table

Former Member — Tue, 28 Feb 2006 04:49:41 GMT

Hi Ram:

ODS updates the data from active table, on which we do reporting. change log table contains all the changed records data.

please let us know if u have any any questions.

please assign points if this is helpful

kavi

Re: ODS table

Former Member — Tue, 28 Feb 2006 04:59:14 GMT

Hi Ram,

Changelog table is used for updating data from ods to other data targets, whereas the active data and modified data are stored in active table and new data table respectively.

Hope it helps....let me know

Regards,

RV.

Re: ODS table

Former Member — Tue, 28 Feb 2006 05:04:24 GMT

Hello Ram,

Data targets are updated from ODS using CHANGE LOG!!

Active table stores data used for reporting.

Hope it helps.....

thanks,

Re: ODS table

Former Member — Tue, 28 Feb 2006 05:14:43 GMT

Hi RV/ABY,

Thanks for ur reply.

so for reporting Active table is used and for

updating to data target Change log is used.

Thanks

Ram

Re: ODS table

Former Member — Tue, 28 Feb 2006 05:15:06 GMT

hi its change log table.

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: Contains the change history for delta updating from the ODS Object into other data targets, such as ODS Objects or InfoCubes for example

The tables containing active data are constructed according to the ODS object definition, meaning that key fields and data fields are specified when the ODS object is defined. Activation queue and change log are the same in the table’s structure. They have the request ID, package ID and the record number as a key.