Question Re: How to delete DSO Index in Technology Q&A

How to delete DSO Index

Former Member — Wed, 22 Dec 2010 23:04:56 GMT

Dear Experts,

We have been extracting Payroll data in to a PAyroll DSO for the past 4 yrs. The DSO is growing in size and a Index table for this DSO seems to be having more data than the DSO itself.

Could you please tell me as to how to delete the Index data which will free up some table space in the BW Server.

We are moving the data from this DSO to a Cube and I am able to delete the Index for this cube in the process chain.

Thanks,

Sai

Re: How to delete DSO Index

Former Member — Wed, 22 Dec 2010 23:42:27 GMT

Hi Sainath,

You can include these 2 function modules in a program, and include the program in the process chain in order to create or delete the index.

RSSM_PROCESS_ODS_DROP_INDEXES

RSSM_PROCESS_ODS_CREA_INDEXES

Regards, Federico

Re: How to delete DSO Index

Former Member — Thu, 23 Dec 2010 07:29:12 GMT

Check the below thread

Re: How to delete DSO Index

Former Member — Thu, 23 Dec 2010 15:49:05 GMT

Thanks Federico.

That was helpfull.

Regards,

Sai