nerdexam
SAP

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.

Using Formulas and Variables

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)
  • A
    4% (3)
  • B
    3% (2)
  • C
    83% (57)
  • D
    10% (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.

AIn([State])

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.

BOut([State])

Out([State]) is not a valid WebI context keyword - the correct keyword for excluding dimensions from the output context is ForAll, not Out.

CForAll([State])Correct

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.

DForEach([State])

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

#ForAll operator#output context#calculation context#dimension exclusion

Community Discussion

No community discussion yet for this question.

Full C_BOWI_40 Practice