For the greatest simplicity, you could construct a subject area that consists of a single table.
To create a single table model, you first create a logical dimensional model in the business model layer, and then present it as a single table schema in the Presentation layer.
The logical dimensional model is required to set up the necessary metadata for the Oracle BI Server to navigate to the proper physical tables.