BW Remodeling

[ashok_kumar24]

Hi,

Need clarification on following.

We have done re-modelling activities on some Info cubes.

Is it necessary to adjust the BI Accelator Indexes after remodelling an Infocube.

Should the Aggregates be rebuilt after remodelling.

Thanks,

Ashok

[Former Member · Accepted solution]

BWA indexes has to be rebuilt.

Aggregates maintenance depends on your remodelling rules.

Thanks,

Krishnan

[ashok_kumar24]

Valuable Inputs received. Thanks to all the forum members and SDN.

[Former Member]

Hi Ashok,

You will have to rebuild the BWA indexes because as you have added new field in the cube. And in case of aggregates if you are going to use that field in aggregates then only you need to rebuild the aggregates, otherwise as I know existing aggregates will work fine.

Regards,

Durgesh.

[ashok_kumar24]

Thanks All for your valuable ideas. Points assigned.

Thanks again.

[former_member182470]

Hi,

You have to refill the Aggregates by dropping existing data in Aggregates.

and your BIA index also needs to be done again freshly.......

Regards,

Suman

[Former Member]

Hi,

Indexes has to be rebuilt.

Please go to the below thread

[http://wiki.sdn.sap.com/wiki/display/BI/Remodeling]

[;

Thanks,