Skip to Content
0
Jul 01, 2011 at 08:30 PM

Unable to use GET in REC -Record creation

18 Views

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