Wednesday, 10 February 2021

Top 20 BI Publisher Interview Questions

 

 

Ques. 1): What is the main difference between BI publisher and XML publisher?

Answer: BI publisher can be installed as a standalone version running off of several OC4J compliant engines, such as Application Server and Tomcat. BI publisher can be pointed anywhere, so that reports can be run out of an OLTP or warehouse database, MSSQL and even within EBS. Licensing is already included in EBS, and the standalone costs whatever plus maintenance. XML Pub operates entirely within EBS and can only be used within EBS.

 

Ques. 2): What is a data template in BI publisher?

Answer: Data template is an xml structure which have the queries to be run for a database so that output can be generated in xml format, this generated xml output is further applied on a layout template for the final required output.

 

Ques. 3): What is the default output format of the report in BI publisher?

Answer: The default output format defined during the layout template creation will be used to generate the output, the same can be modified during the request submission and it will overwrite the one defined at layout template.

 

Ques. 4): What are the various sections in the data template?

Ans: The various sections in the data template in BI publisher are as:

  • Parameter section
  • Lexical Section
  • Trigger Section
  • SQL statement section
  • Data Structure section

 

Ques. 5): In BIP, how do you display the company logo in the report output?

Ans: In BIP, you can just copy and paste the logo (.gif, .jpg or any format) on the header section of .rtf file. Resize the log per the company standards.

 

Ques. 6): What is a layout template in BI publisher?

Answer: Layout template defines how the user views the output, basically it can be developed using Microsoft word document in rft (rich text format) or Adobe pdf format. The data output in xml format (from Data template) will be loaded in layout template at run time and the required final output file is generated.

 

Ques. 7): How do we create subtotals and Grand Total in BI Publisher?

Answer: If I have a report in OBIEE Answers with three columns –

Brand, Type and Revenue.

An OBIEE Report can be created as follows:

  • Create the BI Publisher Report
  • Login into bi publisher through word and open the BIP report
  • Insert the table wizard and Add the columns Brand, Type and Revenue
  • In the Group by – select Brand
  • click the radio button of Group left
  • click on finish.

 

Ques. 8): In how many ways you can display images in a BI Publisher Report?

Answer:
The images can be displayed in below 5 ways:

  •     Direct Insertion into RTF Template
  •     URL Reference
  •     OA_MEDIA directory reference
  •     Image from BLOB datatype from database
  •     Using UI Beans


Ques. 9): How to submit a layout in the backend?

Answer:
we must write a procedure for this using the below code

FND_REQUEST.ADD_LAYOUT (

 TEMPLATE_APPL_NAME     => 'application name',

TEMPLATE_CODE           => 'your template code',

TEMPLATE_LANGUAGE       => 'En',

TEMPLATE_TERRITORY      => 'US',

OUTPUT_FORMAT           => 'PDF'

);

 

Ques. 10): What are the various XML publisher tables?

Answer:

  • PER_GB_XDO_TEMPLATES
  • XDO_DS_DEFINITIONS_B
  • XDO_DS_DEFINITIONS_TL
  • XDO_DS_DEFINITIONS_VL
  • XDO_LOBS
  • XDO_TEMPLATES_B
  • XDO_TEMPLATES_TL
  • XDO_TEMPLATES_VL
  • XDO_TEMPLATE_FIELDS
  • XDO_TRANS_UNITS
  • XDO_TRANS_UNIT_PROPS
  • XDO_TRANS_UNIT_VALUES

 

Ques. 11): How to get SYSDATE in the header section dynamically when we run the report?

Answer: You cannot insert form fields in the Header section, but you can just insert the code to achieve this. For example: insert this in the header section to view the sysdate: You could format the date as you would like.

  • <?xdofx: sysdate(‘YYYY-MM-DD’)?>

 

Ques. 12): How do you create a BI Publisher report with two sub reports?

Answer: If I have a report in OBIEE Answers with these columns –

  • Year, Brand, Revenue
  • Region, District, Revenue

An OBIEE Report can be created as follows:

  • Create the BI Publisher Report
  • Login into bi publisher through word and open the BIP report
  • Insert the table wizard
  • Add the columns Year, Brand and Revenue
  • In the Group by select Year and Brand
  • click the radio button of Group left
  • click on finish.
  • delete the ones indicated in circles
  • create a table with 2 rows and 3 columns
  • Give the column headings in the first row
  • copy paste the following indicated by the arrow mark
  • apply the necessary formating and delete the first table
  • give the necessary aggregation as shown below
  • create the other sub report similarly
  • publish the template
  • view it in bi publisher
  • Thus, we can create sub reports in BI Publisher

 

Ques. 13): How to calculate the running total in XMLP?

Answer:

  • <?xdoxslt:set_variable($_XDOCTX, ‘RTotVar’, xdoxslt:get_variable($_XDOCTX, ‘RTotVar’) + ACCTD_AMT(This is column name) )?>
  • <?xdoxslt:get_variable($_XDOCTX, ‘RTotVar’)?>

 

Ques. 14): How to use Variables in XML publisher?

Answer: In XML publisher the declaration of variables can be done as:

Declaring the Variable R and Assigning the Values 4 to R

<?xdoxslt:set_variable($_XDOCTX, ‘R’, 4)?>

Get the Variable value

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

This adds 5 to variable R and displays it

<?xdoxslt:set_variable($_XDOCTX, ‘R’, xdoxslt:get_variable($_XDOCTX, ‘R’)+5)?>

This subtracting 2 to varaible R and displays it


<?xdoxslt:set_variable($_XDOCTX, ‘R’, xdoxslt:get_variable($_XDOCTX, ‘R’)-2)?>

 

 

No comments:

Post a comment