C_BOWI_40 · Question #159
Which three output context expressions are valid extended syntax expressions? (Choose three.)
The correct answer is A. Where ([State] = "CA") D. In Section Where ([State] = "CA") E. Where ([State]="CA" And [Year] ="2006"). SAP Web Intelligence extended syntax supports Where conditions, In-context qualifiers, and combined In-Where expressions as valid output context operators.
Question
Which three output context expressions are valid extended syntax expressions? (Choose three.)
Options
- AWhere ([State] = "CA")
- BWhere Section In [State]
- CIn Block Where Section = [State]
- DIn Section Where ([State] = "CA")
- EWhere ([State]="CA" And [Year] ="2006")
How the community answered
(59 responses)- A71% (42)
- B17% (10)
- C12% (7)
Why each option
SAP Web Intelligence extended syntax supports Where conditions, In-context qualifiers, and combined In-Where expressions as valid output context operators.
Where ([State] = "CA") is valid extended syntax because the Where keyword followed by a Boolean condition in parentheses is a supported pattern for filtering the output context of a measure.
Where Section In [State] is invalid extended syntax because 'Section' cannot act as an operand inside a Where condition in this form - In must reference a named report structure context such as a block or section, not follow a Where clause.
In Block Where Section = [State] is invalid because the Where clause in extended syntax requires a Boolean comparison against a literal value, not a comparison between two context keywords or dimension objects using the equals operator.
In Section Where ([State] = "CA") is valid because 'In Section' is a recognized context keyword that scopes the calculation to the current section, and the Where clause further restricts that context using a valid Boolean condition.
Where ([State]="CA" And [Year]="2006") is valid because the Where clause supports compound Boolean conditions joined with logical operators such as And, allowing multiple dimension filters in a single expression.
Concept tested: Web Intelligence extended syntax output context expressions
Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/SAP_BusinessObjects_Web_Intelligence_Rich_Client_Users_Guide/Extended-syntax-keywords-in-Web-Intelligence
Topics
Community Discussion
No community discussion yet for this question.