Which implementation step is mandatory to set up an on-the-fly KPI calculation? (1)

You insert an input-enabled query as a data source in Analysis for Office. You update values and would like to work with data in the planning buffer without storing data persistently in the database.
Which standard Analysis for Office methods can you use accomplish this?
Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.
Contribute: Please send the correct answers with reference text/link on [email protected] to get up to 50% cashback.
Response:

You use an account-by-product report and want to drill down on parent accounts for one product at a time as in the attached screenshot. What do you need to select to achieve this drilldown behavior?

You want to use work status in Analysis for Office. Which steps are required? (2)

You EPM Report is enabled to send data and comments. You type in a revenue value and a comment in the
EPM report and save the data. Where is the data stored? (1)