Lumira - BEx queries as data source - key and text attribute issue

[Former Member]

Hi experts,

I am trying to merge two BEx queries in Lumira.

Merging object should be business partner (prefererably the key attribute). 

In the BW backend the BEx display setting is Text for infoobject Business Partner.

In both queries I have set the Value display as key.

Now when I import the queries into Lumira I only get the text values for BP. I don't want that.

1) Any idea how I can retrieve the key values without changing the BW backend?

In WEBI you get the key and text attribute.

2) Why is that not possible in Lumira?   (A bit of consistency would be appreciated I guess)

[TammyPowlas · Accepted solution]

Please see SAP Note http://service.sap.com/sap/support/notes/1869560 -- it outlines what Lumira supports against BW/BEx.

In the acquisition screen there is a gear icon to change the key/text

See below

[Former Member · Accepted solution]

Hi Tammy,

Gear icons all over the place in Lumira

I was looking for such an option in the prepare room.

Anyway, thanks!

regards marcel