ERP BI - Case Study 2 - Create BI Report using ETEXT template

Here, we will create a ETEXT template using globally provided format and create a BI report.

Highlevel steps:

• Create a Data model
• Create a ETEXT template
• Create a BI report

BI report Query:

Select hp.party_name supplier_name,

poz.segment1 supplier_number,

poz.vendor_id supplier_id,

hp.email_address,

hp.country,

hp.city,

hp.status

from POZ_SUPPLIERS poz, HZ_PARTIES hp where 1=1 

And poz.party_id = hp.party_id

And rownum<=10;

Global Template for ETEXT(modify as per requirement): save the format in ms word with .rtf extension.

Delimiter Format Setup:

Format Setup:

Hint: Define formatting options...

<TEMPLATE TYPE>	DELIMITER_BASED
<OUTPUT CHARACTER SET>	iso-8859-1
<CASE CONVERSION>	UPPER
<NEW RECORD CHARACTER>	Carriage Return

Hint: Format Data Records Table for DELIMITER_BASED

<LEVEL>	DATA_DS
<MAXIMUMLENGTH>	<FORMAT>	<DATA>	<COMMENTS>
<NEW RECORD>	InvoiceHeader
250	Alpha	'Invoice_id'

<LEVEL>	G_1
<MAXIMUMLENGTH>	<FORMAT>	<DATA>	<COMMENTS>
<NEW RECORD>	CLRDAta
250	Alpha	INVOICE_ID
<END LEVEL>	G_1

<END LEVEL>

DATA_DS

Steps in details(Screenshots):