問題文
A regional revenue analysis lists ten regions and the Revenue column already totals 100 million. Finance wants one region taken off the displayed list, and insists that the printed total must still read 100 million afterward. Which mechanism satisfies that requirement in Oracle Analytics?
選択肢
- A column filter on the Region column, because filters are evaluated after the query is aggregated and drop the member from the list without disturbing the measure total that was already computed.
- A selection step and a column filter placed on the Region column together, because the filter narrows the members and the step then restores the aggregate to its original value.
- A column filter on the Region column whose operator is set to is prompted, because that operator defers the member to a prompt and prompted members are left out of the aggregation.
- A selection step on the Region column, because steps run only once the numbers have been rolled up, so taking one member off the visible list still leaves the printed total reading 100 million at the bottom.