Pre-fill the OLAP cache for a query on Data change event of infoprovider

[Former Member]

Hi Gurus,

I have to pre-fill the OLAP cache for a query,which has bad performance.

I read a doc 'Periodic Jobs and Tasks in SAP BW'

which suggested sum steps to do this

i hav created the setting for Bex broadcasting for scheduling job Execution with data change in info provider

thereafter doc says "an event has to be raised in the process chain which loads the data to this InfoProvider.When the process chain executes the process u201CTrigger Event Data Change (for Broadcaster)u201D, an event is raised to inform the Broadcaster that the query can be filled in the OLAP cache."

how can this b done please provide with sum proper steps

Answers are always appreciated.

Thanks.

[Former Member · Accepted solution]

Hi

U need to create a process chain or use the existing process chain which you are using to load your current solution, just add event change process type in the process chian and inside it add the info provider which are going to be affected.

Once you are done with this go to the broadcaster and create new setting for that query...you will see the option for event data chainge in infoprovider just choose that and create the settings.

hope it helps

[Former Member]

please update