cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to use GET in REC -Record creation

vinoo_gan
Active Participant
0 Kudos

Hi Expert

In the Account dimension i have a member called u201CFactu201D and this holds a calculated value which i would like to use that value for FACTOR.

REC(FACTOR=GET(PF_ACCOUNT="Fact"))

Error : Unknown dimension name in the keyword u201Cu201DFactu201Du201D);

*FOR %Temp% = 1

[PF_ACCOUNT].[#Fact] =%Temp%/[PF_ACCOUNT].[EndPeriod] - [PF_ACCOUNT].[StartPeriod] + %Temp%

*NEXT

*COMMIT

*WHEN TIME

*IS 2012.UN

*FOR %YEAR% = 2012

*FOR %MONTH%=01,02

// *REC(FACTOR=0.5,TIME=%YEAR%.%MONTH%)

*REC(FACTOR=GET(PF_ACCOUNT="Fact"),TIME=%YEAR%.%MONTH%)

*NEXT

*NEXT

*ENDWHEN

*COMMIT

Please advice.

Thanks

Vinoo

Edited by: VinooGAN on Jul 1, 2011 10:32 PM

Accepted Solutions (1)

Accepted Solutions (1)

SEdelstein
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Vinoo -

Unfortunately GET is not a supported key word in BPC 7x NW. You should use MDX tuples for this calculation. Please review section 3 "Tuple Expressions" in the following whitepaper: [http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/e025fa8d-1c22-2e10-cd9f-c488c7eeadd4].

Regards,

Sheldon

vinoo_gan
Active Participant
0 Kudos

Thanks Sheldon

Edited by: VinooGAN on Jul 1, 2011 11:14 PM

Answers (0)