C_BOWI_40 · Question #149
Which statement is true of an output context operator?
The correct answer is D. It is placed outside of the brackets of the aggregation function. In SAP Web Intelligence, the output context operator modifies the calculation context of an aggregation and is written after the aggregation function, outside its brackets.
Question
Which statement is true of an output context operator?
Options
- AIt is placed within the brackets of the dimension list.
- BIt is placed outside of the brackets of the dimension list.
- CIt is placed within the brackets of the aggregation function.
- DIt is placed outside of the brackets of the aggregation function.
How the community answered
(17 responses)- A6% (1)
- B6% (1)
- D88% (15)
Why each option
In SAP Web Intelligence, the output context operator modifies the calculation context of an aggregation and is written after the aggregation function, outside its brackets.
The dimension list uses brackets, but the output context operator itself is not placed within those brackets - the dimensions are listed inside the operator's own bracket set.
Being placed outside the dimension list brackets describes the operator keyword position relative to its own argument list, which does not answer where it sits relative to the aggregation function.
The brackets of the aggregation function contain the measure expression (e.g., [Sales]), not the context operator; placing a context operator inside would produce a syntax error.
The output context operator (In, ForEach, ForAll) is placed outside and after the closing bracket of the aggregation function. For example, the correct syntax is Sum([Sales]) In ([Country]), where 'In ([Country])' follows the function's closing bracket, overriding the default output context for that calculation.
Concept tested: Web Intelligence extended syntax output context operator placement
Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/1ca10a0e77fe4b6a8e00f3b60fdaf9fa/4687e6b96e041014910aba7db0e91070.html
Topics
Community Discussion
No community discussion yet for this question.