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

[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.

Steffen

[former_member398188]

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.

Rgds,

Savinder