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.
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)- A10% (6)
- B83% (50)
- C2% (1)
- D5% (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.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.