LOV

building semantic layer
1

HI,

I need to have LOV as CM,LM,L2M and use it in a prompt.
I cant create a dervied table and use it.

So,in the prompt itself i am passing the LOV,but the problem i am facing is that when i refresh my report for prompts,then i dont see any name for the prompt on left hand side,because i am not referring any class/object in my prompt.

@Prompt(‘Enter Distribution Period:’,‘A’,{‘CM’,‘L2M’,‘L3M’},mono,constrained,persistent)=‘L3M’

i have made three such prompts for each of values.
Please refer the attachment for the requirement i need.
BOB.jpg

anshuman11 (BOB member since 2010-05-13)

2

Instead of 3 prompts you can use CASE statement.

And can you please explain your problem in details.

Rakesh_K :india: (BOB member since 2007-12-11)