strange behavior of the import request from BW4HANA to SAC

[bouirik]

Hi community,

I have a query in BW4hana that is based on stock cubes where there are non-cumulative measures.

The weird behavior of the query is that when I import one day of data to SAC the data is correct but when I import month by month I have duplicate data.

When data is imported day by day

When data is imported month by month

And sometimes the same request import correct data even if i choose to import it month by month.

If anyone has ever encountered this strange behavior can help me find the cause !

kind regards,

[MKreitlein]

Hello achraf,

if you import on "days" I assume your model time setting is the granularity "day"?

Have you tried to change your model to "month" and import the data? What is the outcome?

In addition, I would recommend to check your key figure settings in the model.

For stock key figures you should use the exception aggregation "last" to display the last value and not the total sum of all days in the month.

These are the first 2 ideas I have...

BR, Martin