Optimize the Story Builder Performance
In SAP Analytics Cloud stories, optimize your story building performance by reducing the number of queries.
By default, every modification to your table or chart from the builder panel sends a query to the server, resulting in an immediate update to the table or chart. For example, when adding or removing a dimension or measure, you need to wait for the chart or table to be updated before making another change. Depending on the size of the model, the response time can be slow; this can put a heavy load on the server.
Model: How to Optimize Story Builder Performance
To reduce the number of queries being sent, enable the following option in your model: Optimize Story Builder Performance.
Once this option is enabled, when you use the model in a story you will see a warning message at the top of the Builder panel stating that the data source doesn't automatically refresh.
Story: How to Refresh Charts or Tables
When the optimization option is enabled, and you modify objects in the Builder panel, you will see a refresh
button (
) in the data source warning message and the main
part of the story page is grayed out (has a gray overlay).
-
In the data source warning message in the Builder panel, click the refresh button (
). -
On the story page, click the chart or table widget.
Either of these actions processes the query (removes the gray overlay) and updates the chart or table widget.
In some situations, clicking the story page or the chart or table widget removes the gray overlay, but doesn't update the data, or you may not see the gray overlay. (For example, when you've added a dimension input control in the Builder panel.)
In those situations, go to the warning message at the top of the Builder panel and click the refresh button
().