Skip to Content
0
Former Member
Dec 18, 2011 at 12:23 AM

Reg: Script Logic - REC Statement Variable usage

62 Views

hi friends

Pl find enclosed the following code:

*WHEN TIME

*IS TMVL(-1,2011.04)

*WHEN ACCOUNT

*IS "EXP01"

*REC(EXPRESSION = [TIME].[2011.04]-%VALUE%,TIME = 2011.04,ACCOUNT = EXP01A)

*ENDWHEN

*ENDWHEN

The above code is working fine and result is extracted but i have hardcoded , ACCOUNT=EXP01A;

My Query is follows:

I have used

*WHEN ACCOUNT

*IS "EXP01"

In REC i want to use concatenation of "A" To account like EXP01&"A"

i know account & i want to concatenate "A" and use in REC statement like assign to variable

var1="EXP01" & "A" and use var1 in REC

*REC(EXPRESSION = [TIME].[2011.04]-%VALUE%,TIME = 2011.04,ACCOUNT = var1)

i am not sure the syntax (Whether we need to put in strings)

Also if EXP02 then var1="EXP02"&"A" and so on

In fact i want to make this for all members in Account Dimenstion as generalised.

Pl. verify and suggest best possibility

Thanx & Rgds

Srinath