Thursday, 30 November 2017

Creating DataModel and Report in BI Publisher

This post provides the steps required and to be followed for creating sample Report in the BI Publisher.

Part 1 :

1. Login to BI Publisher.
   

    Click on create Datamodel:


 


2. Select The Datasource, connection to Database:

 


3.Create a Dataset:





4. Paste the SQL with parameters and the parameters will get created automatically:


5. Parameter creation:

 

6.Parameter Display Name, Datatype and order of placement:

 

7.Save the Datamodel:

 


Generating the XML for Developing RTF:
Click on XML Icon on right top of the screen:
Pass the parameter , select All in the drop down number of rows to return and click run:

 

Save the XML generated as Sample XML.

 
 
Export the generated XML for RTF Development:

   
 
Save the XML and Start the development of RTF

To be continued in Part2 of this post.


 



Connect SQL* Plus using the TNS entry

This post is about connecting SQL Plus using the TNS entry details from the command prompt.

This are the command to use.


1. Using SID :

sqlplus <username>/<password>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname>)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SID=<sid>)))


2. Using Service Name :

sqlplus <username>/<password>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname>)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=<service_name>)))