SAP BusinessObjects - two vertical tables export to excel

[former_member860612]

Hi,

I have created two vertical tables in the Webi but when i export out to excel, the layout of the two tables changed.

I tried alot of ways (leaving big gaps inbetween the tables adjusting the columns of the 2 tables to be aligned) but it doesn't work. it will always have 1812 - 1814 rows of both tables next to each other. I need the data to be downloaded daily to link to dashboard automatically. is there any settings to maintain the layout when i export to excel?

In Webi it look like this:

After exporting to excel, it became:

I have tried for few days to adjust and download but i couldn't resolve the layout issue.

Appreciate if anyone can enlighten me on this.

Thank you very much.

Regards,

Lynn

[moshenaveh]

Welcome to the SAP Community! Thank you for visiting us to get answers to your questions.

Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.

First, please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Secondly, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html as well, as that will help you when submitting questions to the community.

Finally, I recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

[nscheaffer]

How do you want it to look? Have you tried setting the second table's position relative to the first?

Noel

[former_member860612]

Thank you so much Noel. I have adjusted the relative position after some read up and I managed to to download the excel in the layout same as webi. Just that my data size got balloon up from 26mb to 439mb now. Will try to figure out to reduce the size now..

[mhmohammed]

Thanks sgperam for the advertising my blog!

eve81yun - This is another blog to follow for Webi to Excel export format issues.

https://blogs.sap.com/2016/06/15/how-to-best-export-web-intelligence-data-to-excel/