C_SACP_2114

Question. 1

Which hierarchy types are supported in an SAP Analytics Cloud dimension?

A. Version-dependent

B. Time-dependent

C. Story-specific

D. Level-based

Answers D

Question. 2

How can you configure a currency conversion measure in a New Model?

A. Hard code a category.

B. Hard code a unit type.

C. Dynamically determine a unit type.

Answers A

Question. 3

You saved data for a certain cost center and profit center combination. Later, an administrator
created a validation rule that prevents saving data against that combination. What happens when
you display the data in a story?

A. A warning message is displayed.

B. The data is realigned.

C. The data is deleted.

D. An error message is displayed.

Answers A

Question. 4

In a story, you are on a New Model with currency translation enabled. Which properties in the
calculation editor are available when you configure currency conversion? Note: There are 2 correct
answers to this question.

A. Rate type

B. Category

C. Source measure

D. Exchange rate

Answers B C
Question. 5

What can you do in an analytic application?

A. Trigger input tasks.

B. Read data from write-back models.

C. Enter form-based comments.

Answers B

Question. 6

You are importing from SAP S/4HANA into a planning model with pre-converted actuals turned on.
What mappings are required to import both local and default currency?

A. Two currency types

B. Two measures

C. Two currencies

D. Two accounts

Answers B

Question. 7

Which of the following are prerequisites to export transaction data to a DataStore object (advanced)
in SAP Business Warehouse? Note: There are 2 correct answers to this question.

A. SAP Business Warehouse connection

B. Maintenance view RSBPC_ODATA_V_EX

C. OData connection

D. Enhancement spot RSBPC_ODATA

Answers B C

Question. 8

You are using SAP Analytics Cloud and SAP BPC, version for SAP BW/4HANA Embedded option.
Which of the following planning features are available for hybrid planning? Note: There are 2 correct
answers to this question.

A. Planning sequences

B. Analysis authorizations

C. Data access controls

D. Data actions

Answers A B

Question. 9
What SAP Business Warehouse data can you import into SAP Analytics Cloud? Note: There are 2
correct answers to this question.

A. Characteristic structures

B. SAP BW query text elements

C. Hierarchical characteristic structures

D. Calculated key figures

Answers A D

Question. 10

In SAP Analytics Cloud, where can you apply data security? Note: There are 2 correct answers to this
question.

A. SAP Identity Management

B. Analysis authorizations

C. Model

D. Property

Answers C D

Question. 11

You have a New Model that only contains local currency values. When the New Model is used in
stories, you need model-configured group currency values that are not stored in the database. What
type of measure would you include in the New Model to meet the requirement?

A. Converted

B. Calculated

C. Restricted

Answers A

Question. 12

Which scenarios can you implement using SAP Analytics Cloud advanced formulas? Note: There are
2 correct answers to this question.

A. Forecast HR turnover rates using machine learning.

B. Eliminate intercompany transactions in real-time.

C. Calculate depreciation.

D. Aggregate dimension members.

Answers C D

Question. 13
When you import group reporting data from SAP S/4HANA to an SAP Analytics Cloud planning
model, which mappings are required? Note: There are 2 correct answers to this question.

A. Financial statement item to an SAP Analytics Cloud account

B. Consolidation unit to an SAP Analytics Cloud entity

C. General ledger account to an SAP Analytics Cloud account

D. Company to an SAP Analytics Cloud entity

Answers A B

Question. 14

Which of the following actions would allow you to use data point comments? Note: There are 2
correct answers to this question.

A. Activate comments by dimension.

B. Add a comment widget to the story.

C. Insert a calculated column to a table.

D. Activate comments by model.

Answers B C

Question. 15

You have a planning model with the following dimensions: account, product, profit center, date, and
version. In a story, which new master data can you add on the fly? Note: There are 2 correct answers
to this question.

A. Product member

B. Account member

C. Profit center property value

D. Hierarchy node

Answers A D

Question. 16

When you import account hierarchy data from SAP S/4HANA, which of the following account types
are determined by semantic tags exclusively? Note: There are 2 correct answers to this question.

A. AST

B. EXP

C. INC

D. LEQ

Answers A D

Question. 17
You want to import data from SAP BPC Standard. Which SAP Analytics Cloud planning model types
can you use? Note: There are 2 correct answers to this question.

A. Generic

B. Financial

C. Write-back

D. Basic

Answers C D

Question. 18

What can you use to restrict input in a story based on nested conditions?

A. Validation rules

B. Advanced filtering

C. Data locking

Answers B

Question. 19

You have a model in SAP BPC, version for SAP BW/4HANA Standard option that contains data
records in both local currency and group currency. When you create the corresponding planning
model in SAP Analytics Cloud, you set the Currency Conversion setting to On. How does this impact
the planning model? Note: There are 2 correct answers to this question.

A. Currencies are determined from the currency dimension.

B. Local currency is imported.

C. Local currency and group currency are imported.

D. Currencies are determined from the entity dimension.

Answers A B

Question. 20

In a story, how can you create a chart to compare versions? Note: There are 2 correct answers to
this question.

A. Add a new member with a formula.

B. Add a chart component.

C. Add a recommended comparison.

D. Add a 'difference from' measure.

Answers B C

Question. 21
You want to create a copy data action that allows you select the source values and target values for
the following dimensions at run time: Version Account Time. What do you specify for each of these
dimensions?

A. Source and target parameters for version in the filter. Source and target parameters for version
and time in the copy rules.

B. Source version parameter in the filter. Source and target parameters for account and time in the
copy rules.

C. Source and target parameters for version, account, and time in the filter. No copy rules

D. No Filter. Source and target parameters for version, account, and time in the copy rules

Answers B

Question. 22

In a rolling forecast table, what can be used to determine the date to cut over to plan data?

A. Current date with an offset

B. Last actual value

C. Look back x number of months

D. Look ahead x number of months

Answers B

Question. 23

Why would you use the SAP Analytics Cloud add-in for Microsoft Office instead of SAP Analysis,
Edition for Microsoft Office? Note: There are 2 correct answers to this question.

A. To create versions

B. To swap axes

C. To connect to any device

D. To highlight changed cells

Answers A C

Question. 24

In the pre-delivered planning content, which financial statement version is used to integrate
S/4HANA account hierarchies and SAP Analytics Cloud account hierarchies?

A. FPA1

B. S4H1

C. RTC1

D. YCOA

Answers A
Question. 25

You are using the planning panel to distribute values. Which of the following driver options can you
select? Note: There are 3 correct answers to this question.

A. Overwrite

B. User-defined

C. Proportionate

D. Append

E. Equal

Answers B C E

Question. 26

What can you do with live connections in SAP Analytics Cloud? Note: There are 2 correct answers to
this question.

A. Export data.

B. Reduce data redundancy.

C. Secure data with SAP Analytics Cloud security.

D. Secure data with on-premise system security.

Answers B D

Question. 27

You want to rebuild an SAP Analytics Cloud classic planning model but the Rebuild Model button is
inactive. Why might this happen? Note: There are 2 correct answers to this question.

A. A private version is used in the model.

B. Data exists in the model.

C. Currency conversion is enabled.

D. A public version is used in the model.

Answers A C

Question. 28

What can you schedule from the SAP Analytics Cloud calendar? Note: There are 2 correct answers to
this question.

A. Data locking

B. Data actions

C. Data exports

D. Data imports
Answers B D

Question. 29

You need to copy data from one version to another for a group of customers. For privacy reasons,
you want the results to be copied to an unassigned customer. Where do you specify this in your data
action?

A. Options

B. Aggregate to

C. Copy rules

D. Filters

Answers C

Question. 30

What dimension types can be used to determine currencies? Note: There are 2 correct answers to
this question.

A. Generic

B. Date

C. Organization

D. Account

Answers A C

Question. 31

You have created a new SAP Analytics Cloud dimension to be used for SAP S/4HANA master data. To
import the members, text, and hierarchy data, how many data sources do you need?

A. 6

B. 4

C. 5

D. 3

Answers C

Question. 32

What does SAP recommend you do to improve the performance of advanced formulas?

A. Minimize the use of LOOP instructions.

B. Maximize the number of RESULTLOOKUPs.

C. Maximize the number of DATA functions.

D. Minimize the number of MEMBERSET statements.

Question. 33

You imported a transaction data file into an empty model with the results as shown in Figure A.
Later, a member of the finance team wants you to import a new data file. In the new data file, you
find the following differences: The value of the Labor account has increased to 1600. There is a new
record for the Services account, with a value of 250. The record for the Travel account has been
deleted. To achieve the result shown in Figure B, which option must you use to update the data?

A. Clean and replace subset of data with Scope = Version and Account

B. Append: Reject duplicated rows in model

C. Update

D. Clean and replace selected version data

Answers C

Question. 34

Your account dimension has an account for Profit that is calculated as [Revenue] – [Cost]. Which
formula can you use to enter a value for Profit and have the system re-calculate Cost while Revenue
remains constant?

A. [Revenue] – [Cost] := INVERSE ([Cost] = [Revenue] – [Profit])

B. [Revenue] – [Cost] | INVERSE ([Cost] = [Revenue] – [Profit])

C. [Revenue] – [Cost] | INVERSE ([Cost] := [Revenue] – [Profit])

D. [Revenue] – [Cost] := (INVERSE [Cost] := [Revenue] – [Profit])

Answers C

Question. 35

When you run a data action with the "publish target version automatically" setting enabled, what
changes to your data are published? Note: There are 2 correct answers to this question.

A. Data action-specific changes to the private and public versions

B. Manual changes to the target version

C. Manual changes to the private and public versions

D. Data action-specific changes to the target public version

Answers B D

Question. 36

In the visual editor for advanced formulas, which of the following formula options can you select?
Note: There are 2 correct answers to this question.

A. Round

B. Lookup
C. Comment

D. Repeat

Answers A B

Question. 37

Which planning version type can you share with a co-worker from within a story?

A. Public

B. Private

C. Plan

Answers B

Question. 38

You have compared the data version options in stories vs. SAP Analysis, Edition for Microsoft Office.
What did you discover?

A. Private versions are available in stories only.

B. Sharing private versions is available only in stories.

C. The data version options are the same.

Answers C

Question. 39

When you import data into a classic planning model, what can you do with category and version in
data management? Note: There are 3 correct answers to this question.

A. Create a new category.

B. Use an existing category.

C. Create a new private version.

D. Use an existing version.

E. Create a new public version.

Answers B D E

Question. 40

Which data locking status can you use to prevent manual data entry?

A. Released

B. Submitted

C. Closed

D. Restricted

Answers D
Question. 41

What node types can be imported from S/4HANA? Note: There are 3 correct answers to this
question.

A. N

B. T

C. H

D. R

E. L

Answers A D E

Question. 42

Which dimension types support the system-generated Person Responsible property? Note: There
are 2 correct answers to this question.

A. Organization

B. Generic

C. Version

D. Account

Answers A B

Question. 43

You have a planning model with the following dimensions: Cost Center. Account. Date. Entity.
Version. When you add new transactional data to your model, you want to overwrite any records
with cost center A and add new data for cost center B. Which import method do you use?

A. Overwrite

B. Merge

C. Update

D. Append

Answers A

Question. 44

What are the pillars of SAP Analytics Cloud? Note: There are 3 correct answers to this question.

A. Data Warehousing

B. Blockchain management

C. Planning

D. Business Intelligence
E. Predictive

Answers C D E

Question. 45

When you set up a copy data action, what must you do to allow the user to select the source and
target version?

A. Add a copy rule for version.

B. Create a parameter for the target version.

C. Create a parameter for the source version

Answers C

Question. 46

You want to import group reporting data to an SAP Analytics cloud planning model. What source
table must you use?

A. ACDOCP

B. ACDOCC

C. ACDOCU

D. ACDOCA

Answers C

Question. 47

You are using SAP BPC, version for SAP BW/4HANA Standard option. When you create a planning
model based on an SAP BPC model, what can you do in SAP Analytics Cloud? Note: There are 2
correct answers to this question.

A. Create planning sequences.

B. Create data manager packages.

C. Create public dimensions.

D. Create data actions.

Answers A D

Question. 48

What data can be exported from SAP Analytics Cloud to SAP S/4HANA? Note: There are 2 correct
answers to this question.

A. Statistical key figures

B. Hierarchies

C. Activity prices

D. Master data attributes

Question. 49

From which S/4HANA source table can you import actual data for cost centers?

A. BSEG

B. GLT0

C. ACDOCU

D. ACDOCA

Answers D

Question. 50

You are working on a flat file-based planning model. You want to prevent manual data entry for
certain data intersections. What options do you have? Note: There are 2 correct answers to this
question.

A. Data slice locks

B. Data locks

C. Cell locks

D. Work status locks

Answers B C

Question. 51

In SAP Analytics Cloud, where can users access data locking tasks?

A. Planning stories

B. Security

C. Input controls

D. Calendar

Answers D

Question. 52

Which work files can you access when you run a planning process? Note: There are 2 correct
answers to this question.

A. Analytic application

B. Dashboard

C. Workbook

D. URL link

Answers A D
Question. 53

You have an SAP Business Warehouse data source with 25 key figures and no account characteristic.
What must you do to import this data into an existing new type of planning model? Note: There are
2 correct answers to this question.

A. Include 25 measures in the planning model.

B. Map the key figures to the measures during the import.

C. Include 25 accounts in the planning model.

D. Map the key figures to accounts during the import.

Answers C D

Question. 54

You have labor hours in an expense model and labor rates in the HR model. To calculate and store
labor values (labor hours x labor rates) in the expense model, what must you do? Note: There are 2
correct answers to this question.

A. Include the labor hours and labor rates in a dimension formula.

B. Copy the labor rates into the expense model.

C. Blend labor hours and labor rates in the story.

D. Look up the labor rates in an advanced data action.

Answers B D

Question. 55

In SAP Analytics Cloud, what must you do when you use a planning model with group reporting data
for legal elimination reports? Note: There are 2 correct answers to this question.

A. Determine elimination entities dynamically.

B. Select a consolidation unit hierarchy.

C. Select a consolidation profit center hierarchy.

D. Store elimination entities persistently.

Answers B D

Question. 56

You have financial data from SAP S/4HANA with local currency, group currency, and quantity values.
You need to import the data into SAP Analytics Cloud. Following the SAP best practice guidelines,
how would you design a New Model?

A. Three measures and no accounts

B. One measure and at least three accounts

C. Three measures and at least one account

Question. 57

Why would you decide to use an Analytic Application instead of a Story? Note: There are 2 correct
answers to this question.

A. To do form-based data input

B. To use advanced data actions

C. To use data cell comments

D. To have fewer data action triggers

Answers A D

Question. 58

You are creating a planning model that is based on SAP BPC, version for SAP BW/4HANA Embedded
option. What sources are supported for the SAP Analytics Cloud model?

A. Aggregation level

B. CDS view

C. BW query

D. CompositeProvider

Answers C

Question. 59

Which of the following actions on the date dimension are available in Value Driver Trees? Note:
There are 2 correct answers to this question.

A. Change the date filter for an individual node within the Value Driver Tree.

B. Change the date filter for the entire Value Driver Tree.

C. Specify a presentation date range.

D. Select the Day granularity.

Answers B D

Question. 60

When exporting from SAP Analytics Cloud to SAP Business Warehouse, which of the following are
active by default? Note: There are 2 correct answers to this question.

A. Update fiscal period

B. Delta mode

C. Overwrite mode

D. Update calendar month

Question. 61

Which account types allow you to display database values with the opposite sign in stories? Note:
There are 2 correct answers to this question.

A. EXP

B. LEQ

C. AST

D. INC

Answers B D

Question. 62

You have an allocation process with 3 steps. Which of the following can be used to run only
allocation step #2?

A. Story task bar

B. Allocation button

C. Data Action

Answers C

Question. 63

Which DataStore object (advanced) properties must be selected to export data to SAP Business
Warehouse? Note: There are 2 correct answers to this question.

A. Standard datastore object

B. Write change log

C. Write interface enabled

D. Direct update datastore object

Answers A C

Question. 64

What data sources are available for SAP Analysis, Edition for Microsoft Office? Note: There are 2
correct answers to this question.

A. SAP Analytics Cloud

B. SAP HANA

C. SAP S/4HANA Cloud for group reporting

D. SAP BusinessObjects Universe

Answers A B
Question. 65

You are using the SAP BPC, version for SAP BW/4HANA Standard option. When importing data from
a YTD model to SAP Analytics Cloud, what can you do? Note: There are 2 correct answers to this
question.

A. Select the write-back model type.

B. Store YTD data for income statement accounts.

C. Store periodic data for income statement accounts.

D. Select the basic model type.

Answers C D

Question. 66

You are using mass data entry mode. After you enter new transaction data, what can you do with
the data?

A. Publish

B. Process

C. Lock

D. Revert

Answers B

Question. 67

Which of the following can you use to create an SAP Analytics Cloud planning model? Note: There
are 3 correct answers to this question.

A. Model

B. File

C. Analytic application

D. Data source

E. Story

Answers A B D

Question. 68

Your account dimension has an account for Profit that is calculated as [Revenue] – [Cost]. Which
formula can you use to enter a value for Profit and have the system re-calculate Cost while Revenue
remains constant?

A. [Revenue] – [Cost] | INVERSE ([Cost] := [Revenue] – [Profit])

B. [Revenue] – [Cost] := INVERSE ([Cost] = [Revenue] – [Profit])

C. [Revenue] – [Cost] | INVERSE ([Cost] = [Revenue] – [Profit])

Question. 69

Which of the following dimensions supports multiple hierarchies?

A. Organization

B. Account

C. Time

D. Version

Answers A

Question. 70

How can you change plan data via the Planning Panel in a story? Note: There are 2 correct answers
to this question.

A. Repost the values to a higher level of the hierarchy.

B. Distribute values based on recommendations.

C. Realign values based on properties.

D. Redistribute values to a lower level of the hierarchy.

Answers B D

Question. 71

You enter plan values by year and product group. You want to allocate these values to months and
products in proportion to last year's actual data. What setting in the allocation process is required to
achieve this?

A. Add product as a source dimension

B. Add date as a source dimension

C. Add date as a reference dimension

D. Add product as a reference dimension

Answers D

Question. 72

When you delete a planning model, what dimension types are always deleted? Note: There are 2
correct answers to this question.

A. Time

B. Account

C. Organization

D. Version
Answers B C

Question. 73

You are planning with two hierarchies that have different granularity. Your model contains no data.
The story has two pages: a parent planning page and a member planning page (see

screenshot). In the Member Planning page you enter the following data: Brazil 100. Chile 100. Peru
100. In the Parent Planning page you enter the following data: North America 10000, South America
30000. When you go back to the Member Planning page, what will you see? Note: There are 2
correct answers to this question.

A. South America 30300. Brazil 10100. Chile 10100. Peru 10100

B. North America 10000. US 5000. Canada 5000

C. South America 30300. Brazil 100. Chile 100. Peru 100

D. North America 10000. US 0. Canada 0

Answers A B

Question. 74

How can you use a data action to copy data from one version to another while keeping the account
number the same? Note: There are 2 correct answers to this question.

A. Include a parameter for version in the filter and 'to' & 'from' parameters for the account
dimension in the copy rules.

B. Include a parameter for account in the filter and 'to' & 'from' parameters for version in the copy
rules.

C. Include a parameter for version and account in the filter section of the data action.

D. Include 'to' & 'from' parameters for version and account in the copy rules.

Answers A C

Question. 75

Which SAP Analytics Cloud Machine Learning function provides performance indicators that can be
used to evaluate the accuracy of a statistical model?

A. Smart Insights

B. Smart Predict

C. Smart Grouping

D. Smart Discovery

Answers B

Question. 76
You need to plan with finance data from SAP S/4HANA in SAP Analytics Cloud. To get started, you
need to import master data from SAP S/4HANA. You are following the steps recommended by SAP.
From which source can you import master data from SAP S/4HANA?

A. Dataset

B. InfoObject

C. Calculation view

D. CDS view

Answers D

Question. 77

In SAP Analytics Cloud Smart Predict, how can you use versions with a planning model? Note: There
are 2 correct answers to this question.

A. Train the model with completed public data.

B. Save the forecast to public version.

C. Save the forecast to a private version.

D. Train the model with in-process public data.

Answers C D

Question. 78

You enter the following code into the formula script editor: MEMBERSET[d/Account]= What does
the auto-complete feature return? Note: There are 2 correct answers to this question.

A. Parameters

B. Hierarchies

C. Properties

D. Members

Answers A D

Question. 79

What are prerequisites for importing master data from an SAP S/4HANA system into SAP Analytics
Cloud? Note: There are 2 correct answers to this question.

A. The target dimension must be input enabled.

B. A data service must be active in the S/4HANA service catalog.

C. A CDS view must exist for the source data.

D. The target dimension must be a private dimension.

Answers B C

Question. 80
What master data can you update during the import of transaction data into an SAP Analytics Cloud
planning model with private and public dimensions?

A. Property values for public dimensions

B. Property values for private dimensions

C. Hierarchies for public dimensions

Answers B