creating each record as one report from excel file datasource?

Question

Summary

Content

Hi Gurus,

is there any way to create each record as one report from excel data file as data source? I have excel file data, created data model by using that excel file. That excel file have 300 records. I have to create 300 separate reports.

for example i can explain here with two rows.

i have excel file and contains data as

EmpID    EmpName   Salary   Location

101          xxxx              100         NY

102          yyyy              200         NJ

Now i have to generate two reports one is for EMPID 101 and another report is 102  in PDF format. The output name is something like EMPID_101_XXX_NY.PDF and other report is EMPID_102_YYYY_NJ.PDF

Thanks in advance,

Amit

Brajesh Shukla-95078 · Answer

I have not worked in OBIEE much but if I am correct Bursting feature is available there as well

Brajesh Shukla-95078 · Answer

you can generate using Bursting feature. Instead of specifying the delivery channel as email we can specify location where pdf will generate. Use below link for detail

https://www.packtpub.com/mapt/book/application_development/9781849687126/6/ch06lvl1sec68/implementing-bi-publisher-burst…

Justin Malloy · Answer

BI Publisher... is XML Publisher. Bursting works the same way.