nerdexam
SAP

C_BOWI_40 · Question #112

Which function would you use to extract the word "casual" from the product name "casual pants" of the Product Name field?

The correct answer is B. Left([Product Name]; 5). The Web Intelligence Left() function requires the string argument first and the character count second, separated by a semicolon, with field names enclosed in square brackets.

Using Formulas and Variables

Question

Which function would you use to extract the word "casual" from the product name "casual pants" of the Product Name field?

Options

  • ALeft(5; [Product Name])
  • BLeft([Product Name]; 5)
  • CRight((Product Name), 5)
  • DRight(5, [Product Name])

How the community answered

(60 responses)
  • A
    10% (6)
  • B
    83% (50)
  • C
    2% (1)
  • D
    5% (3)

Why each option

The Web Intelligence Left() function requires the string argument first and the character count second, separated by a semicolon, with field names enclosed in square brackets.

ALeft(5; [Product Name])

Left(5; [Product Name]) reverses the required parameter order - the string field reference must be the first argument and the numeric character count must be the second.

BLeft([Product Name]; 5)Correct

Left([Product Name]; 5) is the only option with correct Web Intelligence formula syntax - the field reference in square brackets is the first parameter, the numeric length is the second parameter, and a semicolon serves as the argument delimiter as required by the Web Intelligence formula language. While the value 5 extracts only the first 5 characters, this option is correct in demonstrating the required syntax and function selection.

CRight((Product Name), 5)

Right((Product Name), 5) uses the wrong function since Right() extracts characters from the end of a string, and it incorrectly uses parentheses instead of square brackets for the field reference and a comma instead of a semicolon as the delimiter.

DRight(5, [Product Name])

Right(5, [Product Name]) uses the wrong function and places the numeric argument before the string field reference, violating the required parameter order.

Concept tested: Web Intelligence Left() string function syntax and parameter order

Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM

Topics

#Left function#string functions#text extraction#syntax

Community Discussion

No community discussion yet for this question.

Full C_BOWI_40 Practice