Skip to Content

Merge two BEx Query in SAP Lumira 1.31.5 - not possible?

May 17, 2017 at 09:02 AM


avatar image
Former Member

Hi experts,

at the moment we are doing some tests with SAP Lumira 1.31.5 (while waiting for SAP Lumira 2.0) ... :-)

I try to merge two BEx Queries, but Lumira is telling me, that there is no unique key in the lookup column (in this case GL Person KEY).

The two Queries are build on different InfoProvider but the dimension "GL Person KEY" is the same technical dimension in our BW.

So my question is if it is not possible to merge two BEx Queries in SAP Lumira 1.31 ?

Thanks for your help.

Best regards.


merge-query.png (61.8 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Savinder Kaur Bhjan Singh Jun 01, 2017 at 05:57 AM

Hi Steffen,

My suspect is you don't have unique 1:1 (record) mapping eventhough there are the same. In another word, you have > 1 row for the same key.

You can do the data blending for this case in Visualize Room.



10 |10000 characters needed characters left characters exceeded