Question 5
Your embedded dataset in SAP Analytics Cloud has columns for Country, Region, City, and Customer Name. You want to aggregate measures for these columns as a single column. What can you do?
Create a group that includes the dimensions.
Create a level-based hierarchy in the dataset.
Create a parent-child hierarchy in the dataset.
Convert the embedded dataset to a model.
Correct answer: B
Explanation:
SAP Analytics Cloud Help Documentation: Creating Hierarchies in ModelsSAP Analytics Cloud User Guide: Data Modeling and HierarchiesTo 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).
SAP Analytics Cloud Help Documentation: Creating Hierarchies in Models
SAP Analytics Cloud User Guide: Data Modeling and Hierarchies
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).