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

Write Optimized DSO with Routine...

Hi Experts,

Good Day!

I am planning to use write optimized DSO in enhance/minimize data loading time. The data store in the said DSO is only for data checking before I will upload to Cube (Reporting Layer). The data in the said DSO will deleted after the availlabity of data in Repoprting Layer (Cube). But before the data loading in the said DSO, I have to considered some routines.

My Question is: Is it possible to use Write Optimized DSO with Field Routines, Start and End Routine. It will be a helpful stategy or will make worst for the my expected result?

Many thanks.

Regards,

-Whel

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    Posted on Oct 14, 2015 at 09:02 AM

    Hi,

    Yes you can use routines in WDSO..

    Can you post a sample scenario like sample routines you wanted to implement? Usually WDSO is used to store all the data in your PSA without doing any modification..Just a plain copy of your PSA so you can delete your PSA requests afterwards..

    Regards,

    Loed

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 14, 2015 at 09:30 AM

    The Write optimized DSO as other mentioned is used for staging Huge data, as it has only one table (Active Table) . In case if you want to add Start Routine, End Routine it will work as expected.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 14, 2015 at 09:38 AM

    Hello Roel,

    i guess, you want to delete records from said dso based on LOOKUP.

    btw..yes u can use routine in WDSO.

    my suggestion would be if u want to delete some records based on any condition in routine then go for WDSO in start routine , and if you want to do any complex calculation then go for dso routine.

    because suppose u have 10 million records in WDSO and then while going to above layer it becomes 8 million, then it is better to execute code for 8 million instead of 10 million.

    <<but again based on scenario we decide where to write code>>

    Regards,

    Hitesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 14, 2015 at 09:08 AM

    Hi Whel,

    You write routines ( Start, End and filed routine ) while using write optimised DSO.

    Thanks,

    Shakthi Raj Natarajan

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 14, 2015 at 09:15 AM

    Hi Roel,

    Generally WDSO will used in Projects for stageing perpose,

    if you selected SID generation in DSO Settings, its like as Standard DSO.

    Thanks,

    Ram.

    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.