how to change the order of prompts in Webi

building reports webintelligence
1

Hi All,
All prompts are designed at universe level.
Is there any way that I can change the order of prompts at report level(Webi 3.1).

Thanks in advance.

Adious (BOB member since 2009-10-06)

2

In the prompt syntax, define with User 1, user 2 based on your order.

rnola (BOB member since 2006-03-26)

3

customize the sql and define the User 1 and User 2 as rnola said.

@Prompt('Enter Value','A','LOV',multi,free,Not_Persistent,,User:0)

Thanks,
Zaif

zaif235 :us: (BOB member since 2010-06-15)

4

In the qurey panel when you right click to display the query properties on the left side, you have the option of setting the order of prompt…
Please check it if it works for the prompts defined at report level…

nitin_gons :india: (BOB member since 2009-05-26)

5

Hi
Adious

For the prompts created at report level we can set the order in Query tab/Properties/Prompt order. But for the prompts created at universe level we can’t set the order in Query tab/Properties/Prompt order. There is a work around for this,
1.Go to Query tab and click on add new query
2.Drag the promt from the object pane and place it in the query filters pane.
3.Go to main query and again click on add new query and repeat step 2.
Note: Each time you need to add only one prompt.
4.Repeat the same till you add all the prompts.
5.Then right click on the queries and set the order by moving left or right as per your requirement.
6.Click on run all queries and now you will get the required prompt order

vk_3259 (BOB member since 2010-10-04)

6

Nice vk_3259!

It might not be an optimum solution though…but still a good workaround…
Just wondering if numbering the Text prompt could be an option in this case? :roll_eyes:

nitin_gons :india: (BOB member since 2009-05-26)

7

Thank you
nitin_gons

If you are using these prompts for only one repot and not using in any other reports then what you said is true. If you use the same prompts in other reports with some other prompts then you can’t acheive it.
Let me know if i am wrong. :wave:

vk_3259 (BOB member since 2010-10-04)

8

Not a workaround in this case, but a tip.

If you are including prompts at the Universe level and you know that certain prompts will always appear in a certain order - try to make the prompts alphabetical.

For example …

First Name
Family Name

If you use those anywhere they will always prompt Family Name first. Then First Name.

Taking the care to call them

First Name
Surname

Will mean they display correctly even when you forget to order them, and means you don’t have to customise SQL.

Particuarly good for dates.

Open Date
Close Date

will display backwards, but

Date Commenced
Date Completed

will be OK 99% of the time you use them (putting Date in the string will group the dates together if you have other prompts).

weaver (BOB member since 2008-10-17)