Skip to Content

Join Excel data with BEx query

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • 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
    Add comment
    10|10000 characters needed 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.

  • May 16 at 11:20 AM

    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

    Add comment
    10|10000 characters needed characters exceeded