Skip to Content
0

Reverse values are showing in Cube for some materials

May 02, 2017 at 08:43 AM

36

avatar image
Former Member

Hi All,

Data is loading from DSO to Cube.

In Cube, I can see values like below which is having issue.

Material sales document Date Quantity 1234 56789 02.05.2017 1 1234 56789 02.05.2017 -1 1234 56789 02.05.2017 1

In DSO, showing right values.

Material sales document Date Quantity 1234 56789 02.05.2017 1

Issue:

Data is loading from DSO to cube on daily basis.

For some Material or sales document showing values like in cube (reverse values) which should one value as in DSO having one record

But if we reload, then it’s fetching one record from DSO as it’s.

Issue is with only particular materials which they did reverse postings.

Please let me know the cause of issue.

Note: Cube is having Master data reference which having navigational attribute and its checked on at cube level.

values.png (8.7 kB)
10 |10000 characters needed characters left characters exceeded
Former Member

Values in Cube and DSO

values.png

values.png (8.7 kB)
0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Frédéric Cincet May 02, 2017 at 12:30 PM
0

Hi Giridharan,

This is a normal behavior, you have to aggregate the key figures of your cube to have its final content.

Here, the 3 lines in the cube only means that the DSO has been modified one time for this sales document item. The aggregation will be automatically done at the query level so this should be transparent to the user.

Regards,

Frederic

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Correct!

0