Skip to Content
author's profile photo
Former Member

'Variable' variable offsets

Experts - Please advise.

My query accepts user entry for a fiscal week range - a from value and a to value. I am currently using a variable with range for this query. Now, the problem is that the user does not want to input the company's fiscal week. Instead, he wants to input just 2 numbers - say n1 and n2. My fiscal week range should then be

(current week - n1) to (current week + n2).

Has anyone done this before - accept 2 numbers (which are not modeled in the info cube) and pass it on to the user exit (or otherwise ?) and calculate the date range. Please advise.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Jul 06, 2004 at 06:14 PM

    Hello Deepak,

    you are on the right track. Create two input variables (type numeric or text). The variables have to be used somewhere in the query otherwise BEx will not prompt the user for them. You could use them in a hidden column for example.

    Now you can refer to those two variables in the exit and populate an exit variable for fiscal week. It also makes sense to add some validation coding (esp. if you use text variables for the input).

    Regards,

    Marc

    SAP NetWeaver RIG, US BI

    Add comment
    10|10000 characters needed characters exceeded