cancel
Showing results for 
Search instead for 
Did you mean: 

WEBi LOVs from BEx

abkshatriya
Active Participant
0 Kudos

Hi,

I am getting Prompt in webi which is created in BEx .

But the Issue is in LOVs of prompt it display TEXT by default and for KEY i need to press KEY sign.

Is there any possibility rather than Universe to get the LOVs as KEY.

Tried everything in BEx by changing object property by making it  KEY/KEY-TEXT but it is giving TEXT by default in WEBI.

Thanks,

AB

Accepted Solutions (1)

Accepted Solutions (1)

former_member202257
Contributor
0 Kudos

Did you also try changing the infoObject property via RSA1? In the Business Explorer tab of the InfoObject, you can set the Display as 'Key'

abkshatriya
Active Participant
0 Kudos

Tried all this but its not working...

Thanks,

AB

Former Member
0 Kudos
Former Member
0 Kudos

Hi Abhilasha,

This link is not opening here. Could you please copy paste the contents.

Hi AB,

I also agree that there is no solution possible as of today. I have also tried to achieve in our environment, But none of the options work.

Thanks,

Shilpa

abkshatriya
Active Participant
0 Kudos

Hi Shilpa,

You need S-ID to read this KBA. below is the resolution provided in the KBA..

Resolution

1. Go to transaction RSDMPROM

2. Enter the multiprovider, and click on Edit

3. A popup appears, click on Continue

4. Right click on the particular InfoObject (0CALMONTH2) and choose “ProviderSpecific

Properties”

5. Change "Display=2 Key" to desired setting, e.g. "Display=0 Key and Text”

6. Save the changed setting and activate the multiprovider

I am trying it and will update you soon.

Thanks,

AB

abkshatriya
Active Participant
0 Kudos

Thanks @Abhilasha Patil.

It worked....

Thanks,

AB

Former Member
0 Kudos

You are welcome.

Glad to know it worked!!

Answers (2)

Answers (2)

Former Member
0 Kudos

Agree with Ferrnando: not possible today.

former_member285534
Active Participant
0 Kudos

Hi AB,

I had exactly the same need a little time ago and I never found a solution.  As you said, changing objects properties to key / key-text don't work.  Nor if you change properties at the BWx query level. Webi always ignores settings. Let's see if others have a workaround, but as far as I know there's no solution.


Thanks,

Fernando

kohesco
Active Contributor
0 Kudos

Hi,

Actually I'm suprise to herre this.  I'll have to check for myself off course.  But in query designer if you set Display as Key, I really suspect to have Key in Webi as well.

One thing for sure, if you remove the text in BW you will certainly only have Key. Or if you do not want to remove the text, you can if possible fill text with the key.  For instance, if you do not have short text assigned already, assign in the upload the key with short text and set in the bex query designer display as text - short text.

Grtz

Koen

former_member285534
Active Participant
0 Kudos

Hi Koen, that was only one person's experience (myself and now AB), but that doesn't necessarily means it won't work in every landscape.  I hope you or someone else can explain why this happens and how it's solved.  Thanks, Fernando.

kohesco
Active Contributor
0 Kudos

Okay,

Does the work-around doesn't fit you?

What is your BW version and BO version ?

Grtz

Koen