Skip to main content

Do you know how to generate output using RTF Template in Oracle Cloud BI Publisher?

In this blog, we are going to see how to generate output using RTF Templates in Fusion BI Publisher

I am going to show this using sample data. This is my sample data
BI Data Model Output
I have saved my Data Model. Now I am going to prepare the RTF Template. Before that I need the XML tags which will be used in the RTF Template
Click "Export" button in the "Data" tab as shown below.
Click "Export" button
The XML file will be downloaded based on your browser settings. This is my XML file
XML Data
I opened a new MS Word Document as save it as "Rich Text Format" type

Now enable "Developer Options". Go to "Developer" tab , click "Legacy Forms" and select "Text Form". Once Template is Completed, disable "Developer Options"
Text Form, RTF
In the XML, the tag "DATA_DS is appearing only once, and the tag "G_1" is repeating for each and every employee. So use the level "G_1" to generate the output for all employees.

To add the Start Level tag, double click the Text Form and Add Help Text as shown below and click "OK"
Text Form, <?for-each:G_1?>
Similar way you can add new Text Forms using Developer Options or you can copy the existing Text Form and change the "Default Text" and "Help Text"

To add Employee Name tag to the output, follow as shown below
Text Form, XML tag
Following the same procedure, I have added Emplid tag to the output
To add Current Date tag to the output, follow as shown below
Text Form, sysdate, format-date
To add the End Level tag, follow as shown below
Text Form, End Level tag
I have saved my Template. The text between Start Level tag and End Level tag repeats for each and every employee.

This is my RTF Template
RTF Template
Save the Data Model, Click "Save As Sample Data" button and Create a report based on the Data Model.
Upload the template as type "RTF Template" as shown below
RTF Template
Click on "View a List" and select the "Default Format" based on your need. I have selected "Excel(*.xlsx)" as Default Format and saved the Report
View a List, Default Format
This is my Output. The Text form tags which we added has been filled with the data from Data Model
Output
I hope this blog explains how to generate Output using RTF Template. If you have any questions, please post it in the comments section.


Labels:

Comments

  1. Anonymous6 March 2019 at 22:45

    generate output using RTF Template blog was nice

    ReplyDelete
  2. Fonts Mania1 May 2020 at 07:20

    This comment has been removed by a blog administrator.

    ReplyDelete
  3. Fonts Mania1 May 2020 at 07:21

    This comment has been removed by a blog administrator.

    ReplyDelete

Post a Comment

Popular posts from this blog

Do you know how to generate output using eText Template in Oracle Cloud BI Publisher?

In this blog, we are going to see how to generate output using eText Template in Fusion BI Publisher I am going to show this using sample data. This is my sample data Click "Export" button to download the XML file. This is my XML File Open a blank Word Document and save it as type "Rich Text Format" Add a format setup which is given below <TEMPLATE TYPE> FIXED_POSITION_BASED <OUTPUT CHARACTER SET> UTF-8 <NEW RECORD CHARACTER> Carriage Return Add a Header table which is given below. For headers, give the header name within quotes ex: 'Emplid'. For headers, use the level DATA_DS which is the top level and appears only once in the XML <LEVEL> DATA_DS <POSITION> <LENGTH> <FORMAT> <PAD> <DATA> <COMMENTS> <NEW RECORD> DATA_DS Alpha ‘Emplid’ ...
20 comments
Read more

Do you know how to cancel the Work Relationship using HDL in Oracle Cloud HCM?

In this blog, we are going to see how to cancel the Work Relationship using HDL (HCM Data Loader) Please make sure you have taken the back up of all the necessary data before cancelling the Work Relationship To cancel the Work Relationship, we use HDL Source Key method. Use the below sample template for reference SET PURGE_FUTURE_CHANGES N METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegalEmployerName|PersonNumber|DateStart|WorkerType|CancelWorkRelationshipFlag DELETE|WorkRelationship|FUSION|1234|WRK_1234|Legal_Employer|1234|2018/02/01|E|Y In the above template, we do not know the values of the source keys SourceSystemOwner SourceSystemId PersonId(SourceSystemId) Use below query to fetch the SourceSystemOwner Query: select source_system_owner from hrc_integration_key_map where surrogate_id = period_of_service_id   -- pass period_of_service_id corresponding to Work Relationship Use below query to fetch the SourceSy...
3 comments
Read more

Do you know how to generate output using Excel Template in Oracle Cloud BI Publisher?

In this blog, we are going to see how to generate output using Excel Templates in Fusion BI Publisher I am going to show this using sample data. This is my sample data Click "Export" button to download the XML file. This is my XML File Open a blank Excel file and save it as type "Excel 97-2003 Workbook" (.xls) I have created 3 tabs "Summary", "Detail" and "XDO_METADATA" XDO_METADATA tab is mandatory. Place the below text in XDO_METADATA tab Version ARU-dbdrv Extractor Version Template Code Template Type TYPE_EXCEL_TEMPLATE Preprocess XSLT File Last Modified Date Last Modified By Data Constraints: In the "Detail" tab create Header row as shown below Now add the XDO tags Select the blank ...
2 comments
Read more