Skip to Content
0
Jan 16, 2017 at 06:11 AM

Export three BEx queries into single Excel workbook without using BEx Analyser.

419 Views

Hi Experts,

I am new to SAP BW. Currently, we have a requirement,

  • We have three Bex queries as reports in the portal while giving export to Excel option all the three queries has to be saved in a single Excel workbook without using Bex Analyzer since it is not compatible with our system (BI LOGON 730 version 7300.2.4.1083 and our MS Office 2013 -64 bit).
  • In Bex query designer, I wanted to apply date characteristic to a particular Key figure. The problem is we have other KF’s and formula’s used if we apply the dimension it is applying as a whole. The date is customer exit – CALDAY. Already have used two structures therefore couldnt add one more.Kindly refer the below screenshot for your reference that is the output we wish to get.

Attachments

capture1.jpg (33.6 kB)