BI Publisher

BI Publisher - It is part of the middleware reporting stack in the family of Oracle Business Intelligence tools and is used as reporting solution.

It can be used for:

• generate highly formated documents
• electronic funds transfer documents
• government pds forms
• shipping labels, checks, sales and marketing letters and much more.

BIP is integrated with Oracle Business Intelligence, and is also available for use as standalone tool or integrated with e-business suite or people soft.

Installation: http://www.oracle.com/technetwork/middleware/bi-ublisher/downloads/index.html

• Install Oracle database 12c
• Choose 'character set' to Unicode during installation.  
• Uncheck 'create as container database'
• Install (database) instant client software
• Create folder 'InstantClient'
• extract the downloaded files to the 'InstantClient' folder
• instantclient-basic & instantclient-odbc
• Modify env variables
• Modify path variable to add location of 'InstantClient'  eg: c:\InstantClient\instantclient_12_1
•  Add new system variable TNS_ADMIN and set the value  to location of Instant client.
• Run setup for ODBC Install
• run odbc_install file in 'InstantClient' location as Administrator
• restart the system 
• Copy 'listner.ora' & 'tnsnames.ora' files from <DB_HOME>/Network/Admin to 'InstantClient' directory and change the Oracle_Home(until parent of BIN directory) & .DLL patch and file name appropriately  in listener.ora
• Also ensure tnsnames.ora has entry for new db
• Install repository creation utility software(Downloads->Middleware-> Business Intelligence Suite EE-> Oracle Business Intelligence (11g) downloads -> all supported platforms ->RCU
• give 'Sys' as Username & 'SYSDBA' as role
• Select Oracle Business Intelligence as Component 
• Install Oracle Business Intelligence publisher 11g
•  select 'skip software updates' 
• simple install
• uncheck 'Business Intelligence Enterprise Edition' & 'Real-time decisions'

How to start BI publisher 11g on windows 

• c:\Middleware\user_projects\domains\bifoundation_domain\bin\startWeblogic.cmd
• login/Open em(enterprise manager) from browser using weblogic user  <host:7001>/em
• bipublisher server  -> Application deployment -> control -> startup
• login/open bipublisher <host:7001>/xmlpserver using weblogic user
• login/open console <host:7001>/console using weblogic user
• Deployments -> verify if bipublisher health is OK & start it

How to stop BI publisher 11g on windows

• Method1: stopWeblogic.cmd from bin directory
  
• Method2: Enterprise manager -> Business Intelligence -> core application -> Availability -> processes -> stop all

BI Publisher User Interface

• Login to <host:7001>/xmlpserver (Eg: admin)
• Create a New folder in catalog
• Click catalog from global header -> My Folders -> New folder(use this to save files, reports and other objects)
• Upload resource to catalog(xdmz file which is a datamodel file). We upload datamodel, template or report here
• Configuring Data Source
• Click Administration link in global header -> Data Sources-> JDBC connection -> add data source
• Creating a data model
• Global header -> new -> data model-> Dataset -> Create
• select type as SQL and provide SQL
• Update Alias
• Conditions using bind variables
• See the results
• 
  
• Properties - xml output options -> select/check Include parameter tags
• Dataset-> new dataset  of type sql query -> provide name & 
• Create BIP Report
• It is made of data model, layout, properties, and translation(optional). 
• New Report -> Use existing Data model -> select  the created datamodel -> save it
• Select a Layout -> Edit layout -> save it
• To view the create report-> navigate to reports -> The report shows the datamodel & associated layouts -> View Report
• Click Parameter button/link on Report editor 
• Report Job
• New -> Report Job-> Select the report -> Scheduling ->  This has following tabs
• General
• Output
• Schedule
• Notification
• Manage Reports Job
• To delete/pause/resume/edit Report Jobs

OBIEE

Dashboard
analysis
filters
    Created in Answers dashboard -> Criteria tab
answers
    Tool to modify existing components as well as to create new components line analysis, dashboards, filters.


Subject areas