cancel
Showing results for 
Search instead for 
Did you mean: 

IMDSO Mechnisam ( Compare to Standard DSO in BW )

Former Member
0 Kudos

Hi All,

Could You please explain how IMDSO is work in SAP HANA.

Because standard DSO in BW will move the data from Activation Queue to Active Table using RECORDMODE and Key fields of DSO.

But in IMDSO we are not Maintain the Keyfields.T hen How activation is going where there is no change in Key fields in Transaction Data.

Regards

Nagender

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Nagendar,

When we convert DSO to HANA as IMDSO, we will have the following changes

1) Activation queue and Active tables are created in SAP HANA.

2) Instead of change log table system creates calculation view for this. (so change log table is not physical one in HANA, it's an view)

Detla mangement happens with the help of history tables in HANA Tables.

you can have a look at the links provided by mahesh.

Regards,

Venkat

former_member184768
Active Contributor
0 Kudos

One update:

With SP06 (or even SP05 I am not completely sure), it is advisable NOT to convert the DSO to In-Memory optimized DSO and keep it as it is.

This way the Change log table would a PHYSICAL table. It has been observed that the physical change log provides better performance when the DSO is also a source DSO to another target.

Hence depending upon your architecture, you can choose to "convert" or "keep it as it is".

Regards,

Ravi

kpsauer
Product and Topic Expert
Product and Topic Expert
0 Kudos

Ravi,

this is correct. This change is coming with BW 7.30 SP10  (7.31 SP9 resp.) and HANA revision 57. You could also apply note 1849497 for BW SP8 or SP9.

More details can be found:

Please read the notes and documents above before starting your conversion or re-conversion of DSOs.

Best regards

KP

Answers (1)

Answers (1)

Former Member
0 Kudos