Skip to Content
avatar image
Former Member

ABAP program to switch On/Off a cube from BIA

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jul 16, 2009 at 02:01 PM

    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 1157582http://service.sap.com/sap/support/notes/1157582">1157582>)? Are you on a recent revision (see SAP Note 1308131http://service.sap.com/sap/support/notes/1308131">1308131>)?

    Regards,

    Marc

    SAP NetWeaver RIG

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • avatar image
    Former Member
    Jul 23, 2009 at 03:56 AM

    Hello

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

    Thanks

    Ramana

    Add comment
    10|10000 characters needed characters exceeded