SACP1

1. In a story table cell, you want to change the value from 500 to 450. What can you enter to achieve this? (2 correct). 90%. -50. -10%. +-50.

2. When setting up data wrangling to import data, which functions can be used in calculated columns? (2 correct). TRIM. CONTAIN. LOOK UP. DATEDIFF. RESTRICT.

3. What can you do with Smart Predict but not with table-based predictive forecast? (2 correct). Add dimensions to identify entities. Define the number of forecast periods. Select the algorithm. Add influencers.

4. What can you use to publish the result of a predictive forecast in a planning model (2 correct). Line chart. Time series chart. Table. Smart Predict model.

5. When you set up a copy data action, what must you do to allow the user to select the source and target versión?. Add a copy rule for versión. Create a parameter for the target versión. Create a parameter for the source versión.

6. For which of the following are VDT available? (2 correct). Live models. Datasets. Planning models. Analytic models.

7. Which of the following are prerequisites to export transaction data to a Data Store object (advanced) in SAPBusiness Warehouse? (2 correct). OData Connection. Enhancement spot RSBPC_ODATA. SAP BW connection. Maintenance view RSBPC_ODATA_V_EX.

8. Which of the following actions on the date dimension are available in Value Driver Trees? (2 correct). Change the date filter for an individual node within the Value Driver Tree. Select the Day granularity. Specify a presentation date range.

9. In SAP Analytics Cloud: where can you apply data security?. SAP Identity Management. Property. Analysis authorizations.

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

11. In an analytic application you want to use a data action trigger. Your customer complains that the dataaction 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.

12. You want to create an input task using a story based on a planning model. What are the prerequisites for this scenario? (2 correct). The model is shared. The model contains private dimensions. The story is shared. The model has a private versión.

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 versión data. Append: Reject duplicated rows in model. Update. Clean and replace subset of data with Scope = Version and Account.

14. You are using the BPC version for SAP BW/S4HANA Standard option. When importing data from YTD model to SAC, what can you do? (2 correct). Select the basic model type. Store YTD data for income statement accounts. Store periodic data for income statement accounts. Select the write-back model type.

15. 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 setting in the allocation process is required to achieve this?. Add date as a source dimensión. Add date as a reference dimensión. Add product as a source dimensión. Add product as a reference dimensión.

16. 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? (2 correct). Source measure. Rate type. Category. Exchange rate.

17. When you delete a planning model, what dimension types are always deleted? (2 correct). Time. Organization. Version. Account.

18. You want to rebuild an SAP Analytics Cloud classic planning model but the Rebuild Model button is inactive. Why might this happen? (2 correct). Data exists in the model. A public version is used in the model. Currency conversion is enabled. A private version is used in the model.

19. In SAP Analytics Cloud Smart Predict, how can you use versions with a planning model? (2 correct). Train the model with in-process public data. Train the model with completed public data. Save the forecast to public versión. Save the forecast to private versión.

20. You are importing account hierarchy data from S/4HANA. To import the member to node assignments, what node type must you use?. R. N. L.

21. How can you use a data action to copy data from one version to another while keeping the account number the same? (2 correct). Include a parameter for version and account in the filter section of the data action. 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.

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

23. What dimension types can be used to determine currencies? (2 correct). Version. Generic. Organization. Account.

24. Which work files can you access when you run a planning process? (2 correct). URL link. Workbook. Analytic application. Dashboard.

25. 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). When you go back to the Member Planning page, what will you see? (2 correct). North America 10,000. US 0. Canada 0. South America 30,300. Brazil 100. Chile 100. Peru 100. North America 10,000. US 5,000. Canada 5,000. South America 30,300. Brazil 10,100. Chile 10,100. Peru 10,100.

26. In a story, how can you create a chart to compare versions? (2 correct). Add a chart component. Add a new member with a formula. Add a recommended comparison. Add a difference from measure.

27. You enter the following code into the formula script editor: MEMBERSET[d/Account]= What does the auto-complete feature return? (2 correct). Properties. Parameters. Hierarchies. Members.

28. What can you do in a value driver tree with only a BI user role? (2 correct). Filter the date dimensión at node level. Add a cross calculation to a specific node. Nest value driver trees. Enter data into the value driver tree.

29. 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. InfoProvider. Data source.

30. Which of the following properties does a CommentInfo object in an analytical application contain? (3 correct). The number of likes. The comment description. The comment texts. The change history. The comment technical ID.

31. 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 1282.81%, influencer count 1. Athletic Shorts - EMEA: Expected MAPE 7.16%, influencer count 1.

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

33. 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.

34. 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? (2 correct). To connect to any device. To highlight changed cells. To swap axes. To lock data.

35. 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.

36. 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?. Restriced. Converted. Calculated.

37. Which modeling options can you use in a classic account planning model? (2 correct). Define a default currency. Define calculated measures. Define conversion measure. Activate pre-calculated actuals.

38. Regarding the creation of master data, what is available in analytical applications but not in stories? (2 correct). 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 look up of master data property values.

39. How can you change plan data via the Planning Panel in a story? (2 correct). Repost the values to a higher leve lof the hierarchy. Realign values based on properties. Distribute values based on recommendations. Redistribute values among date members.

40. What dimensions types are required in a planning model? (3 correct). Account. Generic. Date. Organization. Version.