creating each record as one report from excel file datasource?

usersrekan

Summary

creating each record as one report from excel file datasource?

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

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

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

usersrekan

Hi Thank you for you reply. we are not using EBS or XML publisher. It is OBIEE.,  BI publisher 11g.

Regards,

Amit

Brajesh Shukla-95078

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