In a story: you are using a planning model with currency translation enabled.
Which properties in the cross calculation editor do you have when configuring currency conversion? Note: There are 2 correct answers to this question.
- A . Category
- B . Exchange rate
- C . Rate type
- D . Rate version
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 . Source Measure
- C . Category
- D . Exchange Rate
In an analytic application, which element can you enter comments for?
- A . Data cells in a table
- B . Dimension members in a table
- C . Data points in a chart
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 . Use an existing Version
- B . Create a new Public Version
- C . Create a new Private Version
- D . Use an existing category
- E . Create a new Category
Which data locking status can you use to prevent manual data entry?
- A . Released
- B . Restricted
- C . Submitted
- D . Closed
You are running a predictive forecast.
What could the data lines represent in the preview? Note: There are 2 correct answers to this question.
- A . Line 2 is forecast data
- B . Line 1 is forecast data
- C . Line 2 is input data
- D . Line 1 is input data
When you set up a copy data action, what must you do to allow the user to select the source and target version?
- A . Create a parameter for the source version
- B . Add a copy rule for version
- C . Create a parameter for the target version.
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])
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 . Copy Rules
- B . Options
- C . Filters
- D . Aggregate to
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 . S4H1
- B . RTC1
- C . YCOA
- D . FPA1
Which hierarchy types are supported in an SAP Analytics Cloud dimension?
- A . Version Dependant
- B . Time Dependant
- C . Story Specific
- D . Level based
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
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 . Story
- B . Analytic
- C . Application
- D . Datasource
- E . Model
You create a dimension in SAP 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? Note: There are 3 correct answers to this question
- A . Create an SAP Business Warehouse query.
- B . Load the members in a separate import.
- C . Include the hierarchy in the SAP Business Warehouse query.
- D . Load the members and hierarchy in the same import.
- E . Create an SAP Analytics Cloud query.
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 . Append
- B . Merge
- C . Overwrite
- D . Update
CORRECT TEXT
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 . Company to an SAP Analytics Cloud entity
- B . Financial statement item to an SAP Analytics Cloud account
- C . General ledger account to an SAP Analytics Cloud account
- D . Consolidation unit to an SAP Analytics Cloud entity
Which of the following SAP Business Warehouse variable types can be used when importing data to SAP Analytics Cloud? Note: There are 2 correct answers to this question.
- A . Customer exits
- B . SAP exits
- C . Hierarchy nodes
- D . Single values
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 . CDS View
- B . Dataset
- C . Infoset
- D . Calculation View
What data sources are available for SAP Analysis, Edition for Microsoft Office? Note: There are 2 correct answers to this question.
- A . SAP HANA for Group Reporting
- B . SAP HANA
- C . SAP Analytics Cloud
- D . SAP Business Objects Universe
From which S/4HANA source table can you import actual data for cost centers?
- A . ACDOCU
- B . GLTO
- C . BSEG
- D . ACDOCA
What node types can be imported from S/4HANA? Note: There are 3 correct answers to this question.
- A . H
- B . L
- C . N
- D . R
- E . T
You have an allocation process with 3 steps .
Which of the following can be used to run only allocation step #2?
- A . Story Taskbar
- B . Allocation button
- C . Data Action
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])
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 . One measure and at least three accounts
- B . Three measures and at least one account
- C . Three measures and no accounts
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.
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 selected version data
- B . Append: Reject duplicated rows in model
- C . Clean and replace subset of data with Scope = Version and Account
- D . Update
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? Note: There are 2 correct answers to this question.
- A . Map the key figures to the measures card during the import.
- B . Include 25 accounts in the planning model.
- C . Include 25 value columns in the planning model.
- D . Map the key figures to the account card during the import.
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 . Hierarchies for public dimensions
- B . Property values for public dimensions
- C . Property values for private dimensions
In a story, how can you create a chart to compare versions? Note: There are 2 correct answers to this question.
- A . Add a I difference from I measure.
- B . Add a recommended comparison.
- C . Add a new member with a formula.
- D . Add a chart component.
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 locks
- B . Cell locks
- C . Dataslice locks
- D . Work status locks
Which scenarios can you implement using SAP Analytics Cloud advanced formulas? Note: There are 2 correct answers to this question.
- A . Eliminate inter company transactions in real-time.
- B . Forecast HR turnover rates using machine learning.
- C . Calculate depreciation.
- D . Aggregate dimension members.
In a rolling forecast table, what can be used to determine the date to cut over to plan data?
- A . Look back x number of months
- B . Last actual value
- C . Look ahead x number of months
- D . Current date with an offset
How can you configure a currency conversion measure in a New Model?
- A . Hard code a Category
- B . Dynamically determine a unit type
- C . Hard code a unit type
In an existing planning model what currency-related setting CANNOT be changed?
- A . Default currency
- B . Date dimension
- C . Currency table
- D . Currency dimension
What can you do in an analytic application?
- A . Enter form-based comments
- B . Trigger input tasks.
- C . Read data from write-back models
What are the pillars of SAP Analytics Cloud? Note: There are 3 correct answers to this question.
- A . Predictive
- B . Planning
- C . Data Warehousing
- D . Blockchain Management
- E . Business Intelligence
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 deleted
- C . The data is re-aligned
- D . An error message is displayed