Learn, Practice, and Improve with SAP C_SAC_2501 Practice Test Questions

What must you use to transform data in a dataset using if/then/else logic?

A. Calculations editor

B. Custom expression editor

C. Formula bar

D. Transform bar

In a planning data model, what dimensions are included by default? Note: There are 2 correct Answers to this question

A. Date

B. Version

C. Entity

D. Organization

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.

B. Create a level-based hierarchy in the dataset.

C. Create a parent-child hierarchy in the dataset.

D. Convert the embedded dataset to a model.

You have a live data model with two dimensions: Firstname and Lastname. Users want a single dimension in the data model that displays the dimensions as Lastname, Firstname. What must you do?

A. Create the combined data in the source system.

B. Create a calculated dimension in the data model.

C. Create a calculated dimension in the story.

D. Group the Firstname and Lastname in the data model.

You are creating a new public version. Which categories can you use? Note: There are 2 correct answers to this question.

A. Budget

B. Actual

C. Predictive

D. Forecast

You are creating an allocation step to distribute expenses from the HR cost center to your operating cost centers. Which dimension setting controls how much is distributed to each operating cost center?

A. Reference

B. Driver

C. Distribute

D. Redistribute

What can you use to perform cell-based calculations in a story?

A. Calculated measures

B. Dimension formulas

C. Restricted measures

D. Table formulas