A level-based hierarchy is the specific feature in SAP Analytics Cloud designed to solve this problem. It allows you to take separate, related dimension columns (like Country, Region, City) and organize them into a defined, ordered structure. In a story, this hierarchy is presented as a single, drillable dimension, enabling users to aggregate measures and navigate from the highest level (Country) down to the most granular level (Customer Name) seamlessly. This directly accomplishes the goal of aggregating measures for these columns as a single column.

A. Create a group that includes the dimensions: Grouping is used to combine individual members within a single dimension into a custom category, not to combine multiple dimensions into a hierarchy.

C. Create a parent-child hierarchy in the dataset: This type of hierarchy requires a specific data structure with parent and child ID columns, which is not suitable for the level-based data described (Country, Region, City).

D. Convert the embedded dataset to a model: While converting to a model enables more advanced features, it is a preparatory step. The direct action that creates the single hierarchical column is creating the level-based hierarchy itself.

1. SAP Help Portal

SAP Analytics Cloud - Create a Level-Based Hierarchy in a Dataset: "You can create a level-based hierarchy from existing dimensions in a dataset. For example

if your dataset has dimensions for Country

State

and City

you can create a location hierarchy with levels for each of these dimensions." This directly supports option B as the correct procedure.

2. SAP Help Portal

SAP Analytics Cloud - About Parent-Child Hierarchies: This document describes parent-child hierarchies as being defined by a parent member attribute

which is a different structure from the one presented in the question

thus invalidating option C.

3. SAP Help Portal

SAP Analytics Cloud - Grouping Data: "You can group data values to create new groupings on the fly in your stories." This confirms that grouping applies to values within a dimension

making option A incorrect.

4. SAP Help Portal

SAP Analytics Cloud - Converting a Dataset into a Model: "When you convert a dataset into a model

you can take advantage of the advanced modeling features..." This shows that conversion is a prerequisite for advanced features like hierarchies

but not the action itself

making option B more precise than D.