глава 7 7

In which type of node can you create calculated columns? (There are 2 correct answers.). Rank node. Union node. Join node. Projection node.

You want to build a hierarchy on a time-based data structure. What type of hierarchy do you use?. Parent-child hierarchy. Level hierarchy. Ragged hierarchy. Unbalanced hierarchy.

Which are features of a calculated column? (There are 2 correct answers.). It is a column in the result set. Its calculations are persisted. It is created in the output area. It is created in the semantics node.

You want to show a male and female option to users. What feature do you use? (There are 3 correct answers.). Domain fix values. Value help. Variables. Expressions. Input parameters.

You are creating a currency conversion. What options do you have for the Target Currency field? (There are 3 correct answers.). Select a fixed currency. Select a column. Use the Derived from Table option. Use an input parameter. Select a table type.

What can you use as data sources for a decision table? (There are 2 correct answers.). Table types. Scalar functions. CDS views. Calculation views.

Where do you create a variable?. In the context menu of a package. In the semantics node. In the output area of a join node. In the scenario area of an aggregate node.

You have logs from a website. How do you show the total number of website visitors that used a mobile phone? (There are 2 correct answers.). Create a restricted column. Create an action. Create a filter expression. Create a rank column.

Which can a level hierarchy do?. Have time-dependency. Be used for a bill of materials structure. Enable drill-down in a value help list. Show variable deepness in the data.

What can a variable be used for?. Currency conversion. Calculated column expression. Call decision table in SQLScript. Filtering.

You are working with a currency measure. What is decimal shift used for?. Increase the accuracy of the currency conversion. To undo the decimal adjustment for ABAP. For currencies with more than two decimal places. Avoid rounding errors during the conversion.

What variable type do you use if you want to allow the user to choose dates from 2011 to 2014?. Single value. Interval. Range. Multiple entries.

What do you create to find the number of unique items sold per shop?. A calculation view with a restricted column in an aggregation node. A calculation view with a counter in a projection node. A calculation view with a counter in an aggregation node. An analytic view with a calculated column in an star join node.

What artifacts do you use in the output area of a decision table node? (There are 2 correct answers.). Input parameters. Restrictions. Actions. Conditions.

What can you use to limit the number of records produced by a calculation view? (There are 3 correct answers.). SAP client restrictions. Domain fix values. Filter expressions. Restricted columns. Generated columns.

You created a calculated column in an analytic view for a table containing the number of units ordered, the price per unit, and the number of units in stock. You get the wrong results in your results. What could be the problem?. You mistyped the calculated column expression. You chose the SQL expression syntax. You did NOT enable calculate before aggregation. You did NOT enable the currency conversion.

Where can you create a filter expression?. In an aggregation node. In a data foundation node. In a projection node. In the semantics node.

The company’s board members want to run simulations on the year-end financial data. What do you use to build this for them?. A parent-child hierarchy. A variable. An expression. A decision table.

Which tables do you need for currency conversion?. DD07*. TCUR*. BICS*. SHINE*.

You build a financial report for the company’s board members that allows them to choose if they want the report to be in euros or dollars. What do you use?. An input parameter from an aggregation node. A variable from the semantics node. A variable from a projection node. An input parameter from the semantics node.

What type of input parameters do you use to choose the data from a field in the current table?. Direct. Derived from table. Value help. Column.