Switch off SID generation for DSO

[ravindra_tumuluri]

Hello All,

We currently have one DSO object with automatic SID generation upon activation ON.

This DSO object contains lot of data.

Now we are planning to create one cube on top of this DSO and planning to switch off the auto SID generation. Since no reporting will be done on this DSO ?

Is it possible ? Do we need to delete the data in DSO before switching off the auto SID checkbox ?

Regards,

Ravi

[Former Member · Accepted solution]

Hi Ravi,

You can use the option ''SID generation on activation option'' when ever reports are required to creat on the ODS. Because if you this option report perfomance will be improved.

As you not using any Queries on this ODS need not check this option.

While fetching the data from the ODS to Cube you need not delete the data from ODS.

Time required to transport the ODS to Production is independant of the Data volume.

Thanks