C_BOWI_40 · Question #10
Which function would you use to extract the word "pants" from the product name "casual pants" of the Product Name field?
The correct answer is B. Right([Product Name]; 5). The WebI Right() function extracts a specified number of characters from the right side of a string, using semicolons as argument separators and square brackets around field names.
Question
Which function would you use to extract the word "pants" from the product name "casual pants" of the Product Name field?
Options
- ARight(5; [Product Name])
- BRight([Product Name]; 5)
- CRight((Product Name), 5)
- DRight(5, [Product Name])
How the community answered
(57 responses)- A5% (3)
- B89% (51)
- C4% (2)
- D2% (1)
Why each option
The WebI Right() function extracts a specified number of characters from the right side of a string, using semicolons as argument separators and square brackets around field names.
Right(5; [Product Name]) reverses the required argument order - the string field must be the first argument and the character count must be the second.
Right([Product Name]; 5) uses the correct SAP Web Intelligence syntax - square brackets around the dimension name, a semicolon as the argument separator, and the character count as the second argument. Applied to 'casual pants', this returns the rightmost 5 characters, which is 'pants'.
Right((Product Name), 5) uses incorrect syntax on two counts: field names in WebI must be enclosed in square brackets, not parentheses, and arguments must be separated by a semicolon, not a comma.
Right(5, [Product Name]) has both reversed argument order and uses a comma as the separator instead of the required semicolon.
Concept tested: WebI Right() string function syntax
Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/8ac79e42-5f44-4f26-bb3b-3ac0900d1c78/46a6e0dc76f21014b7e0b78f6bab16c7.html
Topics
Community Discussion
No community discussion yet for this question.