Skip to Content
avatar image
Former Member

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

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

merge-query.png (61.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    Rgds,

    Savinder

    Add comment
    10|10000 characters needed characters exceeded