What are the key steps to implement currency conversion in a calculation view?

• A.Assign semantic type
  Enable the measure for conversion
  Choose client, source and target currencies Choose conversion date and rate type
• B.Enable the measure for conversion
  Choose client, source and target currencies Choose conversion date and rate type Assign the conversion rule to your calculation view
• C.Assign semantic type
  Choose client, source and target currencies Choose conversion date and rate type Define an expression in a calculated column
• D.Enable the measure for conversion
  Choose client, source and target currencies Choose conversion date and rate type Build the conversion rule

Comment: *

Name: *

Email: *

Verification: *

Your Web IDE for SAP HANA was updated to a new version. You want to implement the new features of calculation view modeling in your existing calculation views. You open a graphical calculation view but the new features are not displayed.
What could be the reason for this?

• A.You need to update the project settings to reference the new revision.
• B.Your calculation views have not been built in the new version of the Web IDE.
• C.The .hdiconfig file has not been updated to the latest calculation view build plug-in.
• D.The calculation views have not been migrated to the new revision.

Comment: *

Name: *

Email: *

Verification: *

You are building a cube calculation view with an aggregation node that calculates total sales, based on the data shown in the graphic.

The price may vary based on SHIRT_ID and PROMO_LEVEL only. The calculation is Total Sales = PRICE * QUANTITY.
How do you ensure accurate results, regardless of the columns in the query output?
Please choose the correct answer.
Response:

• A.Set the Keep Flag property for SHIRT_ID
• B.Set the Keep Flag property for SHIRT_ID and PROMO_LEVEL.
• C.Set the Calculate before Aggregation property.
• D.Set the Dynamic Partition property for SHIRT_ID and PROMO_LEVEL.

Comment: *

Name: *

Email: *

Verification: *

Which interface client is used for XSA application development?
Please choose the correct answer.
Response:

• A.SAP Web IDE for SAP HANA
• B.SAP HANA Studio
• C.SAP Web IDE
• D.SAP HANA Web-based Workbench

Comment: *

Name: *

Email: *

Verification: *

How can you optimize performance when writing SOL for use with calculation views? Note:There are 2 correct answers to this question.

• A.Increase parallelization by using variables to break up statements
• B.Control the flow logic using IF-THEN-ELSE conditions
• C.Use calculation engine (CE) functions instead of plain SOL
• D.Use declarative language instead of cursors

Comment: *

Name: *

Email: *

Verification: *