Skip to Content
0

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

Jan 16, 2017 at 06:11 AM

79

avatar image

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.

capture1.jpg (33.6 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Koen Hesters Jan 16, 2017 at 08:06 AM
0

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.


opiaw.png (21.1 kB)
Share
10 |10000 characters needed characters left characters exceeded
vimala s Jan 16, 2017 at 09:21 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded