LOV Key in the Prompt is not showing up

[Former Member]

Hi all,

The Prompt in the web intelligence report doesn't show up the key in the List of Values, It only shows the description/text. It happens only on the reports based on one particular universe. rest all universes/reports work fine. Is there a setting to unhide or show the key along with description/text?

Source: SAP BW Query

System Specs: BOE Xi R 3 FP 2.7

Prompt syntax:

CONSTANT TECH_NAME="@Prompt('2. Exchange Rate Type Selection','A','Customer\LovExchange Rate Type SelectionBase',mono,primary_key)"

Thanks,

Hema

Edited by: Hema Reddy on Dec 2, 2010 8:41 PM

[Former Member · Accepted solution]

hey i m rajender

if u made prompt in universe . and not able to see list .

so u have to make ur SYSTEM DSN in Administrative tools/ data sources and then change ur universe connection to this system DSN not USER DSN . SO IT WILL SHOW UR LIST OF VALUES

THANKS

WAITING FOR REPLY

Edited by: Rajender Behal on Jan 23, 2011 3:53 PM

[Former Member]

Hi Hema,

Prompt syntax:

CONSTANT TECH_NAME="@Prompt('2. Exchange Rate Type Selection','A','Customer\LovExchange Rate Type SelectionBase',mono,primary_key)"

Your syntax is good but you have to take small mistrack, the prompt function in string farmat.....

SO

Take syntax as follows:

Prompt syntax:

CONSTANT TECH_NAME=@Prompt('2. Exchange Rate Type Selection','A','Customer\LovExchange Rate Type SelectionBase',mono,primary_key)

All the best,

Praveen

Edited by: Praveen Vodela on Jan 24, 2011 10:54 AM

Edited by: Praveen Vodela on Jan 24, 2011 10:55 AM

[Former Member]

Praveen,

Thanks for your reply. So you mean to say I have to use the same syantax with out quotes (" ")?

Thanks,

Hema

[arijit_das]

Check the property of the LOV object if key is defined or not.