Mindmajix

Oracle BI Publisher Interview Questions

Oracle BI Publisher Interview Questions

Q. What is Oracle BI Publisher?

Oracle BI Publisher is a new java-based product available with the technology stacks of EBS, Peoplesoft, Siebels, JD Edwards and BI Enterprise Edition (OBIEE). It Provides users with:

  • A template-based, easy-to-use publishing solution
  • A tool to rapidly develop and maintain report formats formats

Q) What is a Data Template?

The Oracle XML Publisher data engine enables you to rapidly generate any kind of XML data structure against any database in a scalable, efficient manner. The data template is the method by which you communicate your request for data to the data engine. It is an XML document whose elements collectively define how the data engine will process the template to generate the XML.


Q. What is a template Builder?

The Template Builder is an extension to Microsoft Word that simplifies the development of RTF templates. The Template Builder is tightly integrated with Microsoft Word and allows you to perform the following functions:

  • Insert data fields
  • Insert data-driven tables
  • Insert data-driven forms
  • Insert data-driven charts
  • Preview your template with sample XML data
  • Browse and update the content of form fields
  • Extract boilerplate text into an XLIFF translation file and test translations

Valid template file types are:

eText – Inbound, eText – Outbound, PDF, RTF, XSL-FO, XSL-HTML, XSL-TEXT, and XSL-XML.


Q) What Functionality is Supported?

The data engine supports the following functionality:

  • Schema generation
  • Default RTF template generation
  • Flexfields
  • Single and multiple data queries
  • Query links
  • Parameters
  • Aggregate functions (SUM, AVG, MIN, MAX, COUNT)
  • Event triggers
  • Multiple data groups
  • Unicode for XML Output

Unicode is a global character set that allows multilingual text to be displayed in a single application. This enables you to develop a single multilingual application and deploy it worldwide.

  • Canonical format

The data engine generates date elements using the canonical ISO date format: YYYY-MM-DDTHH24:MI:SS.FF3TZH:TZM for a mapped date element, and ######.## for number elements in the data template XML output.

How to Design the Data Template Definition

<data Template name=”data Template name” description=”Template description” default Package = “XX” version =”1.0”>

<parameters>

      <parameter name =”xx” dataType =”character/date/number” default Value=”10”/>

</parameters>

<lexicals>

</lexicals>

<dataQuery>

  <sqlStatement name=”Q1_XX”>

          Put your Select ename from emp

</ sqlStatement >

<data Trigger name=”before Report” source=”package name.beforeReportTrigger”/>

<dataStructure>

  </dataStructure>

<group name=”G_name” source=”Q1_XX”>

<element name=”ename” source=”ENAME” datatype=”varchar2”/>

</group>

</dataQuery>

</data Template>


Q. How to link the Queries in BI publishers reports ?

link the SQL operator that defines the parent-child relationship

<link name =”Q1_link” parentQuery=”Q1” parentColumn=”depno” childQuery=”Q2” childColumn=”depno”/>


Q. Data Template using Link

Using Link tag

<dataQuery>

<sqlStatement name=”Q1″>

   <![CDATA[

            SELECT DEPTNO,DNAME,LOC from dept where &pwhereclause

            order by deptno    ]]>

   </sqlStatement>

  <sqlStatement name=”Q2″>

 <![CDATA[

            SELECT  EMPNO,ENAME,JOB,MGR,HIREDATE,SAL

                     from EMP ]]>

  </sqlStatement>

 <link name=”DEPTEMP_LINK” parentQuery=”Q1″ parentColumn=”DEPTNO” childQuery=”Q2″ childColumn=“DEPTNO“condition=”=”/>

  </dataQuery>


Q. Data template Passing parameter

<parameters>

    <parameter name=”p_DeptNo” dataType=”character” />

 </parameters>

 <dataQuery>

   <sqlStatement name=”Q1″>

   <![CDATA[

       SELECT d.DEPTNO,d.DNAME,d.LOC,

              EMPNO,ENAME,JOB,MGR,HIREDATE,SAL

                                 from dept d, emp e

        where d.deptno=e.deptno

        AND d.deptno = nvl(:p_DeptNo,d.deptno)  ]]>

  </sqlStatement>

  </dataQuery>


Q. Sub Template into Main Template:

Import the subtemplate

<?import:file:/// D:\siva\Callsubtempalte\Subtemplatenew.rtf?>

In the subtemplate we are calling

Headers:
<?call@inlines:Tc1?><?with-param:ReportName;string(‘SIVA REPORT’)?> <?end call?>

Footers

<?call:Tc2?>


Q. Translatable (check box)

Select this check box if you want this template to be translatable. Only RTF templates are translatable. After the template definition is created, the following fields are not updateable: Application, Code, and Type. Update the template from the View Template page.


Q. To handle parameterized layout

If the requirement is to display a different layout based on a user parameter value or a List of Value selection, then the parameter can be passed to RTF layout and conditionally display the layout.

On the Report Editor you first need to define a parameter with name DeptName. If this parameter has to be associated with a List of Value (LOV), then create a LOV on the Report Editor page.

Next, in the parameter definition select parameter type as “Menu” and then select the LOV from the selection.

In the RTF template define a parameter using syntax – <?param@begin:DeptName?>

Now when user selects a department name from the List of Value on the report viewer page, the value gets passed to RTF layer into the DeptName parameter. To display the layout based on this user selection, you can use an IF statement or a CHOOSE statement to evaluate the parameter value and call the associated sub template.

Use CHOOSE statement when too many conditional tests are to be done and a default action is expected for rest of the values, for example, for each department here we have a different sub template and if the user parameter has a department name with no associated sub template, then a default sub template can be called in otherwise section.

<?choose:?>

<?when:$DeptName=’Accounting’?><?call:tAcc?>

<?end when?>

<?when:$DeptName=’Sales’?><?call:tSales?>

<?end when?>

<?when:$DeptName=’Marketing’?><?call:tMark?>

<?end when?>

<?otherwise:?><?call:tDefault?>

<end otherwise>

<?end choose?>


Q. WATERMARK

PAGE LAYOUTàWATERMARK (Word 2007)

Format → Background →  Printed Watermark (Word 2003)


Q. TEXT FIELD

Developer→ controls→ legacy tools→ text field


Q. Adding Page/Brought Forward/Carried Forward Total

Placed before the column name→ PT

<?add-page-total:pt;’TRANS_AMOUNT_REMAINING’?>


Q. Display Page Total in Footer

<xdofo:show-page-total name=”pt” format=”99G999G999D00″/>


Q. Display Brought Forward Total in Header

<xdofo:show-brought-forward name=”pt” format=”99G999G999D00″/>


Q. Display Carried Forward Total in Footer

<xdofo:show-carry-forward name=”pt” format=”99G999G999D00″/>


Q. I want to create a report output in 10 languages, do I have to create 10 layout templates?

No, BI Publisher provides the required translation for your templates, based on the number of languages installed in your oracle apps environment requires outputs are provided


Q. What is the required installation for using BI Pub report?

BI Publisher deskop tool has be installed. Using this tool you can preview or test the report before deploying the same on to the instance.


Q. How do you move your layout or data template across instances?

xdoloader is the utility that will be used.


Q. What is the tool to map required data output and layout templates so that they can be tested in local machine?

Template viewer will be used for the same.


Q. Which component is responsible for generating the output in xml format before applying it to layout template?

DataEngine will take DataTemplate as the input and the output will be generated in xml format which will then be applied on layout template


Q. Can BI publisher reports be used in OAF pages?

XDO template utility helper java classes are provided for the same.


Q. Name some business use cases for BI reports?

Bank EFT, customer documents, shipping documents, internal analysis documents or any transaction documents


Q. How do you pass parameters to your report?

Concurrent program parameters should be passed, ensure that the parameter name/token are same as in the conc prog defn and the data template


Q. What are the various sections in the data template?

Parameter section Trigger Section Sql stmt section Data Structure section Lexical Section


Q. What does lexical section contain?

The required lexical clause of Key Flex field or Descriptive FF are created under this section


Q. What triggers are supported in Data template?

Before report and After report are supported


Q. Where is the trigger code written?

The code is written in the plsql package which is given under ‘defaultpackage’ tag of data template.


Q. What is the file supporting the translation for a layout template?

xliff is the file that supports the translation, you can modify the same as required.


Q. How do you display the company logo on the report output?

Copy and paste the logo (.gif. or any format) on the header section of .rtf file . Ensure you resize per the company standards. <<

While BI Publisher may be a step in the right direction for Oracle, be sure to investigate your organization’s delivery needs and do not assume they can be met natively in R12. We provide indepth BI Publisher Training Online, Join for free live demo.


 

0 Responses on Oracle BI Publisher Interview Questions"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.