Skip to Content
0

Is DSO essential for controlling duplicate records?

Apr 14, 2017 at 04:14 AM

111

avatar image
Former Member

Hi

Is DSO essential for controlling duplicate records??

If not then what is the other options?

If yes then why SAP not offering DSOs for multiple Data Sources?

What are the std. DSO for DS 0FI_GL_11 & 0CO_OM_CCA_9? Because I can't find any DSO in BI-Content and I am facing duplicate records issue in InfoCube.

Thanks

Imran Shafiq

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

2 Answers

avatar image
Former Member Apr 14, 2017 at 11:04 AM
0

Hello;

DSOs are nice to have but there are not mandatory.

In the recent methodologies LSA and LSA++ they are a plus.

But there are some flows (for example DS 0CO_OM_CCA_1 were delta is not possible and its usually loaded after financial closure) where DSO will not be very friendly.

Hope it helps;

Regards

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi

If DSO is not essential for controlling duplicate records in cube then what is the other options?

I have a duplicate records in 0CO_OM_CCA_9 delta info package which already loaded in full info package.

Thanks

0
Former Member

Hi;

For that DS use DSO 0CCA_O09 as reference:

https://help.sap.com/saphelp_nw70/helpdata/en/c7/038653aa9a6159e10000000a174cb4/content.htm

Please align the key fields and delta should work fine (in infopackage and DTP).

Hope it helps;

Regards

0
avatar image
Former Member Apr 17, 2017 at 06:20 PM
0

Hi Imran ,

Can i know the ECC and BW version ?

Can I know why you are using 0FI_GL_11 ?

I can help you with all your queries .

Regards,

Rajib

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

Hi Rajib

We are using ECC 6 Ehp4 and BW 7.0 BI-Content 7.07.

We are using 0FI_GL_11 for summarize GL balances without DSO since 2015 now in 2017 we are facing 2 issues:

1) Duplicate records in delta load

2) Phantom records in delta load

How can we avoid to load these types of records in Delta?

Thanks

0