For building ad-hoc reports by using new data model user should have BI Administrator role.  

1. From the navigator, click on the ‘Build a Report’ link. If the My Reporting link is not visible look for it under... (Navigation is: Navigator > My Reporting > Build a Report)

2. The Reports and Analytics screen will open up. On this screen, find the Create button drop-down and click on the Report

3. Once you’ve clicked the Report option, a new Oracle Business Intelligence Create Report window will open (Check for popups if the new window does not open)

1. On the Business Intelligence page, use the option to create a new ‘Data Model.’

2. From the Data model page, select the SQL query as the object.

3. On the New Data Set – enter the required field and write your SQL in the Query section.

1. Save the Data Model by clicking on the Save icon. Preferably create a folder for your implementation and use it to save the data model.

2. Once you’ve saved the data model, you will notice that the data model is selected. Now click on the Generate icon to generate the RTF layout based on the selected data model.

3. Provide the name of the template and save the report by clicking on the generate button.

1. After saving the report, click on the View report link to view the report.