Duplicate records message while executing the APD.

[Former Member]

Hi All,

Actually My Data Flow is Info Cube(1)..>Multi provider..> Pre Apd..> Apd..> DSO..>Finally Info Cube(2)..

We developed the Reports on top of the Info Cube (2).

We Loaded the Data for Info Cube (1).

1)when I am Trying to load the data through APD. We got the error message like:Duplicate Records..

And One more thing is when we run the Pre APD BEX Report key figure values are showing..

2)after running the apd we load the data through dso--Info cube(2).

In Info cube key figure values are not comming. it showing Zeros.

Please let me know the Problume.. ASAP...

Thanks&Regards,

Venkat.

[Former Member]

Hi All,

Actually when i run the Report I am getting below Error Message:

Vaiable doesnot exit or incorrectly used..

My Development is : In Transofrmation We mapped 0customer to DSO. In DSO we are Having Key Fields Calday and Customer..

Data Fileds Credit Days.

We mapped Customer-->Customer, Calday-->Calday, Credit days-->Credit days.

Here in Transformation Level we worte a Routiene for Calday( Like SY-DATUM).

After this activity we create a 3 Variables.

1) Customer Variable

2) Calday Variable with Characteristic with Manual Input

3)Credit days Variable Characteristic with Customer Exit .

We are using this 3 variables in CMOD.

Actually I want to find out the Credit days,

Formula : User Input date - Credit days

i.e: Subtract the Credit days from User Input Date.

Please help on this ASAP..

Thanks & Regards,

Venkat.

[Former Member]

Aggregation + Group By ( And check if your keys are unique in direct update dso)

[Former Member]

Dear Suresh, Better include a aggregation block in APD before updating data to DSO. Regards, Arun Bala

http://scn.sap.com/thread/2109009

http://scn.sap.com/thread/2118857

http://scn.sap.com/thread/2055553

http://scn.sap.com/thread/1092406

[Former Member]

Thanx Arun,

Already we maintained Aggregation Block B/W Query & Direct DSO.

Problem is data is not comming for some KFs. but data is comming when i execute the Query.

Data is not populating into DSO.

Please suggest on this..

Thanks&Regards,

venkat.

[snitwipro]

Hi,

  Please use a routine to delete the adjacent duplicate entries from the APD. APD gives the functionality to view the data for all the process types (like query, file, ABAP routine). APD does not allow the concept of a key field which means that all the characters will be treated as key field.

  Please note that APD requires all the key figures need to have the property always show .

Regards

Sourav