nerdexam
SAP

C_BOWI_40 · Question #49

You need to create a report displaying a year-to-date aggregation on sales revenue across all months. The report should be sectioned on Region. Additionally, you would like to reset the running…

The correct answer is C. =RunningSum([Sales Revenue] ; ([Region])). This question tests knowledge of the correct SAP BusinessObjects Web Intelligence RunningSum function syntax, including the proper parameter separator and reset dimension format.

Using Formulas and Variables

Question

You need to create a report displaying a year-to-date aggregation on sales revenue across all months. The report should be sectioned on Region. Additionally, you would like to reset the running aggregation to restart for each Region. Which syntax should you use to accomplish this task?

Options

  • A=RunningSum([Sales Revenue], Region)
  • B=RunningTotal([Sales Revenue], Region)
  • C=RunningSum([Sales Revenue] ; ([Region]))
  • D=RunningTotal([Sales Revenue], Reset[Region])

How the community answered

(27 responses)
  • A
    11% (3)
  • B
    4% (1)
  • C
    78% (21)
  • D
    7% (2)

Why each option

This question tests knowledge of the correct SAP BusinessObjects Web Intelligence RunningSum function syntax, including the proper parameter separator and reset dimension format.

A=RunningSum([Sales Revenue], Region)

Although RunningSum is the correct function name, using a comma as the separator and omitting parentheses around Region is invalid WebI formula syntax for specifying a reset dimension.

B=RunningTotal([Sales Revenue], Region)

RunningTotal is not a valid SAP BusinessObjects Web Intelligence function; the correct cumulative aggregation function is RunningSum.

C=RunningSum([Sales Revenue] ; ([Region]))Correct

RunningSum is the valid WebI function for cumulative aggregations, and the semicolon is the correct parameter separator in WebI formula syntax. The reset dimension [Region] must be enclosed in parentheses as the second argument, which causes the running total to restart for each new Region section, producing the desired year-to-date behavior per region.

D=RunningTotal([Sales Revenue], Reset[Region])

RunningTotal is not a valid WebI function, and the Reset[Region] keyword construct is not recognized WebI formula syntax for specifying a reset dimension.

Concept tested: WebI RunningSum function syntax with reset dimension

Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/ad8e1cb39f564e3788e5b5b9d3d3df74/46cd4f5b6e041014910eba7adeb4df22.html

Topics

#RunningSum#running aggregation#reset context#sections

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full C_BOWI_40 Practice