Problem with Delta Load in DSO

[bl_vijaykumar]

HI ALL,

      i have a generic data source with cal day as delta relevant field.

if i m taking full load first for example today

   i m getting all data.... from PSA--->DSO--->infocube.

key fileds(c1,e1,n1,date,value) psa level

key fileds(c1,e1,n1,date) DSO LEVEL

key fileds(c1,e1,n1,date) CUbe level

  but from psa-->DSO level records are like below

c1          e1          n1     value                date(psa table)

1               2          1          300              14-jul

1               5          3          600               14-7

1                2          1          700               14-7

c1          e1          n1     value (DSO)

1               2          1          700

1               5          3          600

here in DSO level over writing is taking place.... as a solution i have added one info obj (SNO), this will generate serial number so record can be identified uniquely

sno          c1          e1          n1     value                date(psa table)

  1           1               2          1          300              14-jul

   2           1               5          3          600               14-7

    3           1                2          1          700               14-7

i have taken this data around 3 30 pm

next day(15-jul) when i triggered delta i got new set of records for 14 -jul

i have got data for 14-jul

in those records few are of same

because of SNO they are not over writing.....

if they over write i ll get 1 rec out of 10 rec....

what would be solution for this....

thanks and regards

vijay

[bl_vijaykumar · Accepted solution]

Hi ALL,

   solution is like this when ever you are pulling data from different tables please find key fields of those particular table in your final view. so that you may not need to generate a unique number by yourself.....

By adding those key fields of different tables in our DSO would solve the problem

Thanks

vijay

[bl_vijaykumar]

Hi Phani,

  i checked the document they are saying like overwirte and summation option for key figure i have searching all and have not find those options....

  can u explain me in step by step process...

  this will help me alot....

thanks and regards

vijay

[KodandaPani_KV]

Hi,

Add the SNO into Key fields of the DSO.

please read the document.

it will help.

Thanks,

Phani.

[former_member183113]

add SNO in key fields of DSO...hav u?

[Former Member]

Hi,

Have you added SNO in KEY FIELDS ,if you have added in DATA FIELDS plz try to add in KEY.

next day(15-jul) when i triggered delta i got new set of records for 14 -jul

i have got data for 14-jul?

Can you provide sum example with data .....

Thanks,

Rohith

[bl_vijaykumar]

Hi rohit,

  i added sno as key field in dso in first request i got all data records.....

when it come to 2 nd req

i kept delta relevant field a calday

example inmy 1st req i hv 14 jul data

if i go  for delta again on 15 jul i ll get prev delta rec of 14 jul if any changes in record or new rec will come as 2nd req

here problem is

1           2                   1       14 jul            600

with this it should update  but becauz of sno here it is adding 1 more record and same is added in cube level so wrong data is updating....

thanks

vijay