Skip to Content
avatar image
Former Member

Disadvantages of Write-Optimized DSO

Hello experts,

is there any problem (according to the performance or the results) if I want to report on a Write-Optimized DSO in contrast to a Standard DSO?

Thanks in advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Aug 11, 2009 at 07:50 AM

    I dont think there such DSOs are good for reporting since they have only actgive table.. and no activatio of requsts...

    So while reporting it will be generating SIDs which will affect performance...

    Edited by: mansi dandavate on Aug 11, 2009 9:50 AM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 11, 2009 at 07:59 AM

    Here some further explainations:

    I want to load the data from PSA to DSO exactly as it is in the PSA. Therefore I would use a Write-Optimized DSO without a semantic key and without any check for uniqueness. In the further data flow I want to load the data from the Write-Optimized DSO to different cubes. Reporting takes place on the cubes. Only on exceptional circumstances it should be possible to report on the Write-Optimized DSO directly.

    Edited by: Dennis Halboth on Aug 11, 2009 10:00 AM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 11, 2009 at 07:50 AM

    Hello,

    Write optimized DSO's are not good for reporting unless if its a very very smalll amount of data.

    if you are planning to store the data say in several hundred thousands in the DSO then it will have a poor performance and if its in millions then dont use it.

    There is a no option for SID generation in write optimized DSO's and therefore there is no chance for further improvement in the performance.

    Its good for quick staging but not for reporting.

    Regards

    Ajeet

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 11, 2009 at 11:36 AM

    Hi,

    Write Optimised DSOs are not to be used for reporting due to performance reasons. They are used for reducing the loading times (since there is no activation) and are used exclusively as a staging layer. Except in exceptional circumstances, we donot report on them. As per your requirement, if you are just looking for a staging layer and are inclined to reduce the loading time, you can go for write optimised DSOs but remember that during querying, due to SID generation, the performance of the query will drop.

    Hope this helps.

    Regards,

    Saikat

    Add comment
    10|10000 characters needed characters exceeded