QUESTION 44
Which external hierarchy properties can be changed the query definition? (3)

QUESTION 45
What are some of the variable tyoes n a BW query that can use the processing tupe SAP HANA Exit. Note: There are 2 correct answers to this question.

QUESTION 46
You would like to highlight the deviation from predefined theshold values for key figures actual revenue. Which BW feature do you use?

QUESTION 47
Why should you run an SAP HANA delta merge? Note: There are 2 correct answers to this question.

QUESTION 48
In a BW query with cells, you need to overwrite the initial definition of a cell. With which cell types can this be achieved? Note: There are 2 correct Answers to this question.

QUESTION 49
What kind of cold data tiering options do you have with SAP BW/4HANA? Note: There are 2 correct Answers to this question.

QUESTION 50
You identified a variable that is based on time characteristic OCALMONTH and returns the current quarter. Which offset do you need to retrieve the corresponding quarter of the previous year?

QUESTION 51
You need to determine the number of customers in each country that have revenue in 2018. What is the reference InfoObject in an exception aggregation?

QUESTION 52
You want to build an SAP HANA calculation view of data category CUBE, but you get the “no measure defined” error. For the business requirement, a measure does not make sense. Besides changing the data category to DIMENSION, what do you have to do?

QUESTION 53
You are following a top-down method for your SAP BW/4HANA modeling project. What would be your first task?

QUESTION 54
Which features does SAP Analysis for Microsoft Office provide? (3)

QUESTION 55
Which properties determine the delta process within the Operational Data Provisioning (ODP) delta management for DataSources?
Note: There are 2 correct answers to this question.

QUESTION 56
Which SAP BW/4HANA objects can be used as sources of a data transfer process (DTP) ? Note: There are
3 correct Answers to this question.

QUESTION 57
You want to model an SAP HANA calculation view by combining the sales orders with the corresponding customer status, which was assigned to the customer when the order was issued. Which join properties do you assign to the required join type?

QUESTION 58
Where Can you automatically generate a process chain? (1)

QUESTION 59
You use SAP HANA to integrate an HDI Calculation View (data category Dimension) into another HDI Calculation View (data category Cube with Star Join). What do you need to do before you can integrate the HDI Calculation View (data category Dimension)?

QUESTION 60
What are the possible ways to fill a pre-calculated value set (bucket)? Note: There are 3 correct Answers to this question.