1. In the visual editor for advanced formulas, which of the following formula options can you select?
Note: There are 2 correct answers to this question.
Concatenate Calculation Delete Substring.
3. You create an input task using a story based on a planning model. Which kind of field can you set
for "Distribution"?
User Role User Name Dimension.
4. In the pre-delivered planning content, which financial statement version is used to integrate
S/4HANA account hierarchies and SAP Analytics Cloud account hierarchies?
YCOA S4H1 FPA1.
5. What data can be exported from SAP Analytics Cloud to SAP S/4HANA? Note: There are 2 correct
answers to this question. Statistical orders Activity quantities Statistical key figures Cost rates.
6.Which of the following dimension types supports multiple hierarchies? Time Account Organisation.
7.What dimension types can be used to determine currencies? Note: There are 2 correct answers to
this question.
Date Account Organisation Generic.
8.When importing data, why would you use a New Model instead of a Classic Model? To change data types To define link dimensions To import multiple versions To combine data from multiple sources.
9.What can you do in a value driver tree with only a BI user role? Note: There are 2 correct answers
to this question.
Enter data into the value driver tree. Nest value driver trees. Filter the date dimension at node level. Add a cross calculation to a specific node.
10.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 account in the filter and 'to' & 'from' parameters for version 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 version and account in the filter section of the data action.
11.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 Maintenance view RSBPC_ODATA_V_EX Enhancement spot RSBPC_ODATA SAP Business Warehouse connection.
12.You want to rebuild an SAP Analytics Cloud classic planning model but the Rebuild Model button is
inactive. Why might this happen? Note: There are 2 correct answers to this question.
Data exists in the model. Currency conversion is enabled. A public version is used in the model. A private version is used in the model.
13.What is supported when you use the New Model for planning? Note: There are 3 correct answers
to this question.
Defining a model without an account dimension Using a default model currency Viewing formula results in the modeler Creating a measure using simple moving average Using a currency variable.
14.Which scheduling task is available from the SAP Analytics Cloud calendar? Allocation process Planning sequence Multi action.
15. When importing transaction data from SAP Business Warehouse to SAP Analytics Cloud, what is
the maximum?
10 000 000 cells 2 000 000 000 rows 800 000 rows 100 000 000 cells.
16. 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 InfoProvider Data source Query.
17. How can you translate local currency to another currency with a classic planning model? Create a data action with a currency conversion step. Create a model conversion measure. Create conversion measures in the story.
18. 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?
Clean and replace selected version data Update Clean and replace subset of data with Scope = Version and Account Append: Reject duplicated rows in model.
19. In SAP Analytics Cloud, where can you apply data security ? Dimension properties SAP Identity Management Analysis authorizations.
20. In a rolling forecast table, what can be used to determine the date to cut over to plan data? Last actual value Look ahead x number of months Current and next time filter.
21. You want to import data from SAP BPC Standard. Which SAP Analytics Cloud planning model types
can you use? Note: There are 2 correct answers to this question. Basic Generic Write-back Financial.
22. What are some characteristics of popups in analytic applications? Note: There are 2 correct
answers to this question.
Popups have a scripting event onInitialization. Dropdowns in the popup are only displayed when needed. Scripting can be assigned to buttons in the popup. Popups can be copied to stories.
23.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)?
Note: There are 2 correct answers to this question.
Include 25 measures in the planning model. 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.
24. Regarding the creation of master data, what is available in analytical applications but not in
stories? Note: There are 2 correct answers to this question.
Parent node assignments of new members if a related hierarchy exists The “Add member” context menu option in a planning table System-generated master data members Dimension lookup of master data property values.
25. What can you do with Smart Predict but not with table-based predictive forecast? Note: There are
2 correct answers to this question.
Define number of forecast periods Add influencers Add dimensions to identify entities Select the algorithm.
26. Why would you decide to use an Analytic Application instead of a Story? Note: There are 2 correct
answers to this question.
To use advanced data actions To do form-based data input To have fewer data action triggers To use data cell comments.
27. In a story, you are using 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.
Exchange rate Source measure Category Rate type.
28. Where can you schedule an import into an SAP Analytics Cloud model? Data action monitor Data management SAP BW process chain SAP Analytics Cloud calendar.
29.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?
3 5 1.
30. 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? Note: There are 2 correct answers to this question.
Local currency and group currency are imported. Local currency is imported. Currencies are determined from the converted measure Currencies are determined from the entity dimension.
31. When you enable currency translation for a planning model with an account dimension, which
object is added to the model automatically?
Rate type property Currency dimension Currency property.
32. When you set up a copy data action, what must you do to allow the user to select the source and
target version?
Add a copy rule for version. Create a parameter for the target version. Create a parameter for the source version.
33. You want to create an input task using a story based on a planning model. What are prerequisites
for this scenario? Note: There are 2 correct answers to this question.
The model contains private dimensions. The model is shared. The story is shared. The model has a private version.
34. Why do you use a table formula? To create an on-the-fly calculation To enable allocation of data To disaggregate data To define link dimensions.
35. You have labor hours in an expense model and labor rates in the HR model. To calculate and store
labor values (labor hours x labor rates) in the expense model, what must you do? Note: There are
2 correct answers to this question.
Copy the labor rates into the expense model. Blend labor hours and labor rates in the story. Include the labor hours and labor rates in a dimension formula. Look up the labor rates in an advanced data action.
36. 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?
Add a cascading style sheet to the data action trigger. Use a button to run a data action. Resize the data action trigger in the builder pane.
37. What can you do with a data action trigger in an analytic application? Note: There are 2 correct
answers to this question.
Use the onBeforeExecute event. Execute the data action trigger at runtime. Execute the data action trigger at design time. Use the onAfterExecute event.
38. 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?
One measure and at least three accounts Three measures and at least one account Three measures and no accounts.
39. 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.
Data actions Analysis authorizations Data access controls Planning sequences.
40. Which of the following properties does a CommentInfo object in an analytical application contain?
Note: There are 3 correct answers to this question.
The comment technical ID The number of likes The change history The comment length The comment text.
41. Using a live connection in SAP Analytics Cloud, for which system can you change plan data? SAP BPC Standard SAP S/4HANA SAP BPC Embedded.
42. How can you change plan data via the Planning Panel in a story? Note: There are 2 correct answers
to this question.
Repost the values to a higher level of the hierarchy. Realign values based on properties. Distribute values based on recommendations. Redistribute values among date members.
43. 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?
Update Append Clean and replace selected version data.
44. Which account types allow you to display database values with the opposite sign in stories? Note:
There are 2 correct answers to this question.
INC LEQ AST EXP.
45. You are using mass data entry mode. After you enter new transaction data, what can you do with
the data?
Process Approve Publish.
46. In SAP Analytics Cloud Smart Predict, how can you use versions with a planning model? Note:
There are 2 correct answers to this question.
Save the forecast to public version. Save the forecast to a private version. Train the model with completed public data. Train the model with in-process public data.
47. Regarding comments, what can you do in analytical applications but not in stories? Note: There
are 2 correct answers to this question.
Use a dropdown box to select comments. Use the Like feature of comments. Use a filter for a comment widget. Use radio buttons to select comments.
48. You need to copy data between versions 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?
Aggregate to Copy rules context.
49. Which activities can be scheduled from the calendar in SAP Analytics Cloud? Note: There are 2
correct answers to this question.
Create input form Data locking Data action Publish stories.
50. You are planning in a new model type sourced from S/4HANA with currency enabled. The model
contains a local currency measure and a group currency measure. What happens when you enter
local currency values on a plan version?
The group currency in SAP Analytics Cloud stays the same. The group currency is translated based on the SAP Analytics Cloud currency table. The group currency is translated based on the S/4HANA currency table.
51. When you delete a planning model, what dimension types are always deleted? Note: There are 2
correct answers to this question.
Organization Account Version Time.
52. When training a smart predict model, which entity has the most accurate forecast? Athletic Shorts – Pacific: Expected MAPE 12.84 %, influencer count 2 Athletic Shorts – US: Expected MAPE 1382.81 %, influencer count 1 Athletic Shorts – EMEA: Expected MAPE 7.16 %, influencer count 1.
53. What can you use to restrict input in a story based on nested conditions? Advanced filtering Validation rules Data locking.
54. You are using the SAP BPC, version for SAP BW/4HANA Standard option. When importing data
from a YTD model to SAP Analytics Cloud, what can you do? Note: There are 2 correct answers to
this question.
Select the write-back model type. Store periodic data for income statement accounts. Select the basic model type. Store YTD data for income statement accounts.
55. In a story, how can you create a chart to compare versions? Note: There are 2 correct answers to
this question.
Add a new member with a formula. Add a chart component. Add a 'difference from' measure. Add a recommended comparison.
56. In the delivered content for collaborative enterprise planning, where do the sales volumes come
from?
SAP Business Planning and Consolidation SAP Integrated Business Planning SAP S/4HANA Sales.
57. When you configure a planning area in a model, what can the planning area be based on? Note:
There are 2 correct answers to this question.
Data locking Data access control Input controls Cell locking.
58. For which of the following are value driver trees available? Note: There are 2 correct answers to
this question.
Live models Datasets Planning models Analytic models.
59. 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? Note: There are 2 correct answers to this
question.
To connect to any device To highlight changed cells To swap axes To lock data.
60. Which modeling options can you use in a classic account planning model? Note: There are 2
correct answers to this question.
Define a default currency Define calculated measures Define conversion measures Activate pre-calculated actuals.
61 You are importing from SAP S/4HANA into a planning model with pre-converted actuals turned
on. What mappings are required to import both local and default currency?
Two measures Two currencies Two currency types.
62. 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.
Company to an SAP Analytics Cloud entity Consolidation unit to an SAP Analytics Cloud entity Financial statement item to an SAP Analytics Cloud account General ledger account to an SAP Analytics Cloud account.
63. When you run a data action with the "publish target version automatically" setting enabled, what
changes to your data are published? Note: There are 2 correct answers to this question.
Manual changes to the target version Data action-specific changes to the private and public versions Manual changes to the private and public versions Data action-specific changes to the target public version.
64. Which of the following actions on the date dimension are available in Value Driver Trees? Specify a presentation date range. Select the day granularity. Change the date filter for an individual node within the Value Driver Tree.
65. 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?
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 and target parameters for version, account, and time in the copy rules.
66. 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?
Table-based Parent-child Level-based.
67. You have a planning model with the following dimensions: account, product, profit center, date,
and version. In a story, which new master data can you add on the fly? Note: There are 2 correct
answers to this question.
Profit center member Profit center property value Account member Hierarchy node.
2. Which DataStore object (advanced) properties must be selected to export data to SAP Business
Warehouse?
Standard dataStore object Staging dataStore object Direct update datastore object Write interface enabled.
68. When exporting from SAP Analytics Cloud to SAP Business Warehouse, which of the following are
active by default? Note: There are 2 correct answers to this question.
Update fiscal period Update calendar month Overwrite mode Delta mode.
69. Which of the following are features of an Embedded Data Action step? Note: There are 2 correct
answers to this question.
Link parameters of data actions Create cyclical references of data actions Combine data actions of different models Nest data actions.
70. Which dimension types support the system-generated Person Responsible property? Note: There
are 2 correct answers to this question.
Account Generic Organization Version.
71. You want to import group reporting data to an SAP Analytics cloud planning model. What source
table must you use?
ACDOCP ACDOCU ACDOCA.
72. When you import account hierarchy data from SAP S/4HANA, which of the following account
types are determined by semantic tags exclusively? Note: There are 2 correct answers to this
question.
LEQ INC EXP AST.
73. You are planning with two hierarchies that have different granularity. Your model contains no
data. The story has two pages: a parent planning page and a member planning page (see
screenshot).
In the Member Planning page you enter the following data: Brazil 100. Chile 100. Peru 100. In the
Parent Planning page you enter the following data: North America 10000. South America 30000.
When you go back to the Member Planning page, what will you see? Note: There are 2 correct
answers to this question.
North America 10000 . US 0. Canada 0 North America 10000. US 5000. Canada 5000 South America 30300. Brazil 10100. Chile 10100. Peru 10100 South America 30300. Brazil 100. Chile 100. Peru 100.
74. You enter the following code into the formula script editor: MEMBERSET[d/Account]= What does
the auto-complete feature return? Note: There are 2 correct answers to this question.
Properties Parameters Members Hierarchies.
75. You are importing account hierarchy data from S/4HANA. To import the member to node
assignments, what node type must you use?
N R L.
76. Which work files can you access when you run a planning process? Note: There are 2 correct
answers to this question.
Dashboard Analytic application Workbook URL link.
77. You need to schedule the import master data for the profit center, cost center, account
dimensions as well as the transaction data. Each dimension has members, text, attributes, and a
hierarchy. When importing from SAP Business Warehouse, how many import steps do you need?
4 13 10.
78. 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?
Calculated Conversion Restricted.
79. 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?
Add product as a source dimension Add date as a source dimension Add product as a reference dimension Add date as a reference dimension.
80. Where can you use time series forecasting in SAP Analytics Cloud? Note: There are 2 correct
answers to this question.
SAP Analytics Cloud, add-in for Microsoft Office Bar chart Smart Predict Story table.
81. In the delivered content for collaborative enterprise planning, where do the sales volume come from? SAP Integrated Business Planning (IBP) SAP BW SAP SAC.
|
