SAP Updated C_SAC_2501 Exam Questions and Answers by marley

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.

To aggregate measures for columns such as Country, Region, City, and Customer Name as a single column in an embedded dataset, creating a level-based hierarchy is the most effective approach. This type of hierarchy allows you to define a multi-level structure that represents the logical relationship between different geographical entities and customer names. By doing so, you can easily perform aggregations and analyze data at various levels of detail, from the broadest level (e.g., Country) down to the most specific one (e.g., Customer Name).

For designing a new story in SAP Analytics Cloud where the size and position of widgets need to adjust dynamically for different devices and screen sizes, the Responsive page type should be used. Responsive pages automatically adapt to the screen size of the device they are viewed on, providing an optimal viewing experience across desktops, tablets, and smartphones.