Show text in one variable's list of values appearing in another variable

[Former Member]

Hi Gurus

I have 2 infoobjects (NUMC 8), one of them is referenced and other one is not. The one which is referenced is Master Data text enabled. Now, i have two reports built on 2 different infoproviders each utilizing one object from above.

In nuthsell,

Query Q1 --> using Object O1 (object O1 is not referenced)

Query Q2 --> using Object O2 (object O2 is referenced, Master Data Text enabled)

Now, if i use Variables on both, i see that variable on O1 (say V1) shows Key value in filter list of value to select for.

And Variable on Object O2 (say V2) shows both Key and Text value in the list of values when clicked on to filter for.

Both the objects (o1 and O2) are not present in the infoprovider on which Q1 is built. We need to show the Text and Key values for the list of values of  V1 somehow. That means when user clicks on to filter on V1, then he should see the correspnding text to the keys. Both the objects (O1 and O2) depicts Global ID for Employee. That means the variables V1 and V2 accepts same key value to filter.

Please help in suggesting how to show text values in V1 List of values which ever is listed in V2 list of values.

Thanks in advance

Preet

[former_member182346]

you requirement is not clear : you say

Both the objects (o1 and O2) are not present in the infoprovider on which Q1 is built.

then how come you want to show the filter value using variable on these objects.

Understand the reference concept in infoobject. I f you have IOBJ1 whose master data along with text is well maintained. Now say you created IOBJ2 having reference as IOBJ1, then you don't have to maintain the master data and text for IOBJ2, it will refer the IOBJ1 data in run time.

There is no separate SID maintain for IBO2 where as IOBJ1 will be referred, since it is reference obj.

Regarding the value in filter pop up, you will find settings in query designer how it should behave.

Thank-You.

Regards,

Vinod Bokade

[yasemin_kilinc]

Hi Preet,

The way how it should look (text, key or both) is selected in the business explorer tab of characteristic properties. But to show the text you have to maintain text for O1. You can simply check "with text" checkbox in the master data/text tab of the characteristic properties and create a transformation that uses the same datasource of O2 reference characteristic.

Hope it gives an idea.

Yasemin...

[former_member182470]

Hi,

What kind of data you can see in both infoobjects in BW system? Do you see Key and texts in both objects or just in Infoobject2?

Without having text values in the Infoobject1, it is not possible to show in Bex directly. You have to maintain data for both infoobjects in equal fashion.

Note: You may try to achieve through BADI concept to achieve Infoobject(V1 values)

Regards,

Suman