nerdexam
SAP

C_BOWI_40 · Question #140

Which three calculations can you use in a measure object in Web Intelligence?

The correct answer is A. Min B. Max C. Count. Web Intelligence supports Min, Max, and Count as standard calculations available for measure objects in a report.

Working with Data

Question

Which three calculations can you use in a measure object in Web Intelligence?

Options

  • AMin
  • BMax
  • CCount
  • DCount All

How the community answered

(46 responses)
  • A
    89% (41)
  • D
    11% (5)

Why each option

Web Intelligence supports Min, Max, and Count as standard calculations available for measure objects in a report.

AMinCorrect

Min is a standard aggregation function available for measure objects in Web Intelligence, returning the minimum value across the aggregated dimension members.

BMaxCorrect

Max is a standard aggregation function available for measure objects, returning the maximum value across the aggregated dimension members.

CCountCorrect

Count is a standard aggregation function for measure objects that counts the number of rows or non-null values associated with the measure.

DCount All

Count All is not a distinct or separately named calculation available for measure objects in Web Intelligence - Count already handles all-row counting, and 'Count All' does not exist as a separate built-in aggregation option.

Concept tested: Web Intelligence measure object standard calculation functions

Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/8e56e1e4-1f60-4fba-8acb-d9a05a0a6c24/Aggregate-functions-in-Web-Intelligence.html

Topics

#measure objects#calculations#Min Max Count#aggregation

Community Discussion

No community discussion yet for this question.

Full C_BOWI_40 Practice