SAP Analytics Cloud Planning Flashcards
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 warning message is displayed
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
To lock data
To connect to any device
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
Calculation
Delete
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
Overwrite mode
Update calendar month
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
SAP Integrated Business Planning
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
Athletic Shorts – EMEA: Expected MAPE 7.16 %, influencer count 1
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.
Resize the data action trigger in the builder pane.
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
Activate comments by model
Add a comment widget to the story
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
To connect to any device.
To highlight changed cells
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
Select a consolidation unit hierarchy
Store elimination entities persistently
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
Data action
Create input form
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
Data actions
Data locking
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
Add product as a reference dimension
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
Parameters
Members
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
Aggregate to
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
Data cells in a table
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
SAP BPC Embedded
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
Basic
Write-back
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
Characteristic Structure
Calculate Key Figures
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.
Include the hierarchy in the SAP Business Warehouse query.
Load the members and hierarchy in the same import.
Create an SAP Business Warehouse query.
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
Source version parameter in the filter. Source and target parameters for account and time in the copy rules
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
Smart Predict
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.
Currencies are determined from the converted measure
Local currency is imported.
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
To create an on-the-fly calculation
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
Using a currency variable
Viewing formula results in the modeler
Defining a model without an account dimension
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
Financial statement item to an SAP Analytics Cloud account
Consolidation unit to an SAP Analytics Cloud entity
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
Create Data Actions
Create planning sequences
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.
Add a parameter to the filter.
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
100 000 000 cells
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
5
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
Last actual value
What dimension types can be used to determine currencies?
There are 2 correct answers to this question.
Response:
Account
Organization
Date
Generic
Organization
Generic
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.
Debit PostingLevel 20.
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.
Read data from write-back models
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.
Look up the labor rates in an advanced data action.
Copy the labor rates into the expense model.
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
Advance filtering
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
Cell locks.
Data locks
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
Smart Predict
Story table
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
Add a member
Set date to system-managed
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%
-10%
+-50
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.
Debit PostingLevel 20.
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.
Change data on a VDT.
Create a VDT from a planning process.
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
Analytical application
SAP Analytics Cloud calendar
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
OData connection
Freehand query
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
Optimized
Embedded
What validation rule types are supported by SAP Analytics Cloud?
Note: There are 2 correct answers to this question.
User exit Hierarchy Member Attribute
Member
Attribute
What dimension types are required in a planning model?
Note: There are 3 correct answers to this question.
Organization
Account
Generic
Date
Version
Date
Version
Account
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
CONTAIN
TRIM
DATEDIFF
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
Smart Predict model
Table
What can you schedule from the SAP Analytics Cloud calendar ? 2 answers
Data imports
Data actions
Data exports
Data locking
Data actions
Data locking.
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
Two Measures
What validation rules types are supported by SAP Analytics Cloud ?
2 answers
Hierarchy
Attributes
User exit
Member
Attributes
Member
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.
Map the key figure to accounts during the import
Include 25 accounts in the planning model.
From which S/4HANA source table can you import actual data for cost centers ?
1 answer
ACDOCA
COSS
ACDOCP
COSP .
ACDOCA
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
FPA1
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.
Create Data Actions
Create Planning sequences
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 .
The model has a private version
The model is shared
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.
Include 25 measures in the planning model.
Map the key figure to accounts during the import
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 .
Data locking
Data access control
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.
Clean and replace selected version data.
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.
Add a recommended comparison.
Add a chart component
Which dimension types support the system-generated Person Responsible property? 2 correct Version
Generic
Account
Organization
Generic
Organization
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.
To do form-based data input To have fewer data action triggers.
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
SAP Integrated Business Planning
What are the pillars of SAP Analytics Cloud ?
3 Correct Answers
Planning
Predictive
Data Warehousing
Blockchain Management Business Intelligence
Planning
Predictive
Business Intelligence
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.
Category
Source Measure
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.
Store periodic data for income statement accounts
Select the basic model type.
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.
Optimized
Embedded
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.
Analysis Authorization
Planning Sequences
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 .
Two Measures
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.
Using a currency variable
Viewing formula results in the modeler
Defining a model without an account dimension