Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Best Regards,

Ingrid Husby

Former Member
Former Member replied

Hi Ingrid,

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


0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question