nerdexam
SAP

C_BOWI_40 · Question #144

Which two are running aggregate functions in Web Intelligence? (Choose two.)

The correct answer is A. RunningMax() B. RunningSum(). Web Intelligence includes a specific set of running aggregate functions; RunningMax() and RunningSum() are valid built-in functions, while RunningTotal() and RunningMean() do not exist in the library.

Using Formulas and Variables

Question

Which two are running aggregate functions in Web Intelligence? (Choose two.)

Options

  • ARunningMax()
  • BRunningSum()
  • CRunningTotal()
  • DRunningMean()

How the community answered

(27 responses)
  • A
    85% (23)
  • C
    11% (3)
  • D
    4% (1)

Why each option

Web Intelligence includes a specific set of running aggregate functions; RunningMax() and RunningSum() are valid built-in functions, while RunningTotal() and RunningMean() do not exist in the library.

ARunningMax()Correct

RunningMax() is a standard Web Intelligence running aggregate function that progressively calculates the maximum value seen so far as it iterates across report rows.

BRunningSum()Correct

RunningSum() is a standard Web Intelligence running aggregate function that calculates a cumulative sum incrementally across report rows.

CRunningTotal()

RunningTotal() is not a valid Web Intelligence function; cumulative totals are computed using RunningSum(), which is the correct built-in function name.

DRunningMean()

RunningMean() is not a valid Web Intelligence function; progressive average calculations are performed using RunningAverage(), the correct built-in function name.

Concept tested: Web Intelligence running aggregate functions

Source: https://help.sap.com/viewer/ad62de02-ba29-44fb-88c3-2cb1a7f5c659/4.2/en-US

Topics

#RunningMax()#RunningSum()#running aggregates#aggregate functions

Community Discussion

No community discussion yet for this question.

Full C_BOWI_40 Practice