C_BOWI_40 · Question #47
Which Pos() function syntax should you use to find the location of the space in the Category string "Evening wear"?
The correct answer is C. Pos([Category] ; " " ). Web Intelligence formula syntax requires square brackets for object references and semicolons as argument separators inside functions.
Question
Which Pos() function syntax should you use to find the location of the space in the Category string "Evening wear"?
Options
- APos([Category] , "" )
- BPos((Category) , "" )
- CPos([Category] ; " " )
- DPos({Category} ; " " )
How the community answered
(18 responses)- A6% (1)
- B6% (1)
- C78% (14)
- D11% (2)
Why each option
Web Intelligence formula syntax requires square brackets for object references and semicolons as argument separators inside functions.
This syntax uses a comma as the argument separator instead of the required semicolon, which is invalid in Web Intelligence formula language.
This syntax wraps the object name in parentheses instead of square brackets and also uses a comma separator, making both the object reference and delimiter incorrect.
In SAP Web Intelligence, report objects such as dimensions must be enclosed in square brackets (e.g. [Category]), and function arguments are delimited by semicolons rather than commas. Pos([Category]; " ") correctly identifies the position of the space character within the string 'Evening wear'.
Double curly braces are not valid syntax for referencing report objects in Web Intelligence; square brackets are required.
Concept tested: Web Intelligence Pos() function syntax for string search
Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/af135fd0571649c9ad35c8aab4490ef6/46d28c946e041014910aba7db0e91070.html
Topics
Community Discussion
No community discussion yet for this question.