Webi to excel save the result to file one report several files

[former_member278451]

Hi Expert,

I generates a webi report in for several variables A, B, C, D .....

I need to save the results of each variable to another file excel.

Like this:

A -> file_A.xls
B -> file_B.xls
C -> file_C.xls
........

Please help solve.

Regards,
Wojtek

[amitrathi239 · Accepted solution]

check these link.

https://blogs.sap.com/2013/11/06/creating-and-scheduling-publications-for-enterprise-recipients-on-s...

https://howtobi.wordpress.com/2011/02/23/how-to-setup-report-bursting-data-driven-publication-in-bus...

[former_member278451]

Thank you very much for your help.

[former_member278451]

Variables - It is the ID_DEPARTMENT from database.

Report code:
ID_DEPARTMENT IN ("158425", "158419", "158421", "158413")

I would like to retrieve email from the database, and send report with ID_DEPARTMENT to the email address in excel format.

One ID_DEPARTMENT to one email.

[amitrathi239]

Please explain in detail.

What are in these variables?

one option to create multiple tabs for each one in webi and save it.

If you want to spilit the the data based on some objects then you can use publication.

https://blogs.sap.com/2014/01/07/create-publication-to-schedule-webi-report-to-dynamic-recipients/