To create a reporting application:
If it does not exist, create the target reporting application.
Reporting applications can be either Essbase block storage or aggregate storage databases. For the characteristics of each, see the Oracle Essbase Database Administrator's Guide.
In the reporting application, create the dimensions on which you want to report or aggregate.
When you later map the applications, Planning automatically maps same-named dimensions. To report or query on Smart Lists, create dimensions in the reporting application that map to the Smart Lists in the source Planning application.
Into the reporting application, load members on which you want to report or aggregate.
Next:
Map the source Planning application to the target reporting application.
See Mapping Planning Applications to Reporting Applications.
Push data from the source to the target application.
Report on the data in the reporting application.