nerdexam
Oracle

1Z0-531 · Question #20

You are trying to create a multidimensional model for Essbase and learn that your user wants to track commission for his sales persons, in addition to tracking sale by regions. When designing a…

The correct answer is D. Sales E. Year to Date. Dimensions, hierarchies, members, levels, and attributes form the structure of a cube. The data comes from measures. Measures represent business data that is important for analysis, such as sales and cost of goods sold. Measure values are the data that fills the intersections…

Creating and Managing Cubes

Question

You are trying to create a multidimensional model for Essbase and learn that your user wants to track commission for his sales persons, in addition to tracking sale by regions. When designing a multidimensional model, which two elements will serve as facts (measures)?

Options

  • ASales person
  • BCommission
  • CNew York
  • DSales
  • EYear to Date

How the community answered

(22 responses)
  • A
    5% (1)
  • B
    9% (2)
  • D
    86% (19)

Explanation

Dimensions, hierarchies, members, levels, and attributes form the structure of a cube. The data comes from measures. Measures represent business data that is important for analysis, such as sales and cost of goods sold. Measure values are the data that fills the intersections in a cube. To be meaningful, a value must be defined in terms of all dimensions in the cube.

Topics

#multidimensional modeling#measures#facts#dimension design

Community Discussion

No community discussion yet for this question.

Full 1Z0-531 Practice