Q19. In SAP Analytics Cloud: where can you apply data security ? Note: There are 2 correct answers to this question.

Q20. 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?

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

Q22. 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 set the Currency Conversion setting to On. How does this impact the planning model? Note: There are 2 correct answers to this question.

Q23. What data sources are available for SAP Analysis, Edition for Microsoft Office? Note: There are 2 correct answers to this question.

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

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

Q26. What dimension types can be used to determine currencies? Note: There are 2 correct answers to this question.

Q27. 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 new type of planning model? Note: There are 2 correct answers to this question.

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

Q29. You want to import group reporting data to an SAP Analytics Cloud planning model. What source table must you use?

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

Q31. Which of the following are prerequisites to export transaction data to a Data Store object (advanced) in SAP Business Warehouse? Note: There are 2 correct answers to this question.

Q32. 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?

Q33. What can you use to restrict input in a story based on nested conditions?

Q34. Which of the following can you use to create an SAP Analytics Cloud planning model? Note: There are 3 correct answers to thisquestion.

Q35. You are using the planning panel to distribute values. Which of the following driver options can you select?
Note: There are 3 correct answers to this question.

Q36. How can you configure a currency conversion measure in a New Model?

Q37. In a rolling forecast table, what can be used to determine the date to cut over to plan data?