ExamGecko
Question list
Search
Search

Question 14 - C_SAC_2415 discussion

Report
Export

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?

A.

Create a group that includes the dimensions.

Answers
A.

Create a group that includes the dimensions.

B.

Create a level-based hierarchy in the dataset.

Answers
B.

Create a level-based hierarchy in the dataset.

C.

Create a parent-child hierarchy in the dataset.

Answers
C.

Create a parent-child hierarchy in the dataset.

D.

Convert the embedded dataset to a model.

Answers
D.

Convert the embedded dataset to a model.

Suggested answer: B

Explanation:

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).

SAP Analytics Cloud Help Documentation: Creating Hierarchies in Models

SAP Analytics Cloud User Guide: Data Modeling and Hierarchies

asked 31/10/2024
Van Raoul Datuin
32 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first