Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on 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).



    SAP NetWeaver RIG, US BI

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.