Error while creating prompt

[Former Member]

Hi All,

I am having a universe on BW Cube.

Want to create a prompt in universe.

Ex: When user enter end date in a webi report, we will display end date -90 days results in the report.

So created a prompt like this.

@Select(ENDDATE_MAT CONNECTION\Dates\End Date) between

(@Prompt('Enter Date','D',@Select(ENDDATE_MAT CONNECTION\Dates\End Date),Mono,free,not_persistent)-90) AND @Prompt('Enter Date','D',@Select(ENDDATE_MAT CONNECTION\Dates\End Date),Mono,free,not_persistent)

but while parsing i am getting following error

Invalid Expression:

Error parsing the expression: the expression @Select(ENDDATE_MAT CONNECTION\Dates\End Date) has not been parsed as a lov or an business object

the expression @Select(ENDDATE_MAT CONNECTION\Dates\End Date) has not been parsed as a lov or an business object

. (IES 01028)

Environment: BI 4.1 IDT

[amitrathi239]

what is your backend database?based on that you need to add the function like for oracle you need to add "add_months" function.

e.g.

Date>=

Add_Months(@prompt("report run date"),-3) and

Date<=@prompt("report run date")

Dave&amp;#8217;s Adventures in Business Intelligence &amp;raquo; Dynamic Dates Part III: Monthly Dat...