cancel
Showing results for 
Search instead for 
Did you mean: 

Is DSO required while loading data ti FI CUBE?

Former Member
0 Kudos

Hi SCN,

    While loading data to 0FIGL_C10 why we need to load the data into DSO (0FIGL_O10) ? Cant we load data with out DSO(0FIGL_O10)?

Please tell me the Significance of DSO in FI DATA LOADING?

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Rajesh,

    Let us assume a DATA SOURCE for sales with delta AIED

  In DSO:

      EMP Id        SALES QUAN         SALES AMT

      001                  2                             20

      002                  4                             40

  In CUBE:

      EMP Id        SALES QUAN         SALES AMT

      001                  2                             20

      002                  4                             40

if  sales order is changed and quantity is updated to 4 for EMP ID(001)

  EMP Id        SALES QUAN         SALES AMT

      001                  4                            50

DATA in DSO becomes

      EMP Id        SALES QUAN         SALES AMT

      001                  4                             50

      002                  4                             40

DATA IN CUBE BECOMES

      EMP Id        SALES QUAN         SALES AMT

      001                  6                             70

      002                  4                             40

But DATA in cube should be 50 for SALES AMT and QUANTITY should be 4.

Former Member
0 Kudos

Hi Chandra,

Data in  Infocube  will be  from the change log of the DSO.  Please simulate the  loading from DSO  and to Infocube  by checking in change log  table after  loading the request one by  one.

When you do the delta from DSO to Infocube ,  you will have the  below records loaded to Infocube.

EMP Id        SALES QUAN         SALES AMT

      001                  2                             20

     001                     -2                        -20

     001                    4                             50

      002                  4                             40

Regards,

Rajesh

Former Member
0 Kudos

Chandra,

I agree with Rajesh.

You should understand how AIED delta image works. If you decide to go with delta, you should have DSO, with overwrite mode for all key figures, to get correct values in cube.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a080ea68-fba2-2e10-8cb7-d42d5bfba...

Regards,

Raghu

Former Member
0 Kudos

Hi Chandra,

0FI_GL_10 supports the  delta image : AIED. ( After-Images with Deletion Flag Via Extractor (FI-GL/AP/AR)

All AIED images need to have DSO and then  should be loaded to Infocube as datasource provides only  after images and not before images.

You can see in roosource and rodeltam  for more information on datasource.

Regards,

Rajesh

RamanKorrapati
Active Contributor
0 Kudos

Hi,

With or without dso is depend on business needs.

DSO - holds granular data

Cube - holds aggregated data.

if your data source won't supports delta then in such cases we introduce dso between cube and data source. Rather than pulling full load daily needs, from DSO to cube we can load delta loads by using dtp concepts.

By mistake we lost/deleted data from cube, rather than loading from source, we can reload those records from dso(if its have history data.

Thanks