[Apr 08, 2022] Step by Step Guide to Prepare for C-SACP-2114 Exam BrainDumps [Q12-Q30] : Free Exam Dumps Collection : http://free.examcollectionpass.com

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

Maximize the number of DATA functions.

Maximize the number of RESULTLOOKUPs.

Minimize the number of MEMBERSET statements.

Minimize the use of LOOP instructions.

NO.13 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.

Source measure

Exchange rate

Rate type

Category

NO.14 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 dat a. What setting in the allocation process is required to achieve this?

Add product as a source dimension

Add product as a reference dimension

Add date as a source dimension

Add date as a reference dimension

NO.15 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.

Analysis authorizations

Data actions

Data access controls

Planning sequences

NO.16 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.

Include ‘to’ & ‘from’ parameters for version and account in the copy rules.

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

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

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

NO.17 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.

North America 10000. US 0. Canada 0

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

North America 10000. US 5000. Canada 5000

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

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

Version

Account

Organization

Time

NO.19 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.

Create planning sequences.

Create data actions.

Create public dimensions.

Create data manager packages.

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

Select the Day granularity.

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

Change the date filter for the entire Value Driver Tree.

Specify a presentation date range.

NO.21 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?

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

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

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

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

NO.22 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?

Converted

Calculated

Restricted

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

Add a comment widget to the story.

Activate comments by model.

Activate comments by dimension.

Insert a calculated column to a table.

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

Data source

Model

Story

Analytic application

File

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

NO.26 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.

OData connection

Enhancement spot RSBPC_ODATA

SAP Business Warehouse connection

Maintenance view RSBPC_ODATA_V_EX

NO.27 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?

Update

Clean and replace selected version data

Append: Reject duplicated rows in model

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

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

Create a parameter for the target version.

Add a copy rule for version.

Create a parameter for the source version.

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

Plan

Public

Private

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

Advanced filtering

Validation rules

Data locking