nerdexam
SAP

C_BOWI_40 · Question #75

Which two operators are used as calculation context operators?

The correct answer is A. In B. Where. In Web Intelligence, 'In' and 'Where' are the two operators used as calculation context operators to control how measures are aggregated.

Using Formulas and Variables

Question

Which two operators are used as calculation context operators?

Options

  • AIn
  • BWhere
  • CSelec
  • DHaving

How the community answered

(53 responses)
  • A
    91% (48)
  • C
    6% (3)
  • D
    4% (2)

Why each option

In Web Intelligence, 'In' and 'Where' are the two operators used as calculation context operators to control how measures are aggregated.

AInCorrect

The 'In' operator is a calculation context operator used to explicitly define the set of dimensions within which a measure is calculated, overriding the default block context.

BWhereCorrect

The 'Where' operator is a calculation context operator used to apply a filter condition within a formula, restricting the rows included in the calculation without changing the report structure.

CSelec

'Selec' is not a valid Web Intelligence formula operator; it appears to be a misspelling and has no role in calculation context syntax.

DHaving

'Having' is an aggregate filter keyword used in SQL and in Web Intelligence query filters, but it is not a calculation context operator used within formulas.

Concept tested: Web Intelligence calculation context operators In and Where

Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM

Topics

#calculation context operators#In operator#Where operator#formula syntax

Community Discussion

No community discussion yet for this question.

Full C_BOWI_40 Practice