nerdexam
SAP

C_BOWI_40 · Question #159

Which three output context expressions are valid extended syntax expressions? (Choose three.)

The correct answer is A. Where ([State] = "CA") D. In Section Where ([State] = "CA") E. Where ([State]="CA" And [Year] ="2006"). SAP Web Intelligence extended syntax supports Where conditions, In-context qualifiers, and combined In-Where expressions as valid output context operators.

Using Formulas and Variables

Question

Which three output context expressions are valid extended syntax expressions? (Choose three.)

Options

  • AWhere ([State] = "CA")
  • BWhere Section In [State]
  • CIn Block Where Section = [State]
  • DIn Section Where ([State] = "CA")
  • EWhere ([State]="CA" And [Year] ="2006")

How the community answered

(59 responses)
  • A
    71% (42)
  • B
    17% (10)
  • C
    12% (7)

Why each option

SAP Web Intelligence extended syntax supports Where conditions, In-context qualifiers, and combined In-Where expressions as valid output context operators.

AWhere ([State] = "CA")Correct

Where ([State] = "CA") is valid extended syntax because the Where keyword followed by a Boolean condition in parentheses is a supported pattern for filtering the output context of a measure.

BWhere Section In [State]

Where Section In [State] is invalid extended syntax because 'Section' cannot act as an operand inside a Where condition in this form - In must reference a named report structure context such as a block or section, not follow a Where clause.

CIn Block Where Section = [State]

In Block Where Section = [State] is invalid because the Where clause in extended syntax requires a Boolean comparison against a literal value, not a comparison between two context keywords or dimension objects using the equals operator.

DIn Section Where ([State] = "CA")Correct

In Section Where ([State] = "CA") is valid because 'In Section' is a recognized context keyword that scopes the calculation to the current section, and the Where clause further restricts that context using a valid Boolean condition.

EWhere ([State]="CA" And [Year] ="2006")Correct

Where ([State]="CA" And [Year]="2006") is valid because the Where clause supports compound Boolean conditions joined with logical operators such as And, allowing multiple dimension filters in a single expression.

Concept tested: Web Intelligence extended syntax output context expressions

Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/SAP_BusinessObjects_Web_Intelligence_Rich_Client_Users_Guide/Extended-syntax-keywords-in-Web-Intelligence

Topics

#output context#extended syntax#Where clause#In Section

Community Discussion

No community discussion yet for this question.

Full C_BOWI_40 Practice