Skip to Content
author's profile photo Former Member
Former Member

Delta between DSO and cube in BW on HANA

Hi

We are running BW on HANA (7.30 SP09) and have a question regarding delta loading from a DSO to a cube.

We are running full load to the DSO with overwrite (for a good reason). Now our problem is the following:

- Load 1: Assume we load 100 records (DSO + cube are empty). 100 records are added to the DSO (assuming unique keys) and passed on to the cube

- Load 2: 1 record is added, so we load 101 records to the DSO

-> BW not on HANA: The change log table will keep track that only 1 records has changed/been added since the first load. Therefore only 1 records is passed on to the cube in the delta DTP

-> BW on HANA: All 101 records are passed to the cube in the 2nd load through the delta DTP. However, it does not duplicate the key figures as you normally would expect. Instead it adds the 100 records with 0 in the key figures. Thefore the result is correct and reconsilable with the DSO.

However, this generates an obscene amount of records. I can mend this issue by running a cube compression but I want to check whether this is indeed the intended behaviour?

I have tried to investigate the issue and have established that the change log no longer is a physical table but a database view. However, I have been able fully to appreciate the delta setup from a DSO.

Any help appreciated.

Cheers

/Karsten

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 16, 2013 at 07:36 AM

    Hi Karsten,

    Have you had a look at the SAP Note 1762935. The note explains why this is happening during the DSO Activation and how you can stop that from happening.

    Thanks,

    Anooj

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Karsten,

      Are you sure you don't see the Compress Chge.Log Checkbox? I am on BW 7.31 SP6 (equivalent of BW 7.3 SP9) and I am able to see it:

      As the note mentions as a pre-requisite - Are you on HANA Revision 38? If so, can you also see if you can run the report RSODSO_ENBL_CL_COMPRESSION (SE38) as mentioned in the report?

      Thanks,

      Anooj

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.