Merging 3 Data Providers without a common dimension

[former_member838457]

Hi Experts,

I'm dealing with a problem while trying to merging 3 data providers without a common dimension. I have tried some solutions found in this community, unfortunately, it didn't work in my case.

https://blogs.sap.com/2016/03/15/merging-3-data-providers-compatible-2-by-2/

I have three Queries: Query1, Query2 and Query3.

I would like to have the information of Query2.Revenue in the table Query1 from Universe, however, revenue was aggregated for each ProductID. The result should be same as revenue in the merged table Query2 and Query3.

Since I created new detail variables and used them as the blog I posted above, the column was empty.

ForceMerge didn't work too.

Can anyone explain how it can be achieved, how can I get correct value in the column Revenue?

Thanks and Regards,

Hine

[former_member27]

Hi bidummy2301,

Thank you for visiting SAP Community to get answers to your questions.

As you're looking to get the most out of your community membership, please consider including a profile picture to increase user engagement & additional resources to your reference that can really benefit you:

Make sure you've applied the appropriate tags -- because if you don't apply the correct tags, the right experts won't see your question to answer it.

Profile https://developers.sap.com/tutorials/community-profile.html

Tips for Questions: https://community.sap.com/resources/questions-and-answers

Consider taking our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html.

I hope you find this advice useful, and we're happy to have you as part of the SAP Community!

All the best,

Dedi

[former_member838457]

Hi Tom,

i did the same actually, but Forcemerge delivered false results.

For example, It should be:

A1 200

A2 500

A3 300

I got:

A1 100

A2 100

A3 800 , seems like sum of the rest.

Dimen1 and Dimen2 are dimensions with data type number from Universe by the way. Is it the reason?

Thanks a lot,

Hine

[Tom_N8]

Hi Hine Nuyn,

Take a look at the report in my screenshot. You will notice that it works. Have you tried resetting your table block with the merged dimensions mentioned in my answer, then forcing the merge with ForceMerge[Query2.Revenue])?

Regards,

Tom

[Tom_N8]

Hi Hine Nuyn,

It seems you have either not merged all candidate dimensions, or you have chosen the wrong dimensions in your table block.

Merge on CategorieID (Query1 and Query3), CustomerID (Query2 and Query3) and ProductID (Query1 and Query2). Next, create a table block consisting of your merged dimensions ProductID and CategoryID, add the two measures from Query1 and your Revenue measure from Query2. Use ForceMerge() on Revenue and you will get the desired result:

Regards,

Tom