Process chain Error.

[Former Member]

Hi gurus,

i am trying to create a simple process chain to load data into an ODS

i have inserted the start process and trying to include the Delete index but the problem is i am not getting my ODS instead only infocubes are displaying in that delete index process variant.

So i tried to create a process chain for infocube i was able to create it sucessfully on my infocube but i am unable to do it on my ODS

why so.

thanks and regards

Neel

[Former Member · Accepted solution]

Hi:

There is no SAP-delivered process type for deleting an index on an ODS, this only exists for a cube.

The process of adding data to an ODS is differnt than a cube, as the ODS contents have to be evaluated for possible update (after image handling). For this evaluation part of the operation, the index on your ODS can be useful for lookup performance.

It is not typical to delete indexes on an ODS during load operations. If you feel it is important nonetheless, you could create an ABAP program to perform that SQL command to drop the index and then rebuild it, then include that ABAP in the process chain.

Thanks for any points you choose to assign

Ron Silberstein

SAP

[Former Member · Accepted solution]

Hi Ron,

thanks a lot for your quick response..so one more doubt

so you mean to say that we don't have any process to delete the index of an ODS like the way we do it for CUBE..

can you give me some code sample or guide lines how to delete the index on ODS...i will be greatfull

thanks and regards

Neel