cancel
Showing results for 
Search instead for 
Did you mean: 

transactional ODS

Former Member
0 Kudos

Hi,

I have few doubts in BW,it will be appreciable if u reply

What is the diffrence between transactional and standard ODS.Tell me the technical diffrences.

I know that no update rules will be created for transactional ODS.

Correct me if i am wrong.

Regards.

Sairam

Accepted Solutions (1)

Accepted Solutions (1)

former_member619464
Active Contributor
0 Kudos

Hi Sairam,

A transactional ODS object differs from a standard ODS object in the way it prepares data. In a standard ODS object, data is stored in different versions (active, delta, modified), whereas a transactional ODS object contains the data in a single version. Therefore, data is stored in precisely the same form in which it was written to the transactional ODS object by the application. Transactional ODS objects allow data to be available quickly. The data from this kind of ODS object is accessed transactionally, that is, data is written to the ODS object (possibly by several users at the same time) and reread as soon as possible.

Since transactional ODS objects cannot be filled with BW data using staging (data is not supplied from the DataSources), they are not displayed in the Scheduler or in the Monitor. Transactional ODS objects can therefore not be updated in the same way as standard ODS objects.

If you switch a standard ODS object that already has update rules available to a transactional one, the update rules are set as inactive and are no longer processable.

hope it helps...let me know

Regards,

RV.

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

1>>Transactional ODS: A transactional ODS object differs from a standard ODS object in the way it prepares data

In a standard ODS object, data is stored in different versions (active, delta, modified),whereas transactional ODS object contains the data in a single version.

2>>Data is stored in precisely the same form in which it was written to the transactional ODS object by the application. In BW, you can use a transaction ODS object as a data target for an analysis process.

In a Standard ODS Object, it wont be stored precisely.

3>>The transactional ODS object is also required by diverse applications, such as SAP Strategic Enterprise Management (SEM) for example, as well as other external applications.

4>>Transactional ODS objects allow data to be available quickly but not same in Standard ODS.

5>>It offers no replacement for the standard ODS object. Instead, an additional function displays those that can be used for special applications.

6>>you can change the ODS object type under Settings via the context menu. The default setting is Standard The switching of ODS object types between standard and transactional is only possible if no data exists yet in the ODS object.

Hope It solves...... !!!

Thanks

VArun CN

Former Member
0 Kudos

Hi

A transactional ODS object differs from a standard ODS object in the way it prepares data. In a standard ODS object, data is stored in different versions (active, delta, modified), whereas a transactional ODS object contains the data in a single version. Therefore, data is stored in precisely the same form in which it was written to the transactional ODS object by the application. In BW, you can use a transaction ODS object as a data target for an analysis process.

http://help.sap.com/saphelp_nw04/helpdata/en/c0/99663b3e916a78e10000000a11402f/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/c7/dc833b2ab3ae0ee10000000a11402f/frameset.htm

Former Member
0 Kudos

hi sai,

<b>this help doc beautifully explains the difference</b>

http://help.sap.com/saphelp_nw04/helpdata/en/c0/99663b3e916a78e10000000a11402f/frameset.htm

hope it helps

shameem