1. 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 Input controls Data Access Control Data security.
2. In the delivered content for collaborative enterprise planning, where do the sales volume come from? One answer required SAP Integrated Business Planning (IBP) SAP Business Planning and Consolidation SAP S/4HANA Sales.
3. Where can you use time series forecasting in SAP Analytics Cloud? Note: There are 2 correct answers to this question. Story Table Bar chart SAP Analytics Cloud, add-in for Microsoft Office Smart Predict.
4. 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 100 000 000 cells.
5. Where can you run data actions? Select 2 Analytics Application Story SAP Analytics Cloud Calendar SAC Model.
6. When training a smart predict model, which entity has the most accurate forecast? Athletic Shorts – EMEA: Expected MAPE 7.16%, influencer count 1 Athletic Shorts – Pacific: Expected MAPE 12.84 %, influencer count 2 Athletic Shorts – US: Expected MAPE 1382.81 %, influencer count 1.
7. Using a live connection in SAP Analytics Cloud, for which system can you change plan data? SAP S/4HANA SAP BPC Embedded SAP BPC Standard.
8. When you set up a copy data action, what must you do to allow the user to select the source & target version? Create a parameter for the source version Add a copy rule for version. Create a parameter for the target version.
9. What can you do in a value driver tree with only a BI user role? Select 2 options Enter Data into the value driver tree Nest value driver trees. Add a cross calculation to a specific node Filter the date dimension at node level.
10. Which scenarios can you implement using SAP Analytics Cloud advanced formulas? Note: There are 2 correct answers to this question Aggregate dimension members Add a cross calculation to a specific node Calculate Depreciation Standard Datastore Object.
11. 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. Select the basic model type Store periodic data for income statement accounts Store YTD data for income statement accounts.
12. Which DataStore Object (advanced) properties must be selected to export data to SAP Business Warehouse? Note: There are 2 correct answers to this question Staging dataStore object Direct update datastore object Write interface enabled Standard Datastore Object.
13. You have an allocation process with 3 steps. Which of the following can be used to run only allocation step 2? Data Action Dimension Input Control.
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.
15. 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 TRIM Average DATEDIFF CONTAIN Substring.
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. What are the 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 data service must be active in the S/4HANA service catalogue A CDS view must exist for the source data OData connection Data.
18. 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 Level-Based Parent-child.
19. Which account types allow you to display database values with the opposite sign in stories? Note: There are 2 correct answers to this question LEQ AST INC EXP.
20. You create an input task using a story based on a planning model, which kind of field can you set for ‘Distribution’? User Name Dimension User role.
21. In SAP Analytics Cloud, what must you do when you use a planning model with group reporting for legal elimination reports? Note: There are 2 correct answers to this question. Select a consolidation unit hierarchy Store elimination entities persistently Prepare data Create a live connection.
22. Which of the following actions would allow you to use data point comments? Note: There are 2 correct answers to this question. Add a custom text widget to the story Activate comments by model Add a comment widget to the story Create a table to store comments.
23. 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% 100% +-50 -75.
24. What validation rule types are supported by SAP Analytics Cloud? Note: There are 2 correct answers to this question. Attribute Characteristic Member InfoProvider.
25. You are using mass data entry mode. After you enter new transaction data, what can you do with the data? Process Approve Publish.
26. What does SAP Recommend you do before you import data from SAP Business Warehouse to SAP Analytics Cloud? Install SAP Analytics Cloud Agent Install SAP Analytics Cloud Connector Make a live connection Upload a data file.
27. 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 Load the members and hierarchy in the same import Create an SAP Business Warehouse Query Include the Hierarchy in the SAP Business Warehouse query Install SAP Analytics Cloud Agent Store elimination entities persistently.
28. Which data locking status can you use to prevent manual data entry? Restricted Advance Filtering Data cells in a table Data action.
29. 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 private dimensions The model contains public dimensions. Model has private & public dimensions.
30. In an analytic application, which element can you enter comments for? Data cells in a table Data action Data Locking.
31. What can you use to restrict input in a story based on nested conditions? Advance Filtering Story Filtering Tables Restrictions Filtering.
32. Where can you enter data into an SAP Analytics Cloud Model? Note: There are 2 correct answers to this question. In a story In an analytic application In the model itself In the model settings.
33. Which activities can be scheduled from the calendar in SAP analytics Cloud? Note: There are 2 correct answers to this question Data action Data Locking Input Data Create input form.
34. 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.
35. 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 5000. Canada 5000 South America 30300. Brazil 10100. Chile 10100. Peru 10100 North America 10000 . US 0. Canada 0 South America 30300. Brazil 100. Chile 100. Peru 100.
35. You are planning with two hierarchies that have different granularity. Your model contains no
data. The story has two pages: a parent planning page and a member planning page (see
screenshot).
In the Member Planning page you enter the following data: Brazil 100. Chile 100. Peru 100. In the
Parent Planning page you enter the following data: North America 10000. South America 30000.
When you go back to the Member Planning page, what will you see? Note: There are 2 correct
answers to this question.
North America 10000 . US 0. Canada 0 South America 30300. Brazil 10100. Chile 10100. Peru 10100 North America 10000. US 5000. Canada 5000 South America 30300. Brazil 100. Chile 100. Peru 100.
36. 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.
37. Which scheduling task is available from the SAP Analytics Cloud Calendar? Multi Action Allocation process Planning sequence.
38. Which of the following actions on the date dimension are available in Value Driver Trees? Note: There are 2 correct answers to this question. Select the Day granularity Change the date filter for the entire value driver tree Specify a presentation date range.
39. When importing data, why would you use a New model instead of a Classic Model? To import multiple versions To change data types To define link dimensions To combine data from multiple sources.
40. For which of the following are value driver trees available? Note: There are 2 correct answers to this question Analytic Models
Datasets Planning Models Live models.
41. Why would you use the SAP Analytics Cloud add-in for Microsoft Office instead of SAP Analysis, Edition for Microsoft Office? Note: There are 2 correct answers to this question. To connect to any device To highlight changed cells To swap axes To lock data.
42. From which S/4HANA source table can you import actual data for cost centers? ACDOCA ACDOCP ACDOCU.
43. 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 Map the key figures to accounts during the import Include 25 accounts in the planning model Include 25 measures in the planning model. Map the key figures to the measures during the import.
44. Which of the following dimension types supports multiple hierarchies? Organization Time Account.
45. 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? Three measures and at least one account One measure and at least three accounts Three measures and no accounts.
46. 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 texts The comment Description The number of likes The comment technical ID The change history.
47. You have labour hours in an expense model and labour rates in the HR model. To calculate and store labour values (labour hours x labour rates) in the expense model, what must you do? Note: There are 2 correct answers to this question Copy the labour rates into the expense model Linked related dimensions and build the calculation Look up the labour rates in an advanced data action Link the 2 models and build the calculation.
48. Which SAP Analytics Cloud Machine Learning function provides performance indicators that can be used to evaluate the accuracy of a statistical model? Smart Predict Smart Insights Smart Discovery Predictive Forecast.
49. What SAP Business Warehouse data can you import into SAP Analytics Cloud? Note: There are 2 correct answers to this question Calculated Key Figures Characteristic Structure Measure dimension Measure Input Control.
50. 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.
51. You are running a predictive forecast. What could the data lines represent in the preview? Note: There are 2 correct answers to this question. Line 1 is input data Line 2 is forecast data Line 2 is Budget data Line 1 is raw data.
52. In SAP Analytics Cloud Smart Predict, how can you use versions with a planning model? Note: There are 2 correct answers to this question. Train the model with in-process public data Save the forecast to a private version Save the forecast to public version Train the model with completed public data.
53. 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. Consolidation unit to an SAP Analytics Cloud entity General ledger account to an SAP Analytics Cloud account Financial Statement item to an SAP Analytics Cloud account Company to an SAP Analytics Cloud entity.
54. What are some characteristics of popups in analytic applications? Note: There are 2 correct answers to this question. Dropdowns in the popup are only displayed when needed Scripting can be assigned to buttons in the popup Popups have a scripting event onInitialization. Popups can be copied to stories.
55. What dimension types are required in a planning model? Note: There are 3 correct answers to this question. Version Account Date Organization Generic.
56. 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? CDS View A CDS view must exist for the source data A data service must be active in the S/4HANA service catalogue.
57. You are using the planning panel to distribute values. Which of the following driver options can you select? Note: There 3 correct answers to this question. User Defined Equal Proportionate Planning Predictive.
58. What are the pillars of SAP Analytics Cloud? Note: There are 3 correct answers to this question. Business Intelligence Planning Predictive Discovery Data Analysis.
59. You have a planning model with the following dimensions: Account, Product, Profit Center, Date, & Version. In a Story, which new master data can you add on the fly? Note: There are 2 correct answers to this question. Hierarchy Node Product Member Category Rate member.
60. How can you translate local currency to another currency with a classic planning model? Create conversion measures in the story. Create a model conversion measure. Create a data action with a currency conversion step.
61. 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 conversion? Note: There are 2 correct answers to this question. Category Rate Version Hierarchy Node Table query.
62. 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. OData connection Freehand Query BW Query SAP Data Warehouse.
63. You want to import group reporting data to an SAP Analytics Cloud planning model. What source table must you use? ACDOCU ACDOCP ACDOCA.
64. You are creating a planning model that is based on SAP BPC, version for SAP BW/4HANA Embedded option. What sources are supported for the SAC Analytics Cloud model? BW Query SAC Model Data file.
65. 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 Currency conversion is enabled A private version is used in the model Data exists in the model. A public version is used in the model.
66. 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? Use a button to run a data action Resize the data action trigger in the builder pane. Add a cascading style sheet to the data action trigger.
67. Which of the following are options in SAC 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 Classic Overwrite Mode.
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 Calendar Month Overwrite Mode Update fiscal period Delta mode.
69. 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. The ‘Add member” context menu option in a planning table Parent node assignments of new members if a related hierarchy exists System-generated master data members Dimension lookup of master data property values.
70. 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.
35. 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.
|
