To export the OBIEE report in same excel file and different sheets , create two data model and use page break in between then in the properties use the below settings.
Export OBIEE reports in same excel with different sheets
PN Blogs | Poulose Nediapala | BI Developer | Apps | DBA