Skip to Content

Filling OLAP Cache using Broadcasting for Performance Improvement

For some reports that process a huge amount of data,  the users may go mad about the runtimes of queries. For some extend we can improve the performance by playing with the design of the datasource, dataflow, the queries or the aggregates. In this document I will explain how filling OLAP Cache using broadcasting affects the performance of a query.

For this aim, a query which has a long runtime is selected: ZTEST_Q0001. For filling the OLAP cache,  BEx Broadcaster is selected in query design menu as seen below:


When we select BEx Broadcaster, an html page is opened in the browser. If no broadcasting setting is made beforehand, you will see the screen as below:


Select Create New Setting. You will see a pane below where a list of possible alternatives for broadcasting is made:


When “Fill OLAP Cache” option is selected, the output format will automatically be OLAP Cache Content


Save the broadcast giving the technical name and description:


Now it is seen in the main browser and can be changed anytime:


The next step will be creating a variant to schedule this broadcast. For this aim se38 transaction is used to run the program: ”RSRD_BROADCAST_STARTER”. Select Variants and click on Display button:


Create a variant for the program by clicking on the create button next to the Variant field:


Give a name to the variant and create it.


Set the technical name of the setting same as the technical name given in broadcast definition in the previous step. Click on Attributes button and enter a description:


Save the variant. Go back to se38 to run RSRD_BROADCAST_STARTER. Select “With Variant” option and select the variant just created in the previous step. The program can directly be run manually or can be scheduled using execution in background.


You can schedule this job everyday for those queries that have a long run time.  This process can also be included in a process chain. I experienced around 75% improvement on a query which is built on an infocube with 50 million records. You can also measure the performance improvement running the query with RSRT using cache and not using cache and analyze the statistics.

I hope it gives an idea for performance improvement.


Yasemin Uluturk

You must be Logged on to comment or reply to a post.
    • Thank you very much for your nice comment Suman. your document on how to optimize reporting performance inspired me to write this document 🙂

  • Hi Yasemin,

    Reports performance wise its most useful information and good presentation.

    its easy to understand the concept.

    Thanks for sharing.

    As my guess BEx forum will be right place to publish..



    • Hi Raman,

      I just realized that I published it in the wrong space. Moderator has moved to its correct place. Thank you for your very nice comment.

      • Hi Yasemin ULUTURK,

        It’s not moderator. I have moved to BEx space. I think you have created your document in such a way that anybody can edit it. I get edit option as well. If you don’t want to make it to be editable by public, you may just change it.



        • Hi Suman,

          I got a message that it was moved by the moderator. I will leave it as it is so that if anyone has some experience to share or something to change, then s/he can edit and make it more useful. Thank you 🙂

  • Hi,

    Thanks for was really useful.

    In sales function, there’s a bex query which executes for long time and finally gives out time out error.  The sales process chain runs at every 4 hours.  Do I need to schedule the olap cache broadcaster for every 4 hours to ensure that we’ll get 4 hours sales’ update?

    Kindly suggest.


    Antony Jerald.

    • Hi Antony, thank you for liking the document. You need to schedule that every four hours so that it will be updated. You can also include this step in the process chain. You can create a program triggering an event for broadcasting, and in the process chain you can call this program. Regards


      • I couldn’t find “Fill OLAP Cache” option in the BEx broadcaster.  Only Broadcast-Email option is visible in the broadcaster.

        Could you please tell me how to get the option for filling olap cache?  Is there any additional settings I need to do?  Kindly suggest.



        Antony Jerald.

  • Hi Yasemin
    You have always helped me  when ever i have put my queries in the forum.

    And that along with Rama,Anshu, ,Suman, kodanda ,

    you have been always patient in guiding and making us learn from our mistakes and also   giving us new ideas.
    As SAP BI/BW is large enough to  give a brain storm to juniors, presence of seniors like you is always a thanks giving everyday.
    Thanks for sharing this KT. I am bookmarking it to read and keep a note of this. 🙂

    Regards, Aparajit

  • Hi experts,

    I’m trying to follow the steps, but when I tried to “SAVE”, nothing happened, no popup appears to enter Technical Name, would appreciate if anyone could help on this? thanks in advance.