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

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on 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 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.