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.