Skip to Content
author's profile photo Former Member
Former Member

Regarding DSO

Hello,

I'm loading data using Lo-extraction(Delta load) as follows

PSA >DSO ->INFOCUBE

My doubt is when we create DSO which data type will suite above scenario?

like "Standard" or "Write Optimized" or "Direct update"

I'm not generating a report on DSO so performance is not an issue , I want to make sure Delta load should work like when we change the data in r/3 or delete the record in r/3 those records should calculate correctly in BI.

Advance thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 11, 2008 at 08:08 PM

    Hi Roshan,

    All the LO data sources can be loaded into a standard DSO with overwrite option as update mode.

    All you have to do is to chose the keys properly.

    This will be help to manage delta in best way and load to subsequent cubes as well.

    You can go through help.sap.com to know more about write and optmized but since you are mot going to anything other then staging the data into DSO therefore use standard DSO's.

    http://help.sap.com/saphelp_nw70/helpdata/EN/f9/45503c242b4a67e10000000a114084/content.htm

    Thanks

    AJeet

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 11, 2008 at 09:25 PM

    So PSA to DSO Delta load

    DSO to INFOCUBE delta load

    We don't delete the requests in PSA and Infocube right, every day we will load Delta from R/3 to psa >dso >infocube.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 11, 2008 at 08:05 PM

    Standard DSO will be most obvious and correct option. It will take care of all delta changes with AFTER and BEFORE images. Go ahead with Standard DSO.

    Abhijit

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 11, 2008 at 08:33 PM

    Also, If we select Standard DSO what are the fields we need to map in transformation inorder to work Delta Like ROCANCEL ...ect

    When we are loading data from DSO to INFOCUBE , First we need to activate the data then load into Infocube?

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 11, 2008 at 08:58 PM

    I'm extracting 2LIS_11_VAITM data source using LO-Extraction(VBAP-Sales Detail Record)

    R/3 side 2LIS_11_VAITM scheduled as "Queued Delta"

    While loading into DSO, keys as Sales Document no and Item no this will be unique record in DSO.

    When we map ROCANCEL to RECORDMODE in ODS transformation that will take care of delta records

    such as sales document changes,deletes,adds?

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 11, 2008 at 09:06 PM

    so after loading DSO then we will activate data in DSO and load into Infocube?

    Thanks

    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.