Skip to Content
0

DSO to Infocube Delta dataflow - handling characteristic changes

Nov 16, 2016 at 08:53 PM

101

avatar image

Fellow BW-ers,

I am struggling with a situation with a custom development. In this development, transactional data and characteristics associated with a sales document are loaded to a DSO, and then delta loaded to an infocube. The delta process works quite well for key figures - changes to records in the DSO produce negative key figure values and then positive key figure values for each document. But... changes to characteristics produce somewhat more complicated results. I suspect that I should simply avoid using these transactional characteristics, and instead use them as navigational attributes instead.

As a sample:

Document 1234 , status A, value $100

Loaded to the DSO, then to the infocube, which contains:

Document 1234, Status A, value $100

And then, some days later, the document is changed.

Record 1: Document 1234, Status C, Value $300

Loaded to the DSO, then delta loaded to the infocube, which now contains:

Record 1: Document 1234, Status A, Value $100

Record 2: Document 1234, Status A, Value -$100

Record 3: Document 1234, Status C, Value $300

Is there a way I can avoid reading Records 1 and 2, perhaps using a filter in a Bex query, so as to avoid reading the old Status of Document 1234 ?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Jay Reddy Nov 17, 2016 at 05:38 AM
1

Hi,

Cube is additive property, So its working as expected.

For frequent changing data, we need to use Navigational Attribute only.(Already u are using asme)

other workaround is , Do report on top of DSO.

We cant avoid/filter in Bex query to avoid old status.

Regards,

Jay.

Share
10 |10000 characters needed characters left characters exceeded
Charlie Belt Dec 05, 2016 at 09:10 PM
0

Jay- Thanks, that was my assumption as well, but I had to check.

Share
10 |10000 characters needed characters left characters exceeded