Export To Excel : Column merge & Pagination

Column merge issue comes when OBIEE answers report is exported to excel. This can be rectified by removing filters from the Views section but it makes Pagination stops working in reports.

To solve this issue we need to remove Filters View from Analysis XML rather than from Views section.It will only remove it from report layout but not from report itself: Path for analysis XML:

Go to particular report. Click on :

Edit à Advanced à Analysis XML box

Comment the following code:

<!-- <saw:cvRow>

 <saw:cvCell viewName="filtersView!2"/>

</saw:cvRow> -->

Click on apply xml again.

Now the report is error free..