Skip to Content

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

How to build BIA index for cubes that get dropped and loaded?

Hello,

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.

Sundar

Former Member
replied

Hi Sundar,

if you drop the InfoCube the BIA index should be dropped automatically.

This means you have to re-build the InfoCube BIA index.

I do not believe that delta works.

Cheers Michael

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