Idea Summary
I would like to congratulate the team with the addition of the Data Reporter feature in 26.1. It is a feature that can finally replace Oracle Discoverer.

The power of Discoverer was that it did not expose the database tables and views directly to the end user, but first a so-called end user layer (EUL) had to be created, which then could be used by the end user to base reports on (using drag and drop features). The Dataset feature of Data Reporter replaces this more or less, but it still requires some SQL knowledge (AI feature may help building the queries, but it is not easy to understand by the end user whether the data is really what is meant).

Data analists do not think in relational models but in dimensional models. By supplying analytic views the data analist can much easier make understandable reports. Exposing analytic views in Datasets an analist might be able to pick the dimensions and facts, determine the aggregation level for each dimension etc.

Use Case
Some companies are still using Oracle Discoverer. Apex Data Reporter based on analytic views could replace Discoverer functionality and make it even far more powerful.

Preferred Solution (Optional)
It is already possible to expose analytic views by adding custom queries to the Datasets, but extra controls to add filters, measures and aggregation levels would be great, it would reduce the required knowledge of querying analytic view syntax.