Among the provided choices, Selection Step is the intended answer. Selection steps allow an analysis author to refine which attribute or hierarchy members remain visible and can be arranged in a defined sequence. They support operations such as keeping or removing members and applying condition-based member selection, including conditions based on measures such as Sales.

Oracle distinguishes selection steps from conventional filters. A normal column filter is applied before query aggregation , while selection steps operate after aggregation and affect the members displayed without changing already-calculated aggregate values. Selection steps can also be sequenced so that one refinement occurs before a later Top N or other member-selection operation.

There is a wording weakness in this item. If “before any ranking” means before query aggregation and ranking at the SQL level, a conventional analysis filter such as Sales < > 0 would be the cleaner technical mechanism, but Filter isn't one of the answer choices . Of the listed options, Selection Step is the only feature capable of removing members as part of analytical result refinement.

Dashboard Prompts provide runtime input; Conditional Formatting only changes appearance; Narrative View controls presentation.

Reference Topic: Formatting Data and Managing Filters, Selection Steps, and Variables — Selection Steps

===============