on 07-01-2011 9:30 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.