Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Tags:
Former Member
replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question