nerdexam
SAP

C_BOWI_40 · Question #147

You are creating a report to summarize the number of cars sold by region. Which object should you use to aggregate the number of cars sold?

The correct answer is C. Measure. In SAP BusinessObjects Web Intelligence, a Measure object represents a numeric fact that supports aggregation functions like sum and count, making it the correct object type for quantifying cars sold.

Creating Documents with Queries

Question

You are creating a report to summarize the number of cars sold by region. Which object should you use to aggregate the number of cars sold?

Options

  • ASum
  • BDetail
  • CMeasure
  • DDimension

How the community answered

(18 responses)
  • A
    6% (1)
  • C
    89% (16)
  • D
    6% (1)

Why each option

In SAP BusinessObjects Web Intelligence, a Measure object represents a numeric fact that supports aggregation functions like sum and count, making it the correct object type for quantifying cars sold.

ASum

Sum is an aggregation function that can be applied to a Measure, not an object type you place in a report query.

BDetail

A Detail object provides descriptive attributes associated with a Dimension and cannot be aggregated numerically.

CMeasureCorrect

A Measure is a universe object that holds numeric, quantitative data and is designed to be aggregated across dimension values. When summarizing cars sold by region, a Measure automatically applies its defined aggregation function (such as Sum) to roll up values per regional grouping.

DDimension

A Dimension object categorizes data (such as Region) and does not store numeric facts intended for aggregation.

Concept tested: Web Intelligence Measure object type for numeric aggregation

Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/1a61583f-f2a5-4928-a9e7-a35f8b849dc7/4610dfb86e041014910sce01.html

Topics

#measure objects#aggregation#dimension vs measure#object types

Community Discussion

No community discussion yet for this question.

Full C_BOWI_40 Practice