Optimizing Story Builder Performance

Optimize 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.

To reduce the number of queries being sent, enable the following option in your model: Optimize Story Builder Performance.

When the optimization option is enabled, modified charts or tables are not immediately updated. When you are satisfied with your changes, click the refresh button in the panel or the gray overlay around the panel. The query is processed and the table or chart is updated accordingly.