How to build BIA index for cubes that get dropped and loaded?
We have scenario, where a cube content is dropped and reloaded on daily basis. How do we need to build BIA index for such cubes?
What I see is if the cube is dropped and reloaded, BIA index may still have older data along with the new data resulting in fact index greater than fact tables.
So by setting delta index for all the tables related to this cube would resolve the issue OR
On a daily basis, we need to rebuild BIA index for this cube?
Will surely assign points...Thanks in advance.