Restricting Dimension members in a RUN_PROGRAM CALC_ACCOUNT by property
Hi! I'm trying to run an account-based calculation for a certain group of entities and a certain group of intercompanies (based on properties in each dimension). I cannot find documentation on how to set this up for a CALC_ACCOUNT. I don't want to make these user-selected for a variety of reasons, and because there are a lot of members which can change, I cannot list them all.
Will the following code work? If not, how do I set up? I cannot find documentation for this. I've been told everything for a RUN_PROGRAM must happen within the RUN_PROGRAM block of code and not outside.
*XDIM_FILTER INTERCO = [INTERCO].PROPERTIES("OUTSIDE") = "Y"
*XDIM_FILTER ENTITY = [ENTITY].PROPERTIES("NONUSD")="Y"
CATEGORY = %CATEGORY_SET%
RPTCURRENCY = USD
TID_RA = %TIME_SET%
CALC = RE_RATE_ADJ
OTHER = [GROUP = %GROUP_SET%]
Vadim Kalinin replied
you will see that restrictions has to be defined in OTHER section (with REAL dimension names!)
Just use SELECT to prepare variables for OTHER:
*SELECT(%IOUTSIDE%,"[ID]",INTERCO,"[OUTSIDE] = 'Y'")
*SELECT(%ENONUSD%,"[ID]",ENTITY,"[NONUSD] = 'Y'")
OTHER = [GROUP = %GROUP_SET%;ENTITY=%ENONUSD%;INTCO=%IOUTSIDE%]