Oracle Governed Analytics Professional with Oracle Analytics Cloud 1z0-1177-26 Question # 21 Topic 3 Discussion
1z0-1177-26 Exam Topic 3 Question 21 Discussion:
Question #: 21
Topic #: 3
A business user wants to compare current-quarter sales against only the top five performing product categories. Which feature best supports this requirement?
A Top N selection/filtering operation is the feature designed to retain only the highest-performing members according to a selected measure. In this case, Product Category is the dimension and current-quarter Sales is the measure used to rank the categories. Configuring the analytical selection to retain the top five categories produces exactly the required comparison population.
Oracle Analytics supports both selection-step member refinement and explicit Top/Bottom N filtering capabilities. The current Oracle Analytics documentation includes Top N examples that identify the highest attribute values based on a measure, which is precisely the analytical pattern in this question.
The important concept is that the ranking is based on the measure rather than visual styling. Conditional Formatting could visually distinguish high or low Sales values but wouldn't restrict the result to five product categories. Repository Initialization Blocks initialize semantic-model variables and have no role in ranking members. Dashboard Page Style controls appearance and layout rather than result membership.
Therefore, Selection Step with Top N filtering is the best supplied answer because it limits the displayed product categories according to their current-quarter Sales ranking and retains only the five highest performers.
Reference Topic: Formatting Data and Managing Filters, Selection Steps, and Variables — Top N Analysis
===============
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit