nerdexam
SAP

C_BOWI_40 · Question #58

Which three statements are true of calculation contexts?

The correct answer is A. If no context is defined the default context is assumed. C. The ForEach context operator automatically takes the dimensions in the block into account. D. You must place parentheses around the values listed after the Where keyword when using the. Calculation contexts in Web Intelligence govern aggregation scope and have specific rules for default behavior, the ForEach operator, and Where keyword syntax.

Using Formulas and Variables

Question

Which three statements are true of calculation contexts?

Options

  • AIf no context is defined the default context is assumed.
  • BYou can use NoFilter() as an extended syntax keyword when using contexts.
  • CThe ForEach context operator automatically takes the dimensions in the block into account.
  • DYou must place parentheses around the values listed after the Where keyword when using the

How the community answered

(26 responses)
  • A
    65% (17)
  • B
    35% (9)

Why each option

Calculation contexts in Web Intelligence govern aggregation scope and have specific rules for default behavior, the ForEach operator, and Where keyword syntax.

AIf no context is defined the default context is assumed.Correct

When no explicit context is defined, Web Intelligence automatically applies the default context, which uses all dimensions present in the current block as both the input and output context for the measure.

BYou can use NoFilter() as an extended syntax keyword when using contexts.

NoFilter() is a function used to remove active report filters from a calculation result, not an extended syntax keyword valid for use within calculation context definitions.

CThe ForEach context operator automatically takes the dimensions in the block into account.Correct

The ForEach operator extends the default output context by adding specified dimensions, and it automatically incorporates all dimensions already present in the block into the calculation scope.

DYou must place parentheses around the values listed after the Where keyword when using theCorrect

When using the Where keyword to restrict a calculation context, the dimension values specified after it must be enclosed in parentheses to correctly delimit the filter criteria for the context engine.

Concept tested: Web Intelligence extended syntax and calculation context rules

Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/8afd7e2c8b2e43a69153ac65a1e0b55e/46d49c396e4c7014e10000000a114a6b.html

Topics

#calculation contexts#ForEach operator#default context#Where keyword

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full C_BOWI_40 Practice