nerdexam
Oracle

1Z0-531 · Question #42

The following two members would be optimally tagged Label Only.

The correct answer is B. "Rations" C. "Scenario". Label only is a tag that you can apply to a member to indicate that : you don't want to store data. the Members do not have data associated with them. Use Label Only for member like Scenarios, Ratios, or Drivers, members whose sole purpose in life is to organize the dimension…

Creating and Managing Cubes

Question

The following two members would be optimally tagged Label Only.

Options

  • A"Profit"
  • B"Rations"
  • C"Scenario"
  • D"Q1"
  • E"January"

How the community answered

(20 responses)
  • A
    5% (1)
  • B
    80% (16)
  • D
    10% (2)
  • E
    5% (1)

Explanation

Label only is a tag that you can apply to a member to indicate that : * you don't want to store data. * the Members do not have data associated with them. Use Label Only for member like Scenarios, Ratios, or Drivers, members whose sole purpose in life is to organize the dimension Although a label only member has no data associated with it, it can display a value. The label only tag groups members and eases navigation and reporting. Typically, label only members are For example, in the Measures dimension, the member Ratios has three children, Margin%, Profit%, and Profit per Ounce. The member Ratios defines a category of members. When consolidated, Margin%, Profit%, and Profit per Ounce do not roll up to a meaningful figure for Ratios. Hence, Ratios is tagged as label only.

Topics

#Label Only tag#member properties#outline optimization#stored members

Community Discussion

No community discussion yet for this question.

Full 1Z0-531 Practice