Delete and recreate BWA index of a cube in process chain
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?
Vikram Srivastava replied
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.