Selecting max as default for the prompt

building semantic layer
1

I have a WEBI report, with the prompt for date.Report will be displayed as per the selection user makes from the drop down list in the prompt. Now, User wants to have the latest date or max date of the LOV to be displayed as default in the prompt box.Ofcourse the drop down will remain.Is there any way to acheive this at the WEBI report level,access to the universe is restricted.

Thanks !!

Baazigar :india: (BOB member since 2004-06-10)

2

Hi Baazigar,

Interesting screen name. I am assuming your an Indian!!

Anyways, to change LOV’s you need to have access to the universe. I don’t think this is possible at the report level. I am working on a pretty ancient version on BO (5.1.8) :reallymad: (clients version) but as per my knowledge I have not seen any way to have the prompt already select a default value.

Is this functionality available in the 6.x or XI versions of BO?

Prateek

Anonymous (BOB member since 2002-06-06)

3

Hi,
This can be done by modifying the LOV query in designer .
Use a query like max(Fileld).

When you choose this LOV, you will be returned only the max value fro LOV list.

sujay (BOB member since 2004-10-15)

4

Hi sujay,

I think you misunderstood what I was trying to say.

Baazigar correct me if I am wrong.

You want to see the default value – max(column) in the prompt text box, even before the user clicks on the List of Values button. When he clicks run/refresh on the report this value max(column) should always be choosen automatically.

When he clicks on the button he gets the whole list!!

This was my understanding when I posted the message.

Prateek

Anonymous (BOB member since 2002-06-06)

5

Prateek your understanding of the question is correct.

Baazigar :india: (BOB member since 2004-06-10)

6

HI Baazigar,

I don’t know if you can by default show a value in the prompt box, but this a work around that I suggest…

Customize your LOV

Query would be


Select max(dt)
from table
Union
(Select distinct dt
from table
minus
select max(dt) from table)

This way, when the user clicks on List of Values button the first value he sees is the max(dt). It would be a training issue for the users. They would have to be informed that the first value in the List of Values in the max(dt)/ default value.

Hope this helps!!

Anonymous (BOB member since 2002-06-06)

7

Baazigar,
You can do what you’re trying to do in WebI 6.5.1. Create a prompt and:

  1. Check “Prompt with List of Values”
  2. Uncheck “Keep last value(s) selected”
  3. Check “Set default value(s)” and choose the max value in the list as your default.

Keep in mind that this will work only as long as your list of dates doesn’t change. Once a new max date value is in the list you’ll need to edit the report and choose the new max value as the default in the prompt.

Norm Rosen :us: (BOB member since 2002-07-10)

8

A modification to the Prateeks SQL, would this give the same output and a better performance?

SELECT DISTINCT dt FROM table_name order by dt DESC

sskchak (BOB member since 2004-06-21)