cancel
Showing results for 
Search instead for 
Did you mean: 

offset

ravi_chandra3
Active Contributor
0 Kudos

Hi all,

I have a report , when i execute the report it will prompt for year , let say i gave 2009 , so the report output should be on 2007 years like the report output should be based on prompt year - 2 .

Hope u got my questions...

Regards,

RaviChandra

Accepted Solutions (1)

Accepted Solutions (1)

michael_melters
Advisor
Advisor
0 Kudos

This must be done on universe level: In the business layer create a filter with following where expression:

table.column = @prompt('Year:','A',,,,) - 2

This is old syntax which can be used even in unviverse design tool. IDT provides an easier way to create prompts

Offset can be prompted as well. Then it is:

table.column = @prompt('Year:','N',,,,) + @prompt(Offset:','N',,,,)

but this normally is used only if you replace the first prompt with something calculated like for example the current year.

and @prompt can have a default value which will then be -2.

Please refer to Universe Desing tool or Information Design Tool guide for complete reference of @prompt syntax on http://help.sap.com/boall_en

Answers (0)