Skip to Content
avatar image
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

3 Answers

  • avatar image
    Former Member
    Jul 06, 2004 at 07:34 PM

    Hello,

    sounds interesting... there are more then one possible solution. One way could be to create an info object (num. 2) with master data. There you can store your 2-sign week-entries (F4-selektion on masterdata). Then include this object into the cube (without filling/mapping them). Within your query you can create a selection on this object. Create a exit-variable on the fiscal-week-objekt.

    Within the Bex-exit you have the possibility (within STEP 2) do read the entries from the selektion of the first object. With this entries you could fill (and modify) your fiscal-week-object.

    Bye, Joerg

    joerg.tuemmler@web.de

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 06, 2004 at 08:31 PM

    Deepak,

    Create formula variable for N1 & N2.

    Then create a variable each for 'From' & 'To' and use customer exit to calculate the the from week & to week.

    which version of BC are you on ? check the variables for DM, they have a similar scenario for aging bucket.

    Cheers

    Tushar

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 10, 2004 at 08:02 PM

    Mr. Deepak,

    Do you have an yahoo account... I work for SAP in India, Bangalore, Please let me know if you got the answer for your question... or still looking for it...

    or send me an email to vijay_chowdary76@yahoo.com.... for any questions....

    Thank you

    Have a nice time.

    Add comment
    10|10000 characters needed characters exceeded