Archived discussions are read-only. Learn more about SAP Q&A

Delete and recreate BWA index of a cube in process chain

Hello Guru's

Got the following issue. Due to our model we have a selective deletion on one of our cubes every weekend. This cube is also loaded into the BWA.

For maintenance purposes we need a process chain which, after the selective deletion:

1. Deletes the active index on the BWA

2. Recreates the Index

3. Fill the index and activate it

I saw the following ABAP programs which might be applicable (also mentioned in other posts):

RSDDTREX_INDEX_DELETE Delete index

RSDDTREX_AGGREGATES_FILL Fill the BIA index

But for recreating the index i'm lost:

RSDDTREX_ALL_INDEX_REBUILD - Deletes, Rebuilds and Then Fills All Active BIA Indexes in System

Is really too much ...

RSDDTREX_BIA_ACTIVATE_FILL Activate and Fill BIA Indexes for Multiple InfoCubes

gives short dumps ...

Has anyone an idea of been struggling with the same issue?

Regards,

René

replied

Hi,

Use the programs in the sequence below in your process chain:

Step 1: RSDDTREX_INDEX_DELETE ( to delete the BWA indexes of that cube by specifying the variant as the cube name)

Step 2: Use your program for selective deletion.

Step 3: Use the process type " Initial Activation and Filling of BWA indexes" for creating and filling BWA indexes of this cube by specifying the variant as the cube name.

We have been using this chain since quite some time now and it is a very robust method.

Thanks,

Vikram

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question