nerdexam
SAP

C_BOWI_40 · Question #149

Which statement is true of an output context operator?

The correct answer is D. It is placed outside of the brackets of the aggregation function. In SAP Web Intelligence, the output context operator modifies the calculation context of an aggregation and is written after the aggregation function, outside its brackets.

Using Formulas and Variables

Question

Which statement is true of an output context operator?

Options

  • AIt is placed within the brackets of the dimension list.
  • BIt is placed outside of the brackets of the dimension list.
  • CIt is placed within the brackets of the aggregation function.
  • DIt is placed outside of the brackets of the aggregation function.

How the community answered

(17 responses)
  • A
    6% (1)
  • B
    6% (1)
  • D
    88% (15)

Why each option

In SAP Web Intelligence, the output context operator modifies the calculation context of an aggregation and is written after the aggregation function, outside its brackets.

AIt is placed within the brackets of the dimension list.

The dimension list uses brackets, but the output context operator itself is not placed within those brackets - the dimensions are listed inside the operator's own bracket set.

BIt is placed outside of the brackets of the dimension list.

Being placed outside the dimension list brackets describes the operator keyword position relative to its own argument list, which does not answer where it sits relative to the aggregation function.

CIt is placed within the brackets of the aggregation function.

The brackets of the aggregation function contain the measure expression (e.g., [Sales]), not the context operator; placing a context operator inside would produce a syntax error.

DIt is placed outside of the brackets of the aggregation function.Correct

The output context operator (In, ForEach, ForAll) is placed outside and after the closing bracket of the aggregation function. For example, the correct syntax is Sum([Sales]) In ([Country]), where 'In ([Country])' follows the function's closing bracket, overriding the default output context for that calculation.

Concept tested: Web Intelligence extended syntax output context operator placement

Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/1ca10a0e77fe4b6a8e00f3b60fdaf9fa/4687e6b96e041014910aba7db0e91070.html

Topics

#output context operator#extended syntax#aggregation functions#context syntax

Community Discussion

No community discussion yet for this question.

Full C_BOWI_40 Practice