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

Do I need to reload data in DSO after removing SID generation?

HI

Do I need to reload data after removing SID generation from DSO ?

Add a comment
10|10000 characters needed characters exceeded

Related questions

8 Answers

  • Posted on Nov 23, 2013 at 05:35 PM

    There is no need to drop or reload the data ...you are just changing the setting of DSO.

    Transformations and DTP will not be affected with this action.

    Once the changes are done collect the DSO into TR and transport the same till Production ...

    FYI:

    If you are on BW 7.3x you have 3 options ...

    Create SID's

    1) During reporting - if you select this option in future if you build any reports on top of this DSO at the time of reporting SIDs will be generated

    2) During Activation - this setting is what u have for Standard DSO

    3) Never Create SIDs - this will never create SIDs.

    Better way to learn BW is give a try in Sand box system or in TBD to get clear picture how it behaves...if any are not confident create a copy of a DSO and load the data and change the settings after loading and activation of Data is done.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 22, 2013 at 07:53 PM

    Hi,

    You do not need to reload the data..After un-marking that check box only thing is SID will not be generated during data load but in case if you are reporting on that DSO then SID will be generated while running the reports so it indeed hamper the reporting performance.

    Hope that helps.

    Regards,

    AL

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 22, 2013 at 09:08 PM

    Hi

    Definitely not required. If you have no reporting on the DSO it's even better if you switch it of for load performance reasons.

    hope that clarifies

    Martin

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 23, 2013 at 05:49 AM

    Assuming as DSO just for staging and no reporting on dso.

    in that case better to remove sid settings.

    No, Not required. Once you remove settings of SID Activation, next load on wards there is no sid of your info objects(which are part of dso) and improves your loading performance.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 25, 2013 at 05:32 AM

    No not required...

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 03, 2014 at 05:22 PM

    Please close the thread if your issue was resolved.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 04, 2014 at 01:03 PM

    Hi Pawan,

    If there is no reporting exists on respective DSO then you can remove SID generation setting.

    As it impact Query running performance.

    It will not impact next coming delta data. You don't need to reload the data.

    Thanks & Regards,

    Vipin

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 04, 2014 at 02:31 PM

    Hi Pawan,

    fallow the prasanth konduru,Raman, AL.

    No need to Reload the data after removing the SID generation, if you run the report on top up SDSO

    select the SID generation, other wise no need.

    if you create cube and multi provider on top up SDSO then run the report on multiprovider.

    Thanks,

    Phani.

    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.