How to get rid off unable to get lock file,will retry

BEA-141281 unable to get file lock, will retry

SOLUTION

D:\Software\OBI_MW\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp

Remove .lok file in this location,If you are not able to delete restart the mechine and do it,same way remove for adminserver.lok file

Creating an Ad Hoc Pivot Table with the Analyzer

     You can quickly able to create ad hoc analysis by dragging and dropping your report data into the pivot table, and also you can able to save this as a layout for the report.you can apply filters also to this.Data what we are using in this are from source XML so we cant able to perform number formatting. 

About Online Analyzer Toolbar

New – It creates a new pivot table structure. If you want to save click save before you click new.

Export – It helps you to export and save this as BI Publisher Layout

Move decimal Left – It help to add additional decimal position

Move decimal right – It helps to remove decimal postion

Creating an Interactive Pivot Table 

1. From the report viewer click actions and then select analyzer

            

  2. Analyzer Interface will display the fields on the left pane and empty pivot table on the right

   

3. To filter by department name drag and drop dname from left pane to page item area on the right.

4.To view Job wise employee wise salary drag and drop fields from left pane to row field in the analyzer.

5. Now you can click Job, Ename to open and close, corresponding to that field values will change

Saving your Interactive Pivot table as Layout

1.  You can save your analyzer by clicking export on the tab that appears on the top

2. Then it will be saved as BI Publisher .xpt then it will have all the featured  of a BI Publisher layout

3.Close the Online Analyzer

4. On the action Menu click Edit Report

5. From the report editor ,click View a List to display the layouts in the list view.

6.Locate your new layout in the Layout table and select a locale for it

7.Click save

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.