cancel
Showing results for 
Search instead for 
Did you mean: 

Universe @prompt => mono changes to multi

arne_vanhoof2
Explorer

Hi all,

In IDT I created some custom prompt, for example:
@Prompt('Start Period:','A','Timesheet Period',Mono,Free,Not_Persistent,{'First_Month_CY'})

When I test it it the query designer in IDT it's working perfect.
I do get a prompt and it is a single value prompt.

However when I publish the universe to my repository and create a WEBI report based on the prompt, he is always providing a multiple selection box.

When I check the code in the query designer in WEBI I also notice he changed the mono value to multi automatically.

I have no clue why he is doing this. In the universe itself it's defined as mono, however in WEBI he's always providing multi.

Any idea what can be the cause and how it could be solved?

Accepted Solutions (0)

Answers (3)

Answers (3)

mhmohammed
Active Contributor
0 Kudos

Hi Arne,

Can you try to do it by removing the default selection parameter?

@Select(Period\Timesheet Period §(YYYYMM§)) = @Prompt('Start Period:','A','Timesheet Period',Mono,Free,Not_Persistent,,User:1)

Thanks,
Mahboob Mohammed

Gurgen
Discoverer
0 Kudos

Some in my case

When we create filter like this:

U_DOMCUMENT.VALUEDATE=@Promt('Start Date:','D',,Mono,Free,Not_Persistent)

they automatically change to this:

U_DOMCUMENT.VALUEDATE=@Promt('Start Date:','D',,Multi,Free,Not_Persistent)

BO version 4.1 AND 4.2 some

amitrathi239
Active Contributor
0 Kudos

what is the operator you have used in filter EQUAL TO or INLIST?

arne_vanhoof2
Explorer
0 Kudos

@Select(Period\Timesheet Period §(YYYYMM§)) = @Prompt('Start Period:','A','Timesheet Period',Mono,Free,Not_Persistent,{'First_Month_CY'},User:1)

Like I said in Information Design Tool it's working perfect and you only have the option for 1 value.
However in WEBI he created a list and you can add multiple values.;