Concat member names in *REC statement

[Former Member]

Hi Experts,

I am trying to generate a sql register with concatenated code.

e.g.

*REC(account=entity.id&category.id

If entity. id= company1 and category=actual

I would like to generate

account=company1actual

Is this possible to achieve something similar?

Regards

[former_member599120]

Dear Pablo.Ausin,

I has combined some words with member dimension in *REC function likes:

 *REC(account= ABC + account.ID

Perhaps, you can change you case such as:

 *REE( account=entity.id + category.id) 

Kind Regards,

Wandi Sutandi

Edited by: wandi sutandi on Jan 20, 2011 6:07 AM

[Former Member]

I have tried to do this, but BPC only translate the first code, so

Result:

COMPANY1+CATEGORY.ID

Regards

[Former Member]

You may try...

*WHEN CATEGORY

*IS *

*REC( account=entity.id + %WHEN%)

*ENDWHEN