You are here: BI Publisher Displaying items by tag: BIP
Displaying items by tag: BIP

"BI Publisher for JD Edwards Enterpriseone"  online course designed for those professional who are working on JD Edwards earlier releases and wants learn BI Publisher JDE integration reporting available with recent releases (8.96, 8.98, 9.1).

This course also provides a good opportunity for those developers, who are experts in BI Publisher but want to learn BIP-JD Edwards Integration. 

Duration : 32 hours, 4 weekends (Saturday and Sunday 9 AM EST to 1 PM EST)

Contact: training@adivaconsulting.com or   +1 408-361-8194

Next Batch : March 2nd 2013.  Conatct us to Join free demo session.

Course Contents

 

Understanding BI Publisher

·         BI Publisher overview
·         Describing the Oracle BI Publisher Applications Architecture and components
·         BI Publisher for JD Edwards overview
·         Embeded BI Publisher Reports
·         One View Reports          
·         Adhoc Reporting
·         Understanding XML basics
Designing BI Publisher Templates using BI Publisher Word Template Builder      
                    Describing BI Publisher templates
                    Designing templates with BI Publisher Template Builder
                    Create Simple Listing Report
                    Working with Groups
                    Working with Tables, Forms
                    Implementing conditional logic to handle complex layout
                    Formatting Numbers, Date and Currencies.
                    Defining Headers and Footers
                    Inserting Images and Charts
                    Implementing XPATH Commands in RTF
                    Check Printing
                    Invoice Printing
                    Working with Sub-Templates
                    Advance Report Layout
Understanding JD Edwards Environment                          
                    Quick overview of JDE architecture
                    Overview of Data Dictionary
                    Working with Object Management Workbench (OMW)
                    Creating & Managing Project
                    Working with Tables & Business Views
                   Modifying template objects
Creating JD Edwards EnterpriseOne Embedded BI Publisher Objects
                    Understanding the BI Publisher Object Repository (Template, Transformation, Translation & Localization)
                    Creating, Updating, and Deleting JD Edwards BI Publisher Objects
                    Modifying template objects
 
Creating JD Edwards BI Publisher Report Definitions
                    Creating report definition objects
                    Defining output types and languages
                    Defining bursting and delivery methods
                    Modifying report definitions
                    Describing BI Publisher and Object Management Workbench integration
Working with Report Designer Aid (RDA) to generate BI Publisher friendly XML.
                    Overview of RDA
                    Overview to Report and Report Components
                    Sections (Column, Tabular, Group Sections)
                    Report Header Footer Sections
                    Page Header & Footer Sections
                    Level Breaks
                    Batch Versions
                    Working with Report Director
Submitting Report Definitions
•             Submitting report definitions from the Report Definitions application
Associating Report Definitions with Batch Versions
•             Associating a report definition with a batch version
Submitting Report Definitions from the Batch Versions Application
•             Submitting report definitions from Batch Versions
Monitoring Report Definition Processing
·         Describing the Report Definitions Job Control Search form
·         Accessing report definition jobs from View Submitted Jobs
Utilizing Report Definition Output
                    Viewing report definition source
                    Describing the Report Definition Output Repository (P95630)
                    Viewing report definition output
                    Viewing report definition output delivery details
                    Republishing report definition output
Managing Report Definition Output
                    Setting up security for report definition jobs and output
                    Deleting UBE and report definition output
                    Archiving BI Publisher report definition output
Working with Oracle BI Publisher Enterprise for Interactive Reporting
                    Configuring Oracle BI Publisher Enterprise to access JD Edwards EnterpriseOne data
                    Creating Data Model against JDE data
                    Creating Interactive BI Publisher Report
                    Scheduling BI Publisher Interactive Report
One View Reporting Overview
                    Review the existing prebuilt One View Reports
                    Add Custom Report to One View
Published in BI Publisher
Tuesday, 07 August 2012 15:10

RTF Template : Working with variables

 Let’s see how we can use the variables to store temporary data or use for calculation.  This is achieved using  “xdoxslt:” function. These are the BI Publisher extension of standard xslt functions.  

Use xdoxslt:set_variable () function to set /initialize the variable  and xdoxslt:get_variable() function to get the variable value.  $_XDOCTX is the System variables to set the XDO Context.

 

 

/*initialize a variables*/

<?xdoxslt:set_variable($_XDOCTX, ‘counter’, 0)?>

/*update the variable’s value by adding the current value to MY_CNT, which is XML element */

<?xdoxslt:set_variable($_XDOCTX, ‘counter’, xdoxslt:get_variable($_XDOCTX, ‘counter’) + MY_CNT)?>

/* accessing the variables */

<?xdoxslt:get_variable($_XDOCTX, ‘counter’)?>

 

/*Working in a loop*/

<?xdoxslt:set_variable($_XDOCTX, ‘counter’, 0)?>

<?for-each:G1?>

/*increment the counter*/

<?xdoxslt:set_variable($_XDOCTX, ‘counter’, xdoxslt:get_variable($_XDOCTX, ‘counter’) + 1)?>

<?end for-each?>

<?xdoxslt:get_variable($_XDOCTX, ‘counter’)?>

 

Hope this help in understanding variable gimmicks.

Need help on RTF template design or BI Publisher implementation, please contact This e-mail address is being protected from spambots. You need JavaScript enabled to view it

 

  

Published in BI Publisher
Tuesday, 07 August 2012 14:33

How to re-group XML data in RTF Template

 If we need the grouping, it is always advisable to generate the XML as per the required hierarchy. This makes the RTF design simple and perform better.  But there are situation when we do not have control over XML structure and need to work on flat XML.  Lets see how we can create multiple nested grouping in RTF template.

I am using  following simple flat XML which is generated using scott.emp and scott.dept table.

Lets first design the simple table with default group

It generates simple listing report.

 

Lest add a group based on Depno. This is achieved by adding following loop

  <?for-each-group:ROW;./DEPTNO?>  --- <?end for-each?> and iterate the detail record within the current group.

This introduce the Dept Group ..
Let’s add another nested group for Job within the department group.
Hope this will help to design those nasty nested groups based on flat XML date.
Need help on RTF template design or BI Publisher implementation, please contact This e-mail address is being protected from spambots. You need JavaScript enabled to view it
Published in BI Publisher
Saturday, 28 July 2012 09:55

BI Publisher Training

Oracle BI Publisher 11g (11.1.1.6.0)

Oracle BI Publisher is an enterprise reporting solution for Production Reporting. It is available as part of OBIEE suite, Standalone Enterprise Release as well integrated with most of the Oracle Enterprise Application as Oracle Fusion Application, Oracle eBusiness Suite (EBS 11i, R12), People Soft, Siebel CRM , JD Edwards and many more. 

During this course, participant gets an Overview of the BI Publisher product, Set up, configuration Administration, Report Development and Report Scheduling.

Course Content

PART I: Oracle BI Publisher 11g Overview 

1.    Overview of BI Publisher Enterprise Edition
2.    Describing the Oracle BI Publisher Applications Architecture and components
3.    Overview of Different Report Component (Layout, Data, Translation)
4.    Desktop BI Publisher Desktop (Word Template Designer)
5.    Designing First Report using Word Template Builder

PART II: Data Model and Report Designer Editor

1.    Overview of Data Model , Data Model Editor
2.    Data Model Components.
3.    Working with different Data Source options.
4.    Designing  Simple and Master Detail Data Model 
5.    Working with Parameters, LOVs
6.    Working with  Event Triggers, Substitute variables, Dynamic SQL query source
7.    Understanding Data Model Properties.
8.    Understanding Groups, Functions, Links, Aggregation
9.    Understanding Bursting Definition.    
10.  Overview of Report Designer and Report creation process.
11.  Understanding different Layout types (RTF, PDF, EText, Excel, Interactive)
12.  Setting Run Time Properties
13.  Style Templates & Sub Templates
14.  Understanding Translation

PART III : Designing RTF  Template using Word Template Designer

1.    Create Simple Listing Report
2.    Working with Groups
3.    Working with Tables, Forms and Charts
4.    Implementing conditional logic to handle complex layout
5.    Formatting Numbers, Date and Currencies.
6.    Defining Headers and Footers
7.    Inserting Images and Charts
8.    Implementing XPATH Commands in RTF
9.    Working with Sub-Templates
10.  Advance Report Layout 

PART IV : Design Interactive Reports Using Layout Builder

1.    Overview of BI Publisher Layouts
2.    Designing Simple interactive Report
3.    Designing a Master Detail Report Using Charts

PART V : Scheduling the Reports

1.    Overview of BI Publisher Scheduler
2.    Creating Report Jobs
3.    Viewing and Managing Report Jobs
4.    Viewing and Managing Report History

PART VI :BI Publisher Administration

1.    Introduction to Oracle BI Publisher Administration
2.    Understanding the Security Model
3.    Setting Up Data Sources
4.    Setting Up Delivery Destinations
5.    Defining Run-Time Configurations
6.    Diagnostics and Performance Monitoring
7.    Moving Catalog Objects Between Environments
8.    Overview of Web logic Console and Enterprise Manager (EM) to Administrator  BI Publisher

Who can be benefited?

  • BI Consultants
  • Oracle Application Consultants [Technical & Functional]
  • Data Warehouse consultants
  • Application Developers

Prerequisites:

  • Basic understanding with SQL
  • Basic understanding with XML   
Published in Training

In this blog I am going to explain how to generate Table of Contents with links to their respective page in RTF template dynamically.

BI Publisher provides the ability to create dynamic section headings in your document from the XML data. You can then incorporate these into a Table of Contents.


To create dynamic headings:

Let us create sample XML data assuming we have different areas and within areas we have different plants.

<?xml version="1.0" encoding="UTF-8"?>

<dataroot>

<TOC>

<G_AREA>

<Area>Area1</Area>

<G_PLANT>

<Plant>Plant1</Plant>

</G_PLANT>

<G_PLANT>

<Plant>Plant2</Plant>

</G_PLANT>

<G_PLANT>

<Plant>Plant3</Plant>

</G_PLANT>

<G_PLANT>

<Plant>Plant4</Plant>

</G_PLANT>

<G_PLANT>

<Plant>Plant5</Plant>

</G_PLANT>

<G_PLANT>

<Plant>Plant6</Plant>

</G_PLANT>

<G_PLANT>

<Plant>Plant7</Plant>

</G_PLANT>

<G_PLANT>

<Plant>Plant8</Plant>

</G_PLANT>

</G_AREA>

<G_AREA>

<Area>Area2</Area>

<G_PLANT>

<Plant>Plant1</Plant>

</G_PLANT>

<G_PLANT>

<Plant>Plant2</Plant>

</G_PLANT>

<G_PLANT>

<Plant>Plant3</Plant>

</G_PLANT>

<G_PLANT>

<Plant>Plant4</Plant>

</G_PLANT>

</G_AREA>

</TOC>

</dataroot>

 Step1:

Create a RTF template and for the heading in the body of the document, and format it as a "Heading", using your word processing application's style feature. You cannot use form fields for this functionality.

For example, you want your report to display a heading for each company reported. The XML data element tag name is <COMPANY_NAME>. In your template, enter <?COMPANY_NAME?> where you want the heading to appear. Now format the text as a Heading.

Now we need to update the styles for <?Area?>  with Heading1 and for <?Plant?>  with Heading2.

Step2:

Once styles are mentioned, create a table of contents using your word processing application's table of contents feature. Select the page where table of contents to be displayed and goto References tab then select table of contents(Automatic)

After Table of Contents is selected you can see the below content.

At runtime the TOC placeholders and heading text will be substituted.

Output:

"If you found this article useful, please rate the same"

If you need any assistance in BI Publisher implementation or RTF Template design, we can help you out. please send your query to  This e-mail address is being protected from spambots. You need JavaScript enabled to view it

Published in BI Publisher

In this blog I am going to explain how we can use links in BIP report to open another BIP report with dynamic values.

For example:

Report1: In this report we have purchase details of goods in all states in a country.

Report2: Displays City level purchase details for a state and this will be the target report.

By using Report1 we are going to generate Report2 dynamically by passing parameters.


 Let’s create a report to display country regions in the first report and countries within country region in the second report. Here the second report is generated based upon the link we click for the country region.

In the below table we have country regions and their respective country names.

Country Region

Country Name

Africa

South Africa

Asia

China

Asia

India

Asia

Japan

Asia

Malaysia

Asia

Singapore

Australia

Australia

Australia

New Zealand

Eastern Europe

Poland

Middle East

Saudi Arabia

Northern America

Canada

Northern America

United States of America

Southern America

Argentina

Southern America

Brazil

Western Europe

Denmark

Western Europe

France

Western Europe

Germany

Western Europe

Ireland

Western Europe

Italy

Western Europe

Spain

Western Europe

The Netherlands

Western Europe

Turkey

Western Europe

United Kingdom

Building Report1: Country_Region

In my case I am using SH schema for getting all the details required.

SELECT DISTINCT COUNTRY_SUBREGION FROM COUNTRIES ORDER BY 1;

Now generate XML(DATA) for this report.

Build the RTF using the XML.

We completed Simple RTF Template.

 Output

To create link we need to have Target Report as ‘Country Name’

We create target report ‘Country Name’ following the steps similar to report1 and add a parameter. Let’s just call the paramater as “P_COUNTRY_REGION”.

Now generate the XML

Create RTF for Report2: Country_Name. Once the RTF is completed upload into BIP Template Section.

Run the report and check if it works fine by passing the parameter:

Now, we need to generate link to the report or document. In the report on right top corner you can find “Link to this report” Click on it. Depending upon your requirement, select the link. Here I am using Document Only option.

Here is the generated Link

http://localhost:9704/xmlpserver/Country_Name/Country_Name.xdo?
_xpf=&_xpt=0&_xdo=%2FCountry_Name%2FCountry_Name.xdo
&P_COUNTRY_REGION=Asia_xt=Country_Name&_xf=html&_xmode=4

In the above link you can find P_COUNTRY_REGION=Asia which is the parameter we used previously as “Asia”. Now take this link and use this in Report1.

Before using this we need to make few modifications to the url which is as follows:

For using Dynamic Parameters:

We want to dynamically click on a value in report 1 and get the corresponding details in report 2. For this we take the name of the parameter “P_COUNTRY_REGION” in the link and use these brackets ‘{‘, ‘}’ instead of the BI Publisher’s tag ‘<??>’. Hence, the link will look as follows from my local:

http://localhost:9704/xmlpserver/Country_Name/Country_Name.xdo?
_xpf=&_xpt=0&_xdo=%2FCountry_Name%2FCountry_Name.xdo
&P_COUNTRY_REGION={COUNTRY_SUBREGION}
&_xt=Country_Name&_xf=html&_xmode=4

Get the hostname, port number, and the root path dynamically

When we run our report we will not have a constant host name always. There might be different server instances like ‘Development’, ‘Testing’, ‘Production’, etc. There is a pre-defined BI Publisher’s variable called ‘CURRENT_SERVER_URL’, which returns an URL that contains hostname, port number, and the root path. So it would be “http://localhost:9704/xmlpserver” for the above example.

So now you can replace the URL to be something like:

{$CURRENT_SERVER_URL}Country_Name/Country_Name.xdo?
_xpf=&_xpt=0&_xdo=%2FCountry_Name%2FCountry_Name.xdo
&P_COUNTRY_REGION={COUNTRY_SUBREGION}
&_xt=Country_Name&_xf=html&_xmode=4

In order to use the ‘CURRENT_SERVER_URL’ variable you need to declare it in the RTF template. So, you need to just type the following syntax at the beginning.

<?param@begin:CURRENT_SERVER_URL?>

Now add the url in RTF

Upload the RTF into BIP Template Section and run the report.

Output.

When you click the link the output would be.

Africa

 

Asia

"If you found this article useful, please rate the same"

If you need any assistance in BI Publisher implementation or RTF Template design, we can help you out. please send your query to  This e-mail address is being protected from spambots. You need JavaScript enabled to view it

Published in BI Publisher