Can i go with single dso?

[former_member217770]

i have to get data from Extractor 0fi_gl_14  for Keyfigures A,B,C

and from Extractor   0FI_TX_4   for  keyfiguresE,F,H

I have common info objects as Account document no and G/L aCCOUNTS in both extractors .

can i simply connect both datasources to one DSO and Then to cube and creat Bex Report?

or i need to creat separte dso for each?

Regards,

Naiduz

[Former Member]

Yes, you might not push data from two different DSOs to cube otherwise you will have multiple rows due to data being pushed from two sources whereas you would like to have one row for each accounting document.

As said above, get your data in a standard DSO (with some keys like accounting doc.), push data from two transformations (DSO 1 and DSO2) to a final DSO.

Thanks & Regards,

Mahen

[fcorodriguezl]

Hi Naiduz,

In datawarehouse, exist three layers.

1) persistance area with your data equal to source.

2) treatment area, with your calculations and consolidate data.

3) presentation area, with your data consolidate, aggregations, ready for reports.

So, answering your question, need a flow separated.

                  layer1        layer2      layer3

source1--> ods1 --> 
                                    ods3 -->  cube

source2--> ods2 -->

Regards.

[former_member194898]

Hi,

You can built an infoset on DSO's built on mentioned datasources.

1. add to the infoset both DSO's

2. create link between document no and year.

3. built a query on this infoset and use KF's

There's a risk however that it will not work very fast.

It depends on amount of data in those DSO's.

Regards, Leszek

[former_member197660]

Hello Naiduz

I would too echo the suggestion from Gajesh to have separate flows due to following two reasons:

1) Data correction/reload becomes easier and less risky during problematic times being individual flows.

2) Consolidating the data in single DSO could lead to high volume of records eventually leading to long runtime of data load and DSO activation.

Ashish

[former_member331765]

Hello Naiduz,

As Gajesh Suggest for go with separate DSO, why means.. Please read the below link for more info

"Financial Accounting: Procedure for Line Item Extraction - InfoSources in Accounts Receivable and Ac..."

Sreenivas

[former_member186399]

Hello Naiduz

You can go with either one DSO or separate flow for both

I will recommend you to go with separate flows based on the growth of DSO over period of time.

You can go with one DSO if your Key consists of Accounting document and GL accounts.

( If you are using line item in the key please check the combination from both the sources).

Regards

Gajesh