Skip to Content
author's profile photo Former Member
Former Member

GET() Function

Hi gurus,

In note 1417337, i saw this information:

" * The application help cites a restriction of *REC that it is not possible to use GET() to refer to another source value. You should use the MDX tuple instead. This is not correct. It is possible to use GET() with the *REC instruction."

But i'm not able to use this function.

*WHEN_REF_DATA=MASTER_DATA

*WHEN SATIS_KLM
*IS S4000
*FOR %MYTIME%=%TIMEID%,%TIME_FT%
*REC(EXPRESSION=GET(TIME=TMVL(-1,%MYTIME%))*(1+(LOOKUP(POLSKA)/100)),TIME=%MYTIME%)
*NEXT
*ENDWHEN

This code doesn't work but when i take up "get" it works.

Any idea about how we use it?

Thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 11, 2010 at 02:11 PM

    Hi,

    As far as I've seen the GET() function doesn't seem to work in NW. I have had examples of needing to do what you are trying and I've always found it easier to push the data into the next month (rather than grab it from a prior month). If you set-up a property in your Time dim called NEXT and populate it with the next time period, then the below should work I think:

    *WHEN_REF_DATA=MASTER_DATA

    *WHEN SATIS_KLM

    *IS S4000

    *REC(FACTOR=(1+(LOOKUP(POLSKA)/100)),TIME=TIME.NEXT)

    *ENDWHEN

    So if you run this for 2010.JAN for example, it will then post into 2010.FEB.

    Hope that helps

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 06, 2010 at 10:55 AM

    Hi,

    As far as my understanding says, GET is not supported in NW version. Have you been able to get it working on the NW version? If yes, can you please share the script.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 06, 2010 at 11:43 AM

    Hmmmmm.....

    This came as a surprise to me. I will be really happy to see this working.

    Can you please try the below code:

    *WHEN SATIS_KLM
    *IS S4000
       *REC(EXPRESSION=GET(TIME=2009.JAN),TIME=2009.FEB)
    *ENDWHEN
    *COMMIT

    The above code copy the value of 2009.JAN to 2009.FEB for S4000.

    Does the code work?

    Add a comment
    10|10000 characters needed characters exceeded

    • I agree, this is really strange. I think the note is just incorrect on this point. However, I haven't tried it myself since I was under the impression that GET() was not supported!

      Just to verify, this note refers only to the 7.5 version of BPC NW. If you are on 7.0, it definitely doesn't apply. If you are on 7.5 and you tried Nilanjan's example and it didn't work, then I think the note is simply wrong (and should be fixed ... if anyone from the product team is listening).

      Ethan

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.