Skip to Content
avatar image
Former Member

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 16, 2017 at 08:06 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 16, 2017 at 09:21 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded