Skip to Content
0

Join Excel data with BEx query

May 08 at 02:03 PM

58

avatar image

Hello All,

I have a requirement where we have a Revenue report created on top of a BEx query. However, we have some Costs related data in excel sheet that we need to join with the revenue data in the BEx query. Is there any possible solution for this requirement ?

Thanks in advance.

Regards,

Kris.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Koen Hesters May 08 at 02:08 PM
-1
  1. if you have Businessobjects, you can join both in a Webi document
  2. if you don't have BusinessObjects, you can load your excel data in BW and add it your existing BW-flow
Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Koen,

Thanks for the suggestion.

However, loading the data into BW isn't an option that we have. Only a join of the both the cost and revenue data is what that was expected from us.

Regards,

Kris.

0
Matthias Kadletz
May 16 at 11:20 AM
0

Hi Krishna,

do you know BW Workspace? Maybe this could help you to achieve your requirement.

What is a BW Workspace?

https://archive.sap.com/kmuuid2/e03ab40e-23bc-2e10-899a-90a660ce1b63/What%20is%20a%20BW%20Workspace.pdf

Analytic Manager - Agile Information Access: BW Workspace at:
https://help.sap.com/viewer/0ecf5244825c4742a7b062a89d11c2ac/7.5.8/en-US/f38f492432354fdc913f93e8a2bed4a6.html

Regards,
Matthias

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Matthias Kadletz

didn't know about that one,

what is the roadmap? how is it positioned with sap agile data preparation?

0