cancel
Showing results for 
Search instead for 
Did you mean: 

Reindexing on cube after selective deletion

Former Member
0 Kudos

Hi ,

Suppose i am doing selective deletion on a cube which is on BIA , then after roll up on that cube will data be deleted from BIA also and reindexing is done or we need to rebuild index .

Accepted Solutions (1)

Accepted Solutions (1)

former_member186445
Active Contributor
0 Kudos

you need to rebuild the indexes

M.

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Neetika,

When you do the selective deletion from a cube which is BWA indexed, you will find a check box right on the bottom of selective deletion screen to rebuild the BWA indexes. In most of the cases deletion on BWA indexes corresponding to the data selectively deleted is automatically taken care of by this check box but for instances like where you do the selective deletion request by request ( For e.g. Delete Overlapping request) it just sets a marker on the BWA index to mark it for deletion so that this data is not accessed by any queries.In such cases you need to rebuild the indexes.

Now for selective deletion only no roll up is required to delete BWA indexes explicitly , Indexes get deleted during the course of selective deletion itself if the check box mentioned above is checked.

If this option is not checked ,I would suggest you to check this and if it is not possible in your scenario you will have to rebuild the indexes.

-Vikram

Former Member
0 Kudos

The easiest thing is naturally do not do selective deletions - you will run into problems when you upgrade to BWA 7.3 and non persistant infoproviders (ie with the BWA and Infoproviders being fed by the data manager and not the current way round of Infoprovider feeding BWA)

I normally insist developers do a tranasformation back on the cube and mutliply the key figures by minus 1 - this works in all circumstances bar key figure dates (used for min and max).

This will stop the reindexing - yes the infoprovider on disk will have zero elimination and BWA will have the extra records - but when you do your periodic reindexing the size of the BWA indexes will fall

former_member205352
Active Contributor
0 Kudos

>

> Hi ,

> Suppose i am doing selective deletion on a cube which is on BIA , then after roll up on that cube will data be deleted from BIA also and reindexing is done or we need to rebuild index .

When a selective delete is done in the cube it should automatically deletes BWA index for it, making both cube and BWA index in sync.

Pravender
Active Contributor
0 Kudos

You have to rebulit the indexes in manage screen.