Need To Create Prompt with default value as Today's Date.

[Former Member]

Hi,

I am need to create a date prompt in the universe which should display 'SYSDATE' as the default value. Could somebody please help me with this? Please let me know if we can have default value as 'sysdate' or currentdate in the WEBI report. I am using BO XI 3.1.

Thanks,

Shweta.

[Former Member · Accepted solution]

Hey Shweta GK ,

Your assumptions are correct.

@Universe:

1. Create an Object [Date]
2. Definition: Sysdate()
3. Parse it, it won't parse but it should work on the fly, when you Run query. 
Note: Here make sure your DB(datasourse) will have Sysdate. It is for Oracle DB, for SQLSERVER Getdate() etc...,
4. Make this as Filter condition. (using @Prompt)
5. Check Apply on Universe.
6. Save Universe.
7. Export it.

@Report:

We will have CurrentDate() but not avail in query to make it as Prompt.

Hope am clear in this point.

Gracias...!!

[Former Member · Accepted solution]

Sorry, I am not clear on few things? I need 'sysdate' as default value in my prompt that does mean my prompt has other dates as LOVs and user should be able to select them at the run time. Could you please let me know the @prompt syntax which needs to be used here?

[Former Member · Accepted solution]

Shweta GK,

I need 'sysdate' as default value in my prompt that does mean my prompt has other dates as LOVs and user should be able to select them at the run time

>> You want Sysdate or Date LOV's ??

As I told you in my prior posts, Create two variables @Universe now.

1. Sysdate = [Sysdate] and Type to Date. Apply & Save

2. Sysdate-1 = [Sysdate]-1 and Type to Date. Apply & Save

Export the Universe.

@ Query level:

1. Drag & Drop your Date Object (comes from back-end) to Query filters pane.

2. Operator Between

3. In 1st half select Object (here select Sysdate) Operand area

4. In 2nd half select Object (here select Sysdate-1) Operand area

Run Query.

Hope I understood you're req.

Gracias...!!

[Former Member · Accepted solution]

Okay. Let me explain....

I have a object in the universe say ' Date Range' which has all the dates of last 3 months.I am using prompt in the report to allow users to select date while running report. So now what I want if when user opens the report next time he should see "sysdate' in the prompt and not the Last selected date while last refresh of the report. Hence I want sysdate and a default value of my prompt.

Hope I am more clear this time.........

[Former Member · Accepted solution]

This is unfortunately not possible. A 'Magic Date' sort of solution might work for you. Dave Rathbun explains it better than I ever could on his blog at http://www.dagira.com/2008/07/21/using-a-magic-date-value-in-prompts/ .

Best,

Srinivas

[amrsalem1983]

i dont think that there is an option like that

you can keep the last value selected

but to make the sysdate as default, its not there.

good luck

[former_member142702]

There are some workarounds for this requirement. Please let us know if you define your prompts in the universe or in the WebI report itself.

Regards,

Stratos

[Former Member]

Hi,

My Prompt has been defined at WEBI level.Also I want to display prompt like

Prompt : Date Between "sysdate" and "sysdate-1"

Thanks,

Shweta.

[former_member142702]

Is your prompt define din the universe or in the WebI report itself?

Regards,

Stratos