Skip to Content

Can i go with single dso?

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Posted on Dec 04, 2014 at 12:07 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 04, 2014 at 12:18 PM

    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 Accounts Payable Accou…"

    Sreenivas

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 05, 2014 at 02:41 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 05, 2014 at 09:11 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2014 at 09:49 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 16, 2014 at 10:14 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.