Creating object with the prompt

building semantic layer
1

I am sure this question was asked and answered but I could not find in the BOB

case when @Select(Name\Last Name) in @Prompt(‘Select Last Name’,‘A’,{‘Smith’,Taylor’,'Padu’},multi,) Then @Select(Name\Last Name) Else select all the Last Names except {‘Smith’,Taylor’,'Padu’} END

The Else part I can not figure out how to do.

Thanks in advance.

icotler :us: (BOB member since 2002-08-19)

2

Hi Cotler,

Could you please try to implement something like this.

case when Name.Last Name IN (‘Smith’,Taylor’,‘Padu’) then
@Prompt(‘Select Last Name’,‘A’,{‘Smith’,Taylor’,'Padu’},multi,)

ELSE
@Prompt('Message,‘A’,‘Class\Object’,MULTI,CONSTRAINED)
END

Regards
Swain

swaib1 (BOB member since 2008-07-03)

3

Igor,

Please can you provide a full explanation of what you want to achieve?

Is it:

If the user selects one or more of ‘Smith’,Taylor’,‘Padu’ then pick them else pick all user names except ‘Smith’,Taylor’ and 'Padu’?

4

Correct

icotler :us: (BOB member since 2002-08-19)

5

Are you looking for below LOVs

Smith
Taylor
Padu
Others

If a user selects Others then it will exclude above 3 and run report for other users.

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

6

Yes the LOV from the prompt is the selection. And I understand “Other” part but can you provide SQ. I just do not see how it can be done in the SQL.

icotler :us: (BOB member since 2002-08-19)

7

The way we include ALL in LOV’s just put Others instead of ALL and also put NOT IN (‘Smith’…)

I guess this is achievable.

Let me know if you need more information.

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