.csv File Generation Using WebI

building reports webintelligence legacy 1/2
1

Hi,

I have a requirement. Kindly suggest the possibilities of achieving that.

Current Scenario:

  1. PL/SQL code generates a pipe separated text file.
  2. This extract has a pre-defined header and footer.
  3. This extrcat is sent to Users, at scheduled times, through Unix Cronjob

Proposed New Scenario:

  1. The user should be able to generate a .CSV file, himself, whenever he wants it.
  2. The user expects this solution in WebI

May I know the possibilities of achieving this requirement, especially the header and footer.

Sample Data:

Header Part-1| 12345|123456987.12457
something|something|something|
something|something|something|
something|something|something|
something|something|something|
Footer116444gfs

Regards

digitalgopi (BOB member since 2006-05-31)