SAP Analytics Cloud Planning Flashcards

1
Q

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?
Please choose the correct answer.

Response:

A warning message is displayed

An error message is displayed

The data is re-aligned.

The data is deleted

A

A warning message is displayed

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

Response:

To swap axes

To lock data

To connect to any device

To highlight changed cells

A

To lock data

To connect to any device

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

Response:

Substring

Calculation

Concatenate

Delete

A

Calculation

Delete

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

Response:

Overwrite mode

Delta mode

Update calendar month

Update fiscal period

A

Overwrite mode

Update calendar month

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

In the delivered content for collaborative enterprise planning, where do the sales volumes come from?
Please choose the correct answer.

Response:

SAP S/4HANA Sales

SAP Business Planning and Consolidation

SAP Integrated Business Planning

A

SAP Integrated Business Planning

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

When training a smart predict model, which entity has the most accurate forecast?
Please choose the correct answer.

Response:

Athletic Shorts – US: Expected MAPE 1382.81 %, influencer count 1

Athletic Shorts – EMEA: Expected MAPE 7.16 %, influencer count 1

Athletic Shorts – Pacific: Expected MAPE 12.84 %, influencer count 2

A

Athletic Shorts – EMEA: Expected MAPE 7.16 %, influencer count 1

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

In an analytic application you want to use a data action trigger. Your customer complains that the data action trigger pushbutton is too large. How can you address this complaint?
Please choose the correct answer.

Response:

Add a cascading style sheet to the data action trigger.

Resize the data action trigger in the builder pane.

Use a button to run a data action.

A

Resize the data action trigger in the builder pane.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

Response:

Insert a calculated column to a table

Activate comments by model

Add a comment widget to the story

Activate comments by dimension

A

Activate comments by model

Add a comment widget to the story

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

Response:

To connect to any device.

To swap axes

To create versions

To highlight changed cells

A

To connect to any device.

To highlight changed cells

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

Response:

Select a consolidation unit hierarchy

Select a consolidation profit center hierarchy

Determine elimination entities dynamically

Store elimination entities persistently

A

Select a consolidation unit hierarchy

Store elimination entities persistently

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Which activities can be scheduled from the calendar in SAP Analytics Cloud?
There are 2 correct answers to this question.

Response:

Data action

Data locking

Publish stories

Create input form

A

Data action

Create input form

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

Response:

Data actions

Data imports

Data locking

Data exports

A

Data actions

Data locking

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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 dimension do you add to the allocation process to achieve this?
Please choose the correct answer.

Response:

Add date as a reference dimension

Add product as a source dimension

Add date as a source dimension

Add product as a reference dimension

A

Add product as a reference dimension

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

Response:

Parameters

Properties

Hierarchies

Members

A

Parameters

Members

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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?
Please choose the correct answer.

Response:

Options

Aggregate to

Filters

Copy Rules

A

Aggregate to

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

In an analytic application, which element can you enter comments for?
Please choose the correct answer.

Response:

Dimension members in a table

Data points in a chart

Data cells in a table

A

Data cells in a table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Using a live connection in SAP Analytics Cloud, for which system can you change plan data?
Please choose the correct answer.

Response:

SAP BPC Embedded

SAP BPC Standard

SAP S/4HANA

A

SAP BPC Embedded

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

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

Response:

Basic

Write-back

Generic

Financial

A

Basic

Write-back

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

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

Response:

Hierarchical characteristic structures

SAP BW Query text elements

Characteristic Structure

Calculate Key Figures

A

Characteristic Structure

Calculate Key Figures

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Analytics Cloud with a hierarchy. You want to update the new dimension with data from a characteristic in SAP Business Warehouse using SAP recommended practices.

To populate the members and the hierarchy, what steps must you take?
There are 3 correct answers to this question.

Response:

Include the hierarchy in the SAP Business Warehouse query.

Create an SAP Analytics Cloud query.

Load the members and hierarchy in the same import.

Load the members in a separate import.

Create an SAP Business Warehouse query.

A

Include the hierarchy in the SAP Business Warehouse query.

Load the members and hierarchy in the same import.

Create an SAP Business Warehouse query.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

You want to create a copy data action that allows you to select the source and target values for the following dimensions at run time: Version. Account. Time.

What do you specify for each of these dimensions?
Please choose the correct answer.

Response:

Source and target parameters for version, account, and time in the copy rules

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

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

Source and target parameters for version in the filter

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

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

Response:

Smart Discovery

Smart Predict

Smart Insights

Smart Grouping

A

Smart Predict

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

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 enable Currency Conversion.

How does this impact the planning model?
There are 2 correct answers to this question.

Response:

Currencies are determined from the converted measure

Currencies are determined from the entity dimension

Local currency is imported.

Local currency and group currency are imported.

A

Currencies are determined from the converted measure

Local currency is imported.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Why do you use a table formula?
Please choose the correct answer.

Response:

To create an on-the-fly calculation

To enable allocation of data

To disaggregate data

To define link dimensions

A

To create an on-the-fly calculation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

What is supported when you use the New Model for planning?
There are 3 correct answers to this question.

Response:

Using a currency variable

Viewing formula results in the modeler

Using a default model currency

Creating a measure using simple moving average

Defining a model without an account dimension

A

Using a currency variable

Viewing formula results in the modeler

Defining a model without an account dimension

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

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

Response:

Company to an SAP Analytics Cloud entity

General ledger account to an SAP Analytics Cloud account

Financial statement item to an SAP Analytics Cloud account

Consolidation unit to an SAP Analytics Cloud entity

A

Financial statement item to an SAP Analytics Cloud account

Consolidation unit to an SAP Analytics Cloud entity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

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?
There are 2 correct answers to this question.

Response:

Create Data Actions

Creates Data Manager Packages

Create planning sequences

Create Public Dimensions

A

Create Data Actions

Create planning sequences

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

When you set up a copy data action, what must you do to allow the user to select the source version?
Please choose the correct answer.

Response:

Add a parameter to the filter.

Add an aggregate for the version.

Add a copy rule for the version.

A

Add a parameter to the filter.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

When importing transaction data from SAP Business Warehouse to SAP Analytics Cloud, what is the maximum?
Please choose the correct answer.

Response:

100 000 000 cells

10 000 000 cells

2 000 000 000 rows

800 000 rows

A

100 000 000 cells

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

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?
Please choose the correct answer.

Response:

5

6

3

1

A

5

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

In a rolling forecast table, what can be used to determine the date to cut over to plan data?
Please choose the correct answer.

Response:

Look ahead x number of months

Last actual value

Look back x number of months

Current and next time filter

A

Last actual value

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

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

Response:

Account

Organization

Date

Generic

A

Organization

Generic

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

In the following graphic, how does the advanced formula eliminate intercompany accounts payable(121100IC) and accounts receivable(211100IC)?
Please choose the correct answer.

Response:

Credit PostingLevel 10.

Post the offset value to the same account as the source.

Post the elimination value to an account different than the source.

Debit PostingLevel 20.

A

Debit PostingLevel 20.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

What can you do in an analytics application?
Please choose the correct answer.

Response:

Enter from-based comments.

Read data from write-back models

Trigger input tasks.

A

Read data from write-back models

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

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?
There are 2 correct answers to this question.

Response:

Look up the labor rates in an advanced data action.

Copy the labor rates into the expense model.

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

Blend labor hours and labor rates in the story.

A

Look up the labor rates in an advanced data action.

Copy the labor rates into the expense model.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

What can you use to restrict input in a story based on tested conditions?
Please choose the correct answer.

Response:

Advance filtering

Data Locking

Validation Rules

A

Advance filtering

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

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?
There are 2 correct answers to this question.

Response:

Cell locks.

Dataslice locks

Data locks

Work status locks

A

Cell locks.

Data locks

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

Where can you use time series forecasting in SAP Analytics Cloud?
There are 2 correct answers to this question.

Response:

SAP Analytics Cloud, add-in for Microsoft Office

Smart Predict

Story table

Bar chart

A

Smart Predict

Story table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q

What must you do to create a seasonal time hierarchy?
There are 2 correct answers to this question.

Response:

Add a member

Add a property

Set date to system-managed

Set date to user-managed

A

Add a member

Set date to system-managed

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
40
Q

In a story table cell, you want to change the value from 500 to 450.

What can you enter to achieve this?

Note: There are 2 correct answers to this question.

-10%
-50
+-50
90%

A

-10%

+-50

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
41
Q

In the following graphic, how does the advanced formula eliminate intercompany accounts payable(121100IC) and accounts receivable(211100IC)?

05 SACP20 U5 L2 Graphic_50.png

Post the offset value to the same account as the source.
Post the elimination value to an account different than the source.
Credit PostingLevel 10.
Debit PostingLevel 20.

A

Debit PostingLevel 20.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
42
Q

You have an SAP Analytics Cloud BI license.

What can you do with a value driver tree (VDT)?

Note: There are 2 correct answers to this question.

Publish data with a VDT.
Change data on a VDT.
Create a VDT directly within a story.
Create a VDT from a planning process.

A

Change data on a VDT.

Create a VDT from a planning process.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
43
Q

Where can you run data actions?
Note: There are 2 correct answers to this question.

SAP Analytics Cloud calendar
Planning sequence
Analytical application
Planning process

A

Analytical application

SAP Analytics Cloud calendar

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
44
Q

Which components will you need before you can import group reporting transaction data from S/4HANA into SAP Analytics Cloud?
Note: There are 2 correct answers to this question.

S/4HANA connection
GRTransactionData query
OData connection
Freehand query
A

OData connection
Freehand query

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
45
Q

Which of the following are options in SAP BPC, version for SAP NetWeaver that can be integrated with SAP Analytics Cloud Planning?

Note: There are 2 correct answers to this question.

Optimized
Embedded
Financial
Stand-alone

A

Optimized
Embedded

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
46
Q

What validation rule types are supported by SAP Analytics Cloud?
Note: There are 2 correct answers to this question.

User exit
Hierarchy
Member
Attribute
A

Member
Attribute

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
47
Q

What dimension types are required in a planning model?
Note: There are 3 correct answers to this question.
Organization
Account
Generic
Date
Version

A

Date
Version
Account

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
48
Q

When setting up data wrangling to import data, which functions can be used in calculated columns?
Note: There are 3 correct answers to this question.
RESTRICT
LOOKUP
CONTAIN
TRIM
DATEDIFF

A

CONTAIN
TRIM
DATEDIFF

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
49
Q

What can you use to publish the result of a predictive forecast in a planning model?
Note: There are 2 correct answers to this question.
Time series chart
Smart Predict model
Line chart
Table

A

Smart Predict model

Table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
50
Q

What can you schedule from the SAP Analytics Cloud calendar ? 2 answers
Data imports
Data actions
Data exports
Data locking

A

Data actions
Data locking.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
51
Q

You are importing from SAP S/4HANA intro a planning model with pre-converted actuals turned on. What mapping are required to import both local and default currency ? 1 answer
Two Currencies
Two Measures
Two Account Types
Two Accounts

A

Two Measures

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
52
Q

What validation rules types are supported by SAP Analytics Cloud ?
2 answers
Hierarchy
Attributes
User exit
Member

A

Attributes

Member

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
53
Q

You have an SAP Business Warehouse data source with 25 key figures and no account characteristics. What must you do to import the this data into an existing new type of planning model ? 2 answers
Include 25 measures in the planning model.
Map the key figure to accounts during the import
Map they key figures to the measures during the import Include 25 accounts in the planning model.

A

Map the key figure to accounts during the import

Include 25 accounts in the planning model.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
54
Q

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

ACDOCA
COSS
ACDOCP
COSP .

A

ACDOCA

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
55
Q

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

A

FPA1

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
56
Q

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 ?
2 answers
Creates Data Manager Packages Create Planning sequences Create Data Actions
Create Public Dimensions.

A

Create Data Actions

Create Planning sequences

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
57
Q

You want to create an input task using a story based on planning model. What are prerequisites for this scenario ? 2 Correct Answers
The model contains private dimensions
The model is shared
The story is shared
The model has a private version .

A

The model has a private version

The model is shared

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
58
Q

You have an SAP Business Warehouse data source with 25 key figures and no account characteristics. What must you do to import the this data into an existing new type of planning model ? 2
Include 25 measures in the planning model.
Map the key figure to accounts during the import
Map they key figures to the measures during the import Include 25 accounts in the planning model.

A

Include 25 measures in the planning model.

Map the key figure to accounts during the import

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
59
Q

When you configure a planning area in a model, what can the planning area based on ?
2 Correct

Data access control
Cell locking
Data locking
Input control .

A

Data locking
Data access control

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
60
Q

You have a planning model with the following dimensions: Cost Center, Account, DAte, Version. When you add new transactional data to your model, you want to add new data for cost center A and remove any records for cost center B. Which import method do you use
Append
Update
Clean and replace selected version data.

A

Clean and replace selected version data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
61
Q

In story, how can you create a chart to compare versions ? 2 Correct Answers
Add a chart component
Add a new member with formula
Add a I diffidence from I measure
Add a recommended comparison.

A

Add a recommended comparison.

Add a chart component

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
62
Q

Which dimension types support the system-generated Person Responsible property? 2 correct Version
Generic
Account
Organization

A

Generic

Organization

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
63
Q

Why would you decide to use a Analytic Application instead of a Story ? 2 Correct Answers
To use advance data actions
To use data cell comments
To do form-based data input To have fewer data action triggers.

A

To do form-based data input To have fewer data action triggers.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
64
Q

In the delivered content for collaboration enterprise planning, where do the sales volumes come from ?
SAP S/4HANA Sales
SAP Business Planning and Consolidation
SAP Integrated Business Planning

A

SAP Integrated Business Planning

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
65
Q

What are the pillars of SAP Analytics Cloud ?
3 Correct Answers
Planning
Predictive
Data Warehousing
Blockchain Management Business Intelligence

A

Planning
Predictive
Business Intelligence

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
66
Q

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 ?
2 Correct Answers
Rate type
Category
Source Measure
Exchange.

A

Category

Source Measure

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
67
Q

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?
2 Correct Answers

Store YTD data for income statement accounts
Store periodic data for income statement accounts
Select the write-back model type
Select the basic model type.

A

Store periodic data for income statement accounts

Select the basic model type.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
68
Q

Which of the following are options in SAP BPC, version for SAP NetWeaver that can be integrated with SAP Analytics Cloud Planning ?
Optimized
Stand-alone
Embedded
Financial.

A

Optimized

Embedded

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
69
Q

You are using SAP analytics Cloud abd SAP BPC, version for SAP BW/4HANA Embedded option. Which of the following planning features are available for hybrid planning 2 Correct Answers
Data actions
Data Access Controls
Analysis Authorization
Planning Sequences.

A

Analysis Authorization
Planning Sequences

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
70
Q

You are importing from SAP S/4HANA intro a planning model with pre-converted actuals turned on. What mapping are required to import both local and default currency ? 1 answer
Two Currencies
Two Measures
Two Account Types
Two Accounts .

A

Two Measures

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
71
Q

What is supported when you use the new model for planning ?
3 answers

Using a currency variable
Using a default currency
Defining a model without an account dimension
Viewing formula results in the modeler
Creating a measure using simple moving average.

A

Using a currency variable

Viewing formula results in the modeler

Defining a model without an account dimension

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
72
Q

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

Store periodic data for income statement model type.
Select the write-back model type
Select the basic model type
Store YTD data for income statement accounts.

A

Store periodic data for income statement model type.

Select the basic model type

73
Q

In an analytic application you want to use a data action trigger. Your customer complains that the data trigger is too large. How can you address this complaint ?

Resize the data action trigger in the builder pane
Add a cascading style sheet to the data action trigger
Use a button to run a data

A

Use a button to run a data

74
Q

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 planning model (new type) ?
Map the key figures to the measures during the import
Map the key figures to accounts during the import
Include 25 accounts in the planning model
Include 25 measures in the planning model.

A

Include 25 accounts in the planning model

Map the key figures to accounts during the import

75
Q

In a story: you are using a planning model with currency translation enabled. Which properties in the cross calcultion editor do you have when configuring currency conversion ?
One answer

Category
Exchange rate
Rate type
Rate version.

A

Category

76
Q

How can you change plan data via the planning panel in a story ? 2 Correct Answers
Repost the values to a high level of the hierarchy
Realign values based on properties
Distribute values based on recommendations
Redistribute values to a lower level of the hierarchy.

A

Distribute values based on recommendations

Redistribute values to a lower level of the hierarchy.

77
Q

Which of the following actions would allow you to use data point comments ?
2 Correct Answers

Activate comments by model
Activate comments by dimension
Activate comment widget to the story
Insert a calculated column to a table.

A

Activate comment widget to the story

Activate comments by model

78
Q

What can you do with Smart Predict but not with table-based predictive forecast ?
2 correct answers

Add influencers
Add dimensions to identify entities
Define number of forecast periods
Select the algorithm.

A

Add influencers

Define number of forecast periods

79
Q

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

A

Process

80
Q

In SAP Analytics Cloud, where can users access data locking tasks ?
1 answer
Calendar
Planning Stories
Input Controls
Security .

A

Calendar

81
Q

In an analytic application, which element can you enter comments for ?
Data cells in a table
Dimension members in a table Data points in a chart.

A

Data cells in a table

82
Q

You are mapping an SAP Business Warehouse data source with 4 key figures and 10 lines of data to a planning model. You have mapped all key figures to your model. How many lines of data are imported into your model ? 10 14 4 40.

A

10

83
Q

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

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

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

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

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

A

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

84
Q

For which of the following are value driver trees available ? Analytic models
Datasets
Live models
Planning models.

A

Analytic models

Planning models

85
Q

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 ?
2 answers

Creates Data Manager Packages
Create Planning sequences
Create Data Actions
Create Public Dimensions.

A

Create Planning sequences
Create Data Actions

86
Q

What can you schedule from the SAP Analytics Cloud calendar ?
Data imports
Data actions
Data exports
Data locking

A

Data actions

Data locking

87
Q

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

Add an aggregate for the version
Add a copy rules for the version
Add a parameter to the filter

A

Add a parameter to the filter

88
Q

Which scheduling task is available from SAP Analytics Cloud calendar ?
Planning Sequence
Multi action
Allocation process.

A

Multi action

89
Q

You want to import data from SAP BPC Standard. Which SAP Analytics Cloud planning model types can you use ? 2 Correct answers
Write-Back
Generic
Basic
Financial.

A

Write-Back

Basic

90
Q

What can you use to publish the results of a predictive forecast in a planning model ? 2 Correct answers
Smart Predict model
Table
Line chart
Time series chart.

A

Smart Predict model
Table

91
Q

What can you do with live connections in SAP Analytics Cloud ? 2 Correct Answers Secure data with SAP Analytics Cloud Security
Export data
Reduce data Redundancy Secure data with on-premise security.

A

Reduce data Redundancy

Secure data with on-premise security.

92
Q

You save 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 story ?
1 answer
An error message is displayed The data in deleted
The data is re-aligned
A warning message is displayed.

A

A warning message is displayed

93
Q

What node types can be imported from S/4HANA ?
3 Correct Answers
L N H R T.

A

L
N
R

94
Q

What dimension types can be used to determine currencies ?
2 Correct Answers
Date
Account
Organization
Generic

A

Organization
Generic

95
Q

Which account types allow you to display database values with the opposite sign in stories ?
2 Correct answers
EXP
INC
AST
LEQ

A

AST
LEQ

96
Q

You have an SAP Analytics Cloud BI License. What can you do with a value driver tree (VDT) ?
2 answers
Create a VDT directly within a story
Change data on a VDT
Create VDT from a planning process
Publish data with a VDT.

A

Change data on a VDT

Create a VDT directly within a story

97
Q

When you run a data action with the “publish target version automatically “ setting enabled, what changes to your data are published ?
2 answers

Manual changes to the target version
Data action-specific changes to private and public versions
Data action-specific changes to the target public version
Manual changes to the private and public versions.

A

Data action-specific changes to the target public version

Manual changes to the target version

98
Q

Where can you schedule an import into an SAP Analytics Cloud model ?
SAP Analytics Cloud Calendar
SAP BW process chain
Data Management
Data action monitor- *you can use the Data Action Monitor to check the status. .

A

Data Management

99
Q

What are prerequisites for importing master data from an SAP S/4HANA System into SAP Analytics Cloud ? 2 Correct Answers
The target dimension must be a private dimension
The target dimension must be input enabled
A data service must be active in the S/4HANA service catlog
A CDS view must exist for the source data.

A

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

A CDS view must exist for the source data

100
Q

You have an allocation process with 3 steps. Which of the following can be used to run only allocation step #2 ? Allocation Button
Data Action
Story Taskar.

A

Data Action

101
Q

Which of the following actions on the data dimension are available in value Driver trees ?
Change the date filter for an individual node within the value Driver Tree
Specify a presentation date range
Change the date filter for the entire value driver tree
Select the Day granularity

A

Change the date filter for the entire value driver tree

Select the Day granularity

102
Q

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 New Model ?
Three measures and at least one account
Three measures and no account
One measure and at least three accounts.

A

Three measures and no account

103
Q

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 ? 2 Correct answers
Look up the labor rates in an advanced data action
Blend labor hours and labor rates in the story
Include the labor hours and labor rates in dimension formula
Copy the labor rates into the expense model.

A

Look up the labor rates in an advanced data action

Copy the labor rates into the expense model.

104
Q

You want to create an input task using a story based on planning model. What are prerequisites for this scenario ? 2 Correct Answers
The model contains private dimensions
The model is shared
The story is shared
The model has a private version

A

The model is shared

The model has a private version

105
Q

Where can you run data actions ?
2 answers

Planning sequence
SAP Analytics Cloud calendar
Planning Process
Analytical application

A

SAP Analytics Cloud calendar

Analytical application

106
Q

Using a live connection in SAP Analytics cloud, for which system can you change plan data ?
SAP BPC Standard
SAP BPC Embedded
SAP S/4HANA.

A

SAP BPC Embedded

107
Q

You have an SAP Business Warehouse data source with 25 key figures and no account characteristics. What must you do to import the this data into an existing new type of planning model ? 2
Include 25 measures in the planning model.
Map the key figure to accounts during the import
Map they key figures to the measures during the import Include 25 accounts in the planning model.

A

Include 25 measures in the planning model

Map the key figure to accounts during the import

108
Q

Which DataStore object (advanced) properties must be selected to export data to SAP Business Warehouse ? 2 Correct Answers
Write interface enabled
Direct Update Datastore Object
Standard Datastore Object Write Change Log.

A

Standard Datastore Object

Write interface enabled

109
Q

In a rolling forecast table, what can be used to determine the date to cut over to plan data ? Last actual value
Look back x number of months Look ahead x number of months
Current date with an offset.

A

Last actual value

110
Q

Which hierarchy types are supported in a SAP Analytics Cloud dimension ?
1 answer

Story Specific
Level based
Version Dependant
Time Dependant.

A

Level based

111
Q

What are some characteristics of popups in analytics applications ?
Popups can be copies to stories Popups have a scripting event on initialization
Scripting can be assigned to buttons in the popup
Drop downs in the popup are only displayed when needed.

A

Drop downs in the popup are only displayed when needed

Scripting can be assigned to buttons in the popup

112
Q

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

A

Property values for private dimensions

113
Q

You are running a predictive forecast. What could the data lines represent in the preview ? Line 1 is input data
Line 2 is input data
Line 2 is forecast data
Line 1 is forecast data.

A

Line 1 is input data

Line 2 is forecast data

114
Q

Regarding comments, what can you do in analytical applications but not in stories ?
Use a dropdown box to select comments
Use a filter for a comment widget
Use the like feature of comments
Use radio buttons to select comments.

A

Use a dropdown box to select comments

Use radio buttons to select comments.

115
Q

You need a hierarchy that is based both on the region and the country column in the same dimension. What hierarchy type can you use ? 1 answer
Level-based
Table-based
Parent-child.

A

Level-based

116
Q

When you delete a planning model, what dimension types are always deleted ?

2 Correct answers

Version
Account
Time
Organization.

A

Account

Organization

117
Q

In SAP Analytics Cloud Smart Predict, how can you use versions with a planning model ? 2 Correct

Train the model with completed public data
Save the forecast to a private version
Save the forecast to public version
Train the model with in-process public data.

A

Save the forecast to a private version

Train the model with in-process public data.

118
Q

What can you use to restrict input in a story based on nested conditions ?
Validation Rules
Advance Filtering
Data locking.

A

Advance Filtering

119
Q

Which work files can you access when you run a planning process ? 2 Correct
Dashboard
Analytic Application
URL Link Workbook

A

Analytic Application
URL Link Workbook

120
Q

What can you do with a data action trigger in an analytic application ?
2 Correct

Execute the data action trigger at runtime
Use the onBeforeExecute event
Execute the data action trigger at design time
Use the onAfterExecute event.

A

Execute the data action trigger at runtime

Use the onBeforeExecute event

121
Q

When you configure a planning area in a model, what can the planning area based on ?
2 Correct answers

Data access control
Cell locking
Data locking
Input control .

A

Data access control

Data locking

122
Q

Where can you use time series forecasting in SAP Analytics Cloud ?
Bar Chart
SAP Analytics Cloud, Add-in for Microsoft Office
Story table
Smart Predict.

A

Story table
Smart Predict.

123
Q

In the visual editor for advanced formulas, which of the following formula options can you select ? 2 Correct
Repeat
Comment
Lookup
Round.

A

Repeat
Comment

124
Q

Which of the following dimensions support multiple hierarchies ?
Time
Account
Version
Organisation.

A

Account

125
Q

To import a display attribute from SAP Business Warehouse into an SAP Analytics Cloud dimension, in which BW object must the display attribute be included ?
Characteristic
Query
Data Source
InfoProvider.

A

Characteristic

126
Q

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? There are 2 correct answers to this question.

Profit center member
Profit center property value
Hierarchy node
Account member

A

Profit center member

hierarchy node

127
Q

What can you use to restrict input in a story based on nested conditions? Please choose the correct answer.

Data locking
Advanced filtering
Validation rules

A

Advanced filtering

128
Q

Which components will you need before you can import group reporting transaction data from S/4HANA into SAP Analytics Cloud? There are 2 correct answers to this question.

GRTransactionData query
OData connection
Freehand query
S/4HANA connection

A

OData connection, Freehand query

129
Q

For which of the following are Value Driver Trees available? There are 2 correct answers to this question.

Live models
Datasets
Planning models
Analytic models

A

Planning models

Analytic models

130
Q

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

Basic
Write-back
Generic
Financial

A

Basic

Write-back

131
Q

Which DataStore object (advanced) properties must be selected to export data to SAP Business Warehouse? Please choose the correct answer.

Staging dataStore object
Direct update dataStore object
Standard dataStore object

A

Standard dataStore object

132
Q

What dimension types are required in a planning model? There are 3 correct answers to this question.

Date
Version
Generic
Account
Organization

A

Date
Version
Account

133
Q

Which activities can be scheduled from the calendar in SAP Analytics Cloud? There are 2 correct answers to this question.

Data action
Publish stories
Create input form
Data locking

A

Data action

Data locking

134
Q

What can you do in a value driver tree with only a BI user role? There are 2 correct answers to this question.

Add a cross calculation to a specific node
Filter the date dimension at node level
Enter data into the value driver tree
Nest value driver trees

A

Filter the date dimension at the node level

Enter data into the value driver tree

135
Q

What can you do with a data action trigger in an analytic application? There are 2 correct answers to this question.

Execute the data action trigger at design time
Execute the data action trigger at runtime
Use the onBeforeExecute event
Use the onAfterExecute event

A

Execute the data action trigger at runtime, Use the onBeforeExecute event

136
Q

You want to import group reporting data to an SAP Analytics Cloud planning model. Which one?
ACDOCU
ACDOCP
ACDOCA
ACDOCC .

A

ACDOCU

137
Q

When you run a data action with the “publish target version automatically “ setting enabled, what changes to your data are published ?
Manual changes to the target version
Data action-specific changes to private and public versions
Data action-specific changes to the target public version
Manual changes to the private and public versions.

A

Data action-specific changes to the target public version

Manual changes to the target version

138
Q

When you set up a copy data action, what must you do to allow the user to select source version ?
Add an aggregate for the version
Add a copy rules for the version
Add a parameter to the filter

A

Add a parameter to the filter

139
Q

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

Local actual value
Look back x number of months
Look ahead x number of months Current date with an offset.

A

Local actual value

140
Q

Regarding comments, what can you do in analytical applications but not in stories ?

Use a dropdown box to select comments
Use a filter for a comment widget
Use the like feature of comments
Use radio buttons to select comments.

A

Use radio buttons to select comments.

Use a dropdown box to select comments

141
Q

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

RSBPC_ODATA_V_EX
OData connection
SAP Business Warehouse connection
Maintenance view
Enhancement spot RSBPC_ODATA

A

OData connection
RSBPC_ODATA_V_EX

142
Q

How can you configure a currency conversion measure in a New Model?
Please choose the correct answer.

Response:

Hard code a unit type.

Dynamically determine a unit type

Hard code a Category

A

Hard code a Category

143
Q

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

Response:

User defined

Append

Proportionate

Equal

Overwrite

A

User defined

Proportionate

Equal

144
Q

You are importing account hierarchy data from S/4HANA. To import the member to node assignments, what node type must you use?
There is 1 correct answers to this question.

Response:

N

R

L

A

L

145
Q

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?
Please choose the correct answer.

Response:

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

[Revenue] - [Cost] := INVERSE ([Cost] = [Revenue] -[Profit]).

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

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

A

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

Invert all then :=

146
Q

When you configure a planning area in a model, what can the planning area be based on?
There are 2 correct answers to this question.

Response:

Data access control

Cell locking

Data locking

Input controls

A

Data access control

Data locking

147
Q

In SAP Analytics Cloud, where can users data locking tasks?
Please choose the correct answer.

Response:

Input Controls

Planning Stories

Calendar

Security

A

Calendar

148
Q

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

Response:

Calculate depreciation.

Aggregate dimension members.

Eliminate inter company transactions in real-time.

Forecast HR turnover rates using machine learning.

A

Calculate depreciation.

Aggregate dimension members.

149
Q

Regarding the creation of master data, what is available in analytical applications but not in stories?
There are 2 correct answers to this question.

Response:

Parent node assignments of new members if a related hierarchy exists

System-generated master data members

Dimension lookup of master data property values

The “Add member” context menu option in a planning table

A

Parent node assignments of new members if a related hierarchy exists

The “Add member” context menu option in a planning table

150
Q

What validation rule types are supported by SAP Analytics Cloud?
There are 2 correct answers to this question.

Response:

User exit

Hierarchy

Member

Attribute

A

Member

Attribute

151
Q

When importing data, why would you use a New Model instead of a Classic Model?
Please choose the 1 correct answer.

Response:

To change data types

To define link dimensions

To import multiple versions

To combine data from multiple sources

A

To change data types

152
Q

What must you do to create a seasonal time hierarchy?
There are 2 correct answers to this question.

Response:

Set date to user-managed

Set date to system-managed

Add a member

Add a property

A

Set date to system-managed

Add a member

153
Q

Which of the following properties does a Comment Info object in an analytical application contain?
There are 3 correct answers to this question.

Response:

The comment text

The comment length

The comment technical ID

The number of likes

The change history

A

The comment text

The comment technical ID

The number of likes

154
Q

What is supported when you use the New Model for planning?
There are 3 correct answers to this question.

Response:

Using a default model currency

Viewing formula results in the modeler

Defining a model without an account dimension

Using a currency variable

Creating a measure using simple moving average

A

Viewing formula results in the modeler

Defining a model without an account dimension

Using a currency variable

155
Q

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

Response:

Account

Date

Organization

Generic

A

Organization

Generic

156
Q

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

Response:

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

Specify a presentation date range.

Change the date filter for the entire Value Driver Tree.

Select the day granularity

A

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

Select the day granularity

157
Q

What can you use to restrict input in a story based on nested conditions?
Please choose the correct answer.

Response:

Advanced filtering

Data locking

Validation rules

A

Advanced filtering

158
Q

Which scheduling task is available from the SAP Analytics Cloud calendar?
Please choose the correct answer.

Response:

Multi action

Allocation process

Planning sequence

A

Multi Action

159
Q

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

Response:

Hierarchies for public dimensions

Property values for public dimensions

Property values for private dimensions

A

Property values for private dimensions

160
Q

In an existing planning model, what currency-related setting CANNOT be changed?
Please choose the correct answer.

Response:

Currency dimension

Date dimension

Default currency

Currency table

A

Currency table

161
Q

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

Response:

SAP Identity Management

Property

Analysis Authorizations

Model

A

SAP Identity Management

Model

162
Q

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

Response:

The data version options are the same.

Private versions are available in stories only

Sharing private versions is available only in stories

A

The data version options are the same.

163
Q

Where can you use time series forecasting in SAP Analytics Cloud?
There are 2 correct answers to this question.

Response:

SAP Analytics Cloud, add-in for Microsoft Office

Bar chart

Story table

Smart Predict

A

Story table

Smart Predict

164
Q

When you set up a copy data action, what must you do to allow the user to select the source and target version?
Please choose the 1 correct answer.

Response:

Create a parameter for the target version.

Add a copy rule for version.

Create a parameter for the source version.

A

Create a parameter for the source version.

165
Q

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

Response:

SAP HANA

SAP HANA for Group Reporting

SAP Analytics Cloud

SAP Business Objects Universe

A

SAP HANA

SAP Analytics Cloud

166
Q

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

Choose:

LEQ

EXP

AST

INC

A

LEQ

AST

167
Q

What does SAP recommend you do to improve the performance of advanced formulas?
Please choose the correct answer.

Choose one:

Minimise the use of LOOP instructions

Minimise the number of MEMBERSET statements

Maximise the number of RESULTLOOKUPs

Maximise the number of DATA functions

A

Minimise the use of LOOP instructions

168
Q

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?
There are 2 correct answers to this question.

Choose:

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

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

North America 10000. US 5000. Canada 5000

North America 10000 . US 0. Canada 0

A

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

North America 10000. US 5000. Canada 5000

169
Q

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?
Please choose the correct answer.

Response:

Calculated

Restricted

Conversion

A

Conversion

170
Q

What can you do with Smart Predict but not with table-based predictive forecast?
There are 2 correct answers to this question.

Response:

Add dimensions to identify entities

Define number of forecast periods

Select the algorithm

Add influencers

A

Define number of forecast periods

Add influencers

171
Q

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

Response:

Comment

Repeat

Lookup

Round

A

Comment

Repeat

172
Q

Which modeling options can you use in a classic account planning model?
There are 2 correct answers to this question.

Response:

Activate pre-calculated actuals

Define conversion measures

Define calculated measures

Define a default currency

A

Activate pre-calculated actuals

Define a default currency

173
Q

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?
Please choose the correct answer.

Choose one:

Update

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

Clean and replace selected version data

Append: Reject duplicated rows in model

A

Update

174
Q

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

Choose:

Cost rates

Activity quantities

Statistical orders

Statistical key figures

A

Activity quantities

Statistical key figures

175
Q

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

Choose:

A public version is used in the model.

Currency conversion is enabled.

Data exists in the model.

A private version is used in the model

A

Currency conversion is enabled.

A private version is used in the model

176
Q

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?
There are 2 correct answers to this question.

Response:

Planning sequences

Analysis authorizations

Data actions

Data access controls

A

Planning sequences

Analysis authorizations

177
Q

Which of the following can you use to create a planning model?

Analytic App

File

Model

Datasource

Story

A

File

Model

Datasource

178
Q

In SAP Analytics Cloud, where can users access data locking tasks ?
Calendar
Planning Stories
Input Controls
Security .

A

Calendar

179
Q

In an analytic application, which element can you enter comments for ?
Data cells in a table
Dimension members in a table
Data points in a chart.

A

Data cells in a table