cancel
Showing results for 
Search instead for 
Did you mean: 

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

former_member344169
Discoverer
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member344169
Discoverer
0 Kudos

Hi Koen Hesters,

Thank you for your input, can you explain a little more briefly or step by step procedure to follow since I am new to SAP BW.

kohesco
Active Contributor
0 Kudos

Hi,

You can try to find a solution via the Analysisprocessdesigner (Tcode: RSANWB in BW)

something like this, you can write the result to a file.