Skip to Content
avatar image
Former Member

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"

*RUN_PROGRAM CALC_ACCOUNT

CATEGORY = %CATEGORY_SET%

RPTCURRENCY = USD

TID_RA = %TIME_SET%

CALC = RE_RATE_ADJ

OTHER = [GROUP = %GROUP_SET%]

*ENDRUN_PROGRAM

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 11, 2014 at 04:14 AM

    Hi Karthik,

    If you look on help: Account-based Calculations as Script Logic - SAP Business Planning and Consolidation, version for SAP NetWeaver - SAP Li…

    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%]

    Vadim

    Add comment
    10|10000 characters needed characters exceeded