cancel
Showing results for 
Search instead for 
Did you mean: 

Webi-Break Export to excel

Former Member
0 Kudos
285

Hi,

How do I export a webi report to excel to multiple tabs (based on a break).

I have a break on Month in the report. When I export it to excel, I woulld like the each month to be on a separate tab in excel.

I appreciate your help.

Thank You

Veena

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hello Veena,

Please make 12 tabs of Webi report and filter each tab for one month of data by applying the report level or block level filters.

Regards,

Naveen D

wmarcy
Contributor
0 Kudos

Hi Veena,

As far as I know you can't do that in Webi.

The only way to export on a separate tab to Excel is to create separate report in Web Intelligence.

You can try to duplicate existing report in Web Intelligence and filter (simple filter bar, input control, report filter, block filter, ...) your break to show only one value of your break for your table. And do it for the 11 more month. you'll get 12 reports on your Web Intelligence document and 12 tabs on your Excel document once exported.

A little bit "handmade" but I think the only solution mainly if you schedule your document to an Excel destination.

Regards,

Former Member
0 Kudos

Hi William,

Can you please explain in detail. This seems like something I could work with.

Thank You

Veena

jyothirmayee_s
Active Contributor
0 Kudos

Hi,

You may have to try like below:

1 Create a report filter on table which shows only for month "Jan"

2. Copy the same table and add in new tab as "Feb" and apply filter to show only records for "Feb"

3. Continue the above steps for remaining 10 months.

When you export this report, it will be exported as 12 seperate tabs in excel.

Thanks,

Jothi