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.
References:
SAP Analytics Cloud Help Documentation: Using Table Formulas
SAP Analytics Cloud User Guide: Cell-Based Calculations in Stories
Question 2
Which automatically created dimension type can you delete from an analytic data model?
Options:
A.
Version
B.
Date
C.
Organization
D.
Generic
Answer:
D
Explanation:
In an analytic data model within SAP Analytics Cloud, the automatically created dimension type that you can delete is the Generic dimension. This type of dimension is typically used for custom or ad-hoc categorizations and, unlike system-generateddimensions like Date or Version, can be modified or removed as per the specific needs of your data model and analysis requirements.
References:
SAP Analytics Cloud Help Documentation: Data Model Dimensions
SAP Analytics Cloud User Guide: Managing Dimensions in Analytic Models
Question 3
What can you use to organize dimensions into logical categories in a live model?
Options:
A.
Level-based hierarchy
B.
Groups
C.
Value driver tree
D.
Parent-child hierarchy
Answer:
D
Explanation:
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.
References:
SAP Analytics Cloud Help Documentation: Creating and Managing Hierarchies
SAP Analytics Cloud User Guide: Working with Models