How to get year-1 from the prompted year - ( offset )
Hi There BO Experts.
I am used to SAP BW and now I am learning BO. Currently working on a BO Web Intelligence solution.
I am struggeling with variables and prompt.
I would like the following solution.
The user is promped for year - that is the current year.
Based on this I want to be able to make a query selecting only last year.
In sap BW we have something called offset on variables. I havent seen that in BO.
Does anyone have a solution ?
Points will be given.
Jacques du Preez replied
Sorry, I thought you were doing Webi on universe off BW...
If you are using a database behind the universe, you create a filter object in the universe using the @prompt function...
Year = @prompt('Enter Year','C',,mono,free) - 1
Hope this helps