C_SAC_2501 Exam Dumps : SAP Certified Associate - Data Analyst - SAP Analytics Cloud

Table formulas in SAP Analytics Cloud are used to perform cell-based calculations within a story. These formulas can be applied directly to table cells, allowing for customized calculations that are specific to the data presented in the table. This feature is particularly useful for ad-hoc analysis and when specific calculations are needed that are not covered by predefined measures or dimensions.

In a live model within SAP Analytics Cloud, dimensions can be organized into logical categories using either level-based hierarchies or parent-child hierarchies. Level-based hierarchies are used when the relationships between items are defined by distinct levels, such as Geography might be divided into Country, State, and City levels. Parent-child hierarchies, on the other hand, are useful when the data's hierarchy is not strictly defined by levels but by a parent relationship where a child member is associated with a parent member, which is common in organizational structures or product categories.