C_BOWI_40 · Question #11
You have a regional sales report with State, City and Sales Revenue dimensions. You want to create a variable that excludes State from the output context. Which output statement should you use?
The correct answer is C. ForAll([State]). The ForAll keyword in WebI output context syntax explicitly removes a named dimension from the calculation context, forcing the measure to be computed across all values of that dimension.
Question
You have a regional sales report with State, City and Sales Revenue dimensions. You want to create a variable that excludes State from the output context. Which output statement should you use?
Options
- AIn([State])
- BOut([State])
- CForAll([State])
- DForEach([State])
How the community answered
(69 responses)- A4% (3)
- B3% (2)
- C83% (57)
- D10% (7)
Why each option
The ForAll keyword in WebI output context syntax explicitly removes a named dimension from the calculation context, forcing the measure to be computed across all values of that dimension.
In([State]) is not a valid standalone context operator in WebI extended syntax - In is used in a different positional role within the full context expression, not to exclude dimensions.
Out([State]) is not a valid WebI context keyword - the correct keyword for excluding dimensions from the output context is ForAll, not Out.
ForAll([State]) is the correct WebI extended syntax keyword to exclude a dimension from the output context of a variable. By specifying ForAll([State]), the aggregation ignores State-level breaks and computes the measure across all states, effectively removing State from the context in which the result is calculated.
ForEach([State]) does the opposite of what is required - it explicitly includes State in the output context rather than excluding it.
Concept tested: WebI ForAll output context operator
Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/8ac79e42-5f44-4f26-bb3b-3ac0900d1c78/46a6ec0776f21014b98df3c5d3c98fcc.html
Topics
Community Discussion
No community discussion yet for this question.