✍ Kashif M ™
☎ +91 9994883085
✉ kashif7222@gmail.com


Saturday, 23 September 2017

Step by Step on creating new report in BI Publisher

By on September 23, 2017

Creating new Report in BI Publisher

Create a new report ‘Department_Details’ inside the created folder ‘BI_Publisher_LabGuide’

Click on Edit link mentioned below to create the report

Creating new Data Model

Select Data model à New

Enter the data model name àselect the type as SQL Query

Choose the data source

Write the SQL Query

SQL query can also be generated using SQL Builder which is discussed in the next example.

Save the report

View the report

The output could be viewed only in the data format, as we have not created any template for the report.

Click the view button to view the output. The output generated will be in the form of XML.

You can also edit the report by clicking the Edit link.

After editing, Save the report and view it as we have discussed already.
Viewing the Report in Different formats

Here we can view the above created report in various formats using Template.
Creating Default Template

Select the Layouts, and click the Generate button to create a new RTF template based on the default data model.

A default template (New_Template.rtf) will be generated.

Save the report.

Output is shown below with the generated default template.

The output could be viewed in different formats.
Viewing the output in Default Template

By clicking view one can see the output using default template.

Similarly we can view the report in various formats by selecting the desired output format.

mkashu: Step by Step on creating new report in BI Publisher
Review : Kashif | Kashif
Update: September 23, 2017 | Rating: 4.5

Comment for "Step by Step on creating new report in BI Publisher"


Post a Comment

Blog Archive