Skip to Content
Author's profile photo Former Member

Standard DSO behavior with all key fields

1.0  Issue description

After migrating to BW 7.4 on HANA,Standard DSO behavior is changed compared to previous version. Change log tableis getting updated with before and after images even if there is no change in active table record. This is happening only for those standard DSOs which hasall fields as key (without data field).

In the below screenshot we can observe 2 records with different record mode even though there is no change in keyfields. Also these already exist in active table.

image 1.png

2.0  Solution for the issue

         Step1: Go to transaction RSODSO_SETTINGS, below screen will be displayed and filter for DSO which needs to be changed.

image 2.png

Step 2:  double click on DSO

image 3.png

Step 3: Disable optimizations for SAP HANA  using Edit option.

image 4.png

image 5.png

After this setting DSO will behave same as in BW 7.01

Assigned tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo AnilKumar Suryavansi
      AnilKumar Suryavansi

      hi Hani,

      Does it mean that the DSO is not a HANA optimized DSO and is there anything chaning (other than creating 2 records in change log) when you disable this option?

      Regards,

      Anil

      Author's profile photo Mallikarjuna Gande
      Mallikarjuna Gande

      Hi, Can you please confirm the in which 'SP'you are into ?

      -

      regards,

      Mallikarjuna