nerdexam
SAP

C_BOWI_40 · Question #39

Which two functions could you use to concatenate the First Name and Last Name objects?

The correct answer is A. =[First Name]+[Last Name] D. =Concatenation([First Name];[Last Name]). In Web Intelligence, string concatenation is achieved using either the + operator or the Concatenation() function with a semicolon as the argument separator.

Using Formulas and Variables

Question

Which two functions could you use to concatenate the First Name and Last Name objects?

Options

  • A=[First Name]+[Last Name]
  • B=[First Name]&[Last Name]
  • C=[First Name]||[Last Name]
  • D=Concatenation([First Name];[Last Name])
  • E=Concatenation([First Name],[Last Name])

How the community answered

(26 responses)
  • A
    92% (24)
  • B
    4% (1)
  • C
    4% (1)

Why each option

In Web Intelligence, string concatenation is achieved using either the + operator or the Concatenation() function with a semicolon as the argument separator.

A=[First Name]+[Last Name]Correct

The + operator in Web Intelligence works on string objects to concatenate them directly, making =[First Name]+[Last Name] a valid formula for joining two string dimensions.

B=[First Name]&[Last Name]

The & operator is not a valid string concatenation operator in Web Intelligence formula syntax; it is used in environments like Microsoft Excel or VBA.

C=[First Name]||[Last Name]

The || operator is SQL concatenation syntax and is not recognized as a valid operator in the Web Intelligence formula language.

D=Concatenation([First Name];[Last Name])Correct

The Concatenation() function is the explicit built-in function for joining strings, and Web Intelligence uses a semicolon (;) as the argument separator in formulas - not a comma - making =Concatenation([First Name];[Last Name]) the correct function syntax.

E=Concatenation([First Name],[Last Name])

Web Intelligence uses semicolons as argument delimiters in functions, not commas; using a comma in Concatenation([First Name],[Last Name]) results in a syntax error.

Concept tested: Web Intelligence string concatenation operators and functions

Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/8d49b4f7e3474d7bb5945d636e38c6c1/46d41e306e041014910eba7ea8d1f3e5.html

Topics

#concatenation#string functions#formula syntax#text operators

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full C_BOWI_40 Practice