Optimize Your Story's Performance
There are a few things that you can do to optimize your SAP Analytics Cloud story's performance, both for you and for anyone who uses the story, including reducing the number of queries or providing an optimized viewing experience.
For information on optimizing story performance, see one of the following topics.
- Features that Won't Be Supported
- Optimizing Story Builder Performance
- Restrict Content Loading to the Visible Area of the Screen
- Enabling Optimized View Mode
- Optimized View Mode Limitations
- Optimized View Mode Improvements
- Best Practices for Performance Optimization in Your Story Design
Some features won't be available when the story has Optimized View Mode enabled. The story designer will need to change or remove these features before they can use optimized view mode.
| Feature | Impact | Required Action |
|---|---|---|
| Regular / classic table (non-Optimized Presentation table) | Save to Optimized View Mode is blocked | In the Builder panel, select the Optimized Presentation table |
| Grid pages | Save to Optimized View Mode is blocked | Remove Grid pages |
| BW Systems with Linked Analysis without Complex Filter Capability | Save to Optimized View Mode is blocked | Requires BW Upgrade to at least SAP BW 7.5 SP16 |
| Partial Range filters |
Story Filters – Save to Optimized View Mode BLOCKED Page Filters – Object Displayed as GHOST WIDGET |
Reset the Selection of Range Filter to Original Range |
| Range Filters with Unrestricted Drilling Off (Local and Reference Line) | Object Displayed as GHOST WIDGET | Set Unrestricted Drilling to ON |
| Legacy Value Driver Tree | Object Displayed as GHOST WIDGET | Transform Objects to New Value Driver Tree |
| Display Full Range Slider | Files automatically converted to open-ended filter | N/A |
| Explorer | Feature disabled | N/A |
| Controls Panel | Feature disabled | N/A |
By default, every builder panel modification to tables or charts 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, and this can put a heavy load on the server.
-
Select
(Model
Preferences) -
In the Model Preferences dialog, select Data and Performance.
-
Enable Optimize Story Building Performance.
After 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.