current date in list of values

[apirker]

hello!

i have following problem:

when i refresh my report i got two things to enter:
date-from
date-to
now the user want always the current date as default
value in the date-to field. i have really no idea how
to do this!
right now there is no list of value. only the possibility
to enter a date.
it should work in both, bo and the webi infoview

any help is welcome
TIA
Anton

 

[jjl]

The following will return the Oracle database system date in a date object's list of values:

1. Edit object properties in Designer.
2. Press 'edit' button on properties tab.
3. In the query panel press the sql button and overwrite the existing sql with the following: select sysdate from dual
4. Check 'do not generate sql ...'
5. Press OK
6. Press Run.

 

[apirker]

hello!

first: thanks for your answer.
but there is still a problem.
now i have the sysdate as an list of values. when i want to get the sysdate (not the value that stands in the field right now, this is the systdate of deployment day) i have to click on 'show values' then select the date and than i can refresh my report.

is there a possibility get always the current sysdate in the input-box? without refreshing manually?

TIA
anton

 

[apirker]

hello!

first: thanks for your answer.
but there is still a problem.
now i have the sysdate as an list of values. when i want to get the sysdate (not the value that stands in the field right now, this is the systdate of deployment day) i have to click on 'show values' then select the date and than i can refresh my report.

is there a possibility to get always the current sysdate in the input-box? without refreshing manually?

TIA
anton

 

[jjl]

Try this.

1. Create an object in the universe for the database system date. In the select box for the object definition enter sysdate.

2. In your query add a condition for your date object, i.e. Deployment Date = Database System Date Object