C_BOWI_40 · Question #38
You want to force the calculation context for a variable in a large report with many dimensions. Which operator allows you to add a dimension to the default context?
The correct answer is D. ForEach. The ForEach operator in Web Intelligence extends the default calculation context by explicitly adding one or more dimensions to the measure's aggregation scope.
Question
You want to force the calculation context for a variable in a large report with many dimensions. Which operator allows you to add a dimension to the default context?
Options
- AIn
- BAll
- CForAll
- DForEach
How the community answered
(34 responses)- A6% (2)
- B12% (4)
- C3% (1)
- D79% (27)
Why each option
The ForEach operator in Web Intelligence extends the default calculation context by explicitly adding one or more dimensions to the measure's aggregation scope.
The In operator restricts the calculation context to only the dimensions explicitly listed, rather than adding dimensions to an existing default context.
The All operator instructs WebI to use all available dimensions in the universe context, rather than selectively adding a specific dimension.
The ForAll operator removes specified dimensions from the calculation context, producing a less granular result rather than a more detailed one.
The ForEach operator forces a measure to be calculated at a more granular level by adding specified dimensions to the default output context. For example, using ForEach([Country]) on a sum forces that sum to be broken down per country, even in a block that does not include the Country dimension. This is the correct operator when you want to expand - not restrict - the calculation context.
Concept tested: Web Intelligence ForEach operator calculation context extension
Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/8d49b4f7e3474d7bb5945d636e38c6c1/46d3f1906e041014910eba7ea8d1f3e5.html
Topics
Community Discussion
No community discussion yet for this question.