Command to use SQL*LOADER

SQL*LOADER , a oracle based bulk loading utility. The following shows the way to load the data using the SQL*LOADER.

Using SID

sqlldr <Username>/<password>@"(DESCRIPTION\=(ADDRESS\=(PROTOCOL\=TCP)(HOST\=<HostName>)(PORT\=1521))(CONNECT_DATA\=(SERVER\=DEDICATED)(SID\=<SID>)))" control="Control_file.ctl" log="log.txt",bad="bad.txt" data="Data_file.csv"

Creating DataModel and Report in BI Publisher - Part 2

Part2 :

Once the RTF development is completed, start the creation of Report

Click on New Report:

 

Click on existing data model:

 

Select the datamodel which is developed

 

After selecting the Datamodel click on Next, Then select Use Report Editor and click on finish

 

Save the Report .

Click on Upload and enter the name and the RTF location: 

Click on View Report. Pass the parameter and the report gets generated:

 

 

Click on HTML/PDF/EXCEL etc to view the Report.