Q65. In a story, you are on 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.

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

Q67. Your account dimension has an account for Profit that is calculated as [Revenue] – [Cost]. Which formula can you use to enter a value for Profit and have the system re-calculate Cost while Revenue remains constant?

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

Q69. What is supported when you use the New Model for planning? Note: There are 3 correct answers to this question.

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

Q71. Which of the following dimensions supports multiple hierarchies?

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

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

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

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

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

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

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

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

Q80. Which data locking status can you use to prevent manual data entry?

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

Q82. What does SAP recommend you do before you import data from SAP Business Warehouse to SAP Analytics Cloud?

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

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

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

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

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