ABAP program to switch On/Off a cube from BIA

[Former Member]

We have some repost jobs on a transactional cube that fail because of BIA.(insufficient memory)

these jobs run fine when BIA is turned off for this cube. And once they have finished successfully we turn BIA back on. But turning on/off is a manual process.

As far as I know, there is no ABAP available to do this.

Has anyone else come across where you need to automate turning on/off BIA for a cube?

any workarounds??

I know i can create a new user id to run these jobs and then switch off BIA for this user id.

But this is not an option given the security policies in our organization.

[former_member93896 · Accepted solution]

Hi Saurabh,

it should not be necessary to switch off BIA for planning functions unless you read very high data volumes.

Did you turn on package-wise read (see SAP Note <a href="http://service.sap.com/sap/support/notes/1157582">1157582</a>)? Are you on a recent revision (see SAP Note <a href="http://service.sap.com/sap/support/notes/1308131">1308131</a>)?

Regards,

Marc

SAP NetWeaver RIG

[Former Member · Accepted solution]

Hi Marc,

Yes, we are reading high volumes of data. We have a decent sized transactional cube (~21MM).

We are on Rev 48 and we are using package wise reading.

Thanks,

Saurabh Bansal

[Former Member]

Hello

I would suggest using process chains. They will take care of switching on and off of BIA indexes

Thanks

Ramana