Customizing Webi report prompt Order

[amitkumar_dey]

Hi,

I am having 08 prompts in my WebI report.

Among these 02 are report level prompts and 06 is Universe prompt.

My requirement is "Out of my 2 report level Prompt - (One is Date Range prompt and the second is 'Activity Code' prompt) I want Prompt to come in this order Report level Prompt(which is Date range prompt) should come in the First Place and then all Universe Prompt and at the End Activity code prompt (defined at the Report level)";. (BO version -- BO 4.2)

Prompt Required Sequence attached for reference - prompt-sequence.png

I am not able to arrange the prompt in sequence how i explained above. Please note this two report level prompt can't be moved to Universe end for adding the prompt order sequence.

Is there any way to apply numerics like 1,2,3 in Report level prompts in Query properties window?

Can any one please suggest on this.

Thanks

Amit

[caj_skullman]

Hi All,

There is a way of doing what you want by using the parameter user:0 as AMIT KUMAR mentioned above.

In the universe create a filter or dimension and in the where clause add a filter using prompts.

Give the prompt parameter, User:0, a number that corresponds to the sorting order you want on your different prompts.

Example: To_CHAR(LOOKUP.DATUM_DIM.DATUM,'YYYYMMDD') BETWEEN @Prompt('Enter DatumStr (Start)','A',,Mono,Free,Persistent,,User:11) AND @Prompt('Enter DatumStr (End)','A',,Mono,Free,Persistent,,User:12)

BR

Caj