nerdexam
SAP

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.

Using Formulas and Variables

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)
  • A
    5% (2)
  • B
    8% (3)
  • C
    20% (8)
  • D
    68% (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.

AYou include the dimension using the input context.

The input context filters the rows considered before aggregation - including a dimension there would not fix the output aggregation level.

BYou exclude the dimension using the input context.

Excluding a dimension from the input context restricts which rows feed the calculation, which changes filtering behavior rather than fixing the aggregation granularity.

CYou include the dimension using the output context.

Including a dimension in the output context forces the variable to aggregate at a finer level, which is the opposite of the desired behavior.

DYou exclude the dimension using the output context.Correct

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

#output context#calculation context#dimension exclusion#context operators

Community Discussion

No community discussion yet for this question.

Full C_BOWI_40 Practice