GET() Function

[Former Member]

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.

[Former Member · Accepted solution]

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

[Former Member]

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?

[Former Member]

Sadly, it doesn't work. It is interesting, GET() function clearly does not work in REC instruction but SAP says in this note 1417337 that GET function works in REC instruction.

[Former Member]

Hi,

Thought so. However, it was really strange to see this note. I hope they publish some more information on this.

[esjewett]

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

[Former Member]

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.

[Former Member]

Hi Chatterjen,

I don't say I am able to use "get function" but OSS NOTE says that it works in NW version.