Skip to Content
avatar image
Former Member

Adding Columns to large volume DSO & Cubes?

Hi,

We are on SAP-BW version 7.01 SP 13. We need to add new characteristics and key figures to large volume cubes and DSOs. Just to give you an idea one of the DSO has >1 billion rows and not partition.

There is no need to populate the new column for historical data.

What we are concerned with is if there is any risk in just adding the columns.

Please do not provide how to add columns. I just want to know the risks if any and what would be an alternate solution if risks are involved.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Mar 20, 2017 at 10:23 AM

    if you just need to add columns without the historical data, there is no risk. You can add these columns without the need of deleting data. But you better be sure because removing these objects afterwards will no be that easy.

    the only thing that will take time is the import of the transport, more particularly the activation of the objects.

    but can easily be tested on a test or validation system.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 27, 2017 at 06:50 AM

    Hi Mahnoor,

    As you stated in your question that you don't need historical data for newly added fields, then there is no risk of adding new fields.

    You can test in dev server first .

    Regards

    Vikas Saini

    Add comment
    10|10000 characters needed characters exceeded