Creating Secondary Index on DSO

[pavneet_rana]

Hi to all,

I need to create a secondary index on DSO in SAP BI.

Does after transporting the object from Dev/Quatily to Porduction, do i need to re-initialize the delta of DSO, also do i need to drop the data of DSO and load it again in Production.

please can nay one tell me what step i need to take care after creating the secondary index on DSO and moving to porduction.

Regards

Pavneet Rana

[RamanKorrapati · Accepted solution]

Hi Rana,

loading performance wise always need to drop index before loading to target and after the completion of load need to rebuild index(reporting purpose).

Regards

[pavneet_rana · Accepted solution]

Thanks for reply,

We have alreay one seconday index on DSO , just want to create another seconday index on DSO. This DSO transfer data to CUBE.

As i have created another secondary index on DSO in dev system and now if i transport that to production, what i need to do for DSO in porduction system.

Mean do i need to re-initalized the DSO delta load, or need to drop data from CUBE and DSO and need to do full load and then delta load to DSO and CUBE.

regards

Pavneet Rana

[RamanKorrapati · Accepted solution]

hi rana,

you need create in Prod also,

below link will be informative

http://scn.sap.com/thread/1521719

Regards

[Former Member · Accepted solution]

Hi Pavneet,

You don't need to delete data for transporting this DSO with secondary index.

The existing data is just fine.

But, the subsequent load will consume additional time. But, this is the price you have to pay for creating an additional index to the DSO.

Br,

H

[pavneet_rana · Accepted solution]

Thanks for reply,

So it mean after creating secondary index on DSO, and importing DSO to production, we dont need to do reinitialization of Delta load of DSO, dont need to delete and load again the data from DSO.

So it mean when i will import change to Production, we dont  required to do any chages to DSO.

Regards

Pavneet Rana

[Former Member · Accepted solution]

Hi Pavneet,

Yes, there is no need to do reload of data.

While transporting your DSO with secondary index, in the target system, it just creates a new index function at the data base level, which will have no impact on the existing data.

Br,

H