Home » Fusion Middleware & Colab Suite » Business Intelligence » Design a report on Mainframes data (BI Publisher Standard edition
Design a report on Mainframes data [message #475759] Fri, 17 September 2010 06:48
Messages: 6
Registered: December 2009
Junior Member
Hello All,

I was given a requirement to design a report using BI Publisher to burst emails with attachments, where the input file is coming from Mainframes ( fixed positioning text file which also includes the context of the attachments).

The record layout of the input file from mainframes has the following fields:
1) Id# positions 1-6
2) Program Code positions 7-10
3) Document sort sequence positions 11-12 packed #
4) Line text positions 13 - 100

1) This email should be send for the ID# which then needs to be joined to another table in DB to get the email address for that ID#.
2) This is 100 (for "abc"), 200 (for "xyz") , 300 (for "pqr").
3) The attachments need to be in a specific sequence and this assigns a "1" to all "abc", "2" to all "xyz" and "3" to all "pqr".
4) This is the text that should be printed as an attachment.

We use BI Publisher Standard Edition

Please give me some ideas on how to accomplish this task.

Thanks in advance.
Previous Topic: Printing ZPL from DOS
Next Topic: Installation of OBIEE 11g
Goto Forum:

Current Time: Sat Jan 23 19:01:03 CST 2021