on 06-10-2010 1:34 PM
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 .
you need to rebuild the indexes
M.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
>
> 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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You have to rebulit the indexes in manage screen.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.