How to Prepare for the SAP C_SACP_2302 Exam and Become a Certified SAP Analytics Cloud Planner?

1. Which dimension types support the system-generated Person Responsible property? Note: There are 2 correct answers to this question.

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

3. You create an input form with a restricted measure called 'Current Year Plan' based on the amount measure and date set to current year.

In the attached image, what is used to display the selected year as a column header?

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

5. You have compared the data version options in stories vs. SAP Analysis, Edition for Microsoft Office.

What did you discover?

6. Which activities can be scheduled from the calendar in SAP Analytics Cloud? Note: There are 2 correct answers to this question

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

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

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

10. When you set up a copy data action, what must you do to allow the user to select the source and target version?

11. Which DataStore object (advanced) properties must be selected to export data to SAP Business Warehouse? Note: There are 2 correct answers to this question.

12. Which of the following are features of an Embedded Data Action step? Note: There are 2 correct answers to this question

13. You need to schedule the import master data for the profit center, cost center, account dimensions as well as the transction data. Each dimension has members, text, attribites and a hierarchy. When importing from SAP Business Warehouse.

How many import steps do you need?

14. When you enable currency translation for a planning model with an account dimension which object is added to the model automatically?

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

16. In SAP Analytics Cloud, what must you do when you use a planning model with group reporting data for legal elimination reports? Note: There are 2 correct answers to this question.

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

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

19. In an analytic application, which element can you enter comments for?

20. You want to create a copy data action that allows you select the source values and target values for the following dimensions at run time; Version. Account. Time.

What do you specify for each of these dimensions?

21. Which planning version type can you share with a co-worker from within a story?

22. What must you do to create a seasonal time hierarchy? Note: There are 2 correct answers to this question.

23. In SAP Analytics Cloud, where can users access data locking tasks?

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

25. What can you do in a value driver tree with only a BI user role? Note: There are 2 correct answers to this question

26. Which of the following actions on the date dimension are available in Value Driver Trees? Note: There are 2 correct answers to this question.

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

28. In the delivered content for collaborative enterprise planning, where do the sales volumes come from?

29. Using a live connection in SAP Analytics Cloud, for which system can you change plan data?

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

31. For which of the following are value driver trees available? Note: There are 2 correct answers to this question

32. When training s smart predict model, which entity has the most accurate forecast?

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

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

35. You want to import group reporting data to an SAP Analytics Cloud planning model.

What source table must you use?

36. Which of the following dimensions supports multiple hierarchies?

37. From which S/4HANA source table can you import actual data for cost centers?

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

39. Why would you decide to use an Analytic Application instead of a Story? Note: There are 2 correct answers to this question.

40. What SAP Business Warehouse data can you import into SAP Analytics Cloud? Note: There are 2 correct answers to this question.

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

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

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

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

45. Which of the following dimension types supports multiple hierarchies?

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

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

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

49. Why do you use a table formula?

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