How to Set Default Data Source in BI Publisher

                 We can able to set the default data source, Instead of selecting data source while creating data set we can make it as default so that whenever you are creating data set you don’t want to select data source.

Select New -> Data model 

On the left hand side component panel select data model  

On right hand side there will be the option Default Data Source, Select the data source from the drop down  

So, here after whenever we are creating new data set default data source will be selected and also if you want you can change the data source while creating the data set

How to Create Data Set Using SQL Query

What Is a Data Model?

                A data model is an object that contains a set of instructions for BI Publisher to retrieve and structure data for a report. Data models reside as separate objects in the catalog.

                At the very simplest, a data model can be one data set retrieved from a single data

source (for example, the data returned from the columns in the employees table)

                   The data model editor is the tool for building your data models.

                 In this blog you will come to know how to create data set using SQL query in data model. To create report we must have data model that should contains minimum one data set.

Open Oracle BI Publisher with your credentials

Click New -> Data Model

Click New Data Set -> SQL Query

Give name to the data set

Select data source from the drop down

Write the query in the SQL Query window

Click ok

This three are mandatory one, after you clicked ok data set will be created

Click Save

If you need you can add description its optional one.

Finally data model is created. In my next blog I will show how to create report by using this data model

How to add Data Source in BI Publisher using JDBC

                      The JDBC driver for the selected database must be available to BI Publisher. If you are using an Oracle database or one of the DataDirect drivers provided by WebLogic Server, then the drivers must be installed in the correct location and there is no further setup required.

                     

                      If you plan to use a different version of any of the drivers installed with WebLogic Server, then you can replace the driver file in D:\OBI_MW\wlserver_10.3\server\lib with an updated version of the file or add the new file to the front of your CLASSPATH.

Click Administration on the right hand side top after you logged in with BI Administration Privilege

Then under data source click JDBC Connection

Click Add Data Source

Give the appropriate information in the fields, Mandatory fields are marked with asterisk *

Data Source Name — Enter a display name for the data source. This name is displayed in the Data Source selection list in the Data Model Editor.

Driver Type — Select the database type from the list. When you select a driver type, BI Publisher automatically displays the appropriate Database Driver Class and provides the appropriate Connection String format for your selected database.

Database Driver Class — This is automatically entered based on your selection for Driver Type. You can update this field if desired.

For example: oracle.jdbc.OracleDriver 

Connection String — Enter the database connection string.

When you select the driver type, this field automatically displays the appropriate connection string format for your database type.

For an Oracle database the connect string must have the following format:

jdbc:oracle:thin:@[host]:[port]:[sid]

For example: jdbc:oracle:thin:@myhost.us.example.com:1521:prod

Use System User — This is reserved for connections to the Oracle BI Server.

User Name — Enter the user name required to access the data source on the database.  Password — Enter the password associated with the user name for access to the data source on the database.

Pre Process Function and Post Process Function — (Optional) Enter a PL/SQL function to execute when a connection is created (Pre Process) or closed (Post Process).

Use Proxy Authentication — Select this box to enable Proxy Authentication.

Click Test Connection. A confirmation is displayed. 

(Optional) Enable a backup database for this connection by entering the following:

Use Backup Data Source — Select this box.

Connection String — Enter the connection string for the backup database.

Username / Password — Enter the username and password for this database.

Click Test Connection. A confirmation is displayed. 

Define security for this data source. Use the shuttle buttons to move roles from the Available Roles list to the Allowed Roles list. Only users assigned the roles on the Allowed Roles list can create or view reports from this data source.

The settings defined here are passed down to the backup data source, if one is defined.

Once you are done click Apply

New Data Source has been added Successfully. 

Overview for Report Designers

      A Report consists of Data Model ,layouts and set of properties.Optionally it includes style template.The report designer may contains following tasks

• Create data model with parameters in BI Publisher data model editor
• Design the layout for the report.It can be created using variety of tools.The report design and output will decide which layout tool should be considered.
• Create the sub template to re-use common functionality in all over the report
• Creating the style template will give good look and feel of that report                  

Accessing Oracle Business Intelligence Publisher

Logging in with credentials:

1. Navigate to URL provided by your administrator (for example http://example.com:9704/xmlpserver). 
2. Give the username and password that is provided to you
3. Select the language from the drop down for your user interface
4. Click Sign In                                   

                           Note:Accessibility Mode will display user interface as tree structure for user                             keyboard navigation and it will for OBIEE (analytics) by default in BI Publisher                                  it is disabled.

Overview of the Oracle Business Intelligence Publisher Report

       Oracle Business Intelligence Publisher is a reporting and publishing application that enables you to extract data's from different data source.It is basically oracle product, it is one of the tool used to view the data from database in a pictorial way so that it helps to take decision in the business.It create layouts for report data,and publish the report to numerous output formats. BI Publisher also enables you to schedule reports and deliver the reports to multiple delivery destinations required by

business.

Overview for Report Consumers

     A report consumer may perform the following tasks:

• Run and view reports from the BI Publisher reports repository
• Schedule reports to run at selected intervals and to be delivered via any channel set up by your administrator
• Create an ad hoc analysis of report data using BI Publisher's Analyzer feature
• Open and manipulate reports in Microsoft Excel using BI Publisher's Analyzer for         Microsoft Excel