How can you limit the refresh time of a story?

Collapsing the hierarchy in a story can help limit the refresh time, as it reduces the amount of data that needs to be processed and displayed at any given time. By presenting data at a higher aggregation level initially, you can improve performance and allow users to expand specific sections of the hierarchy as needed for more detailed analysis.

References:

SAP Analytics Cloud Help Documentation: Improving Story Performance

SAP Analytics Cloud User Guide: Managing Data Hierarchy for Performance