C_BOWI_40 · Question #46
You want to force the calculation context of a variable in a table so thatits values do not change when adimension is added to the table. Which of the following statements is correct?
The correct answer is D. You exclude the dimension using the output context. To prevent a variable from re-aggregating when a new dimension is added to a table, you must exclude that dimension from the variable's output context.
Question
You want to force the calculation context of a variable in a table so thatits values do not change when adimension is added to the table. Which of the following statements is correct?
Options
- AYou include the dimension using the input context.
- BYou exclude the dimension using the input context.
- CYou include the dimension using the output context.
- DYou exclude the dimension using the output context.
How the community answered
(40 responses)- A5% (2)
- B8% (3)
- C20% (8)
- D68% (27)
Why each option
To prevent a variable from re-aggregating when a new dimension is added to a table, you must exclude that dimension from the variable's output context.
The input context filters the rows considered before aggregation - including a dimension there would not fix the output aggregation level.
Excluding a dimension from the input context restricts which rows feed the calculation, which changes filtering behavior rather than fixing the aggregation granularity.
Including a dimension in the output context forces the variable to aggregate at a finer level, which is the opposite of the desired behavior.
The output context determines which dimensions a measure uses when aggregating. By explicitly excluding a dimension from the output context using syntax such as [Measure] In ([Dim1]), the variable ignores any additional dimensions added to the table, keeping its aggregated value fixed regardless of the table's structure.
Concept tested: Fixing variable aggregation using output context exclusion
Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/af135fd0571649c9ad35c8aab4490ef6/46d82c946e041014910aba7db0e91070.html
Topics
Community Discussion
No community discussion yet for this question.