on 05-31-2017 4:42 PM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
what is the operator you have used in filter EQUAL TO or INLIST?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@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.;
User | Count |
---|---|
64 | |
8 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.