bpc script logic

[Former Member]

Hi,

I have 2 user defined dimension type (U). And wanna use it inside my business rules script:

*RUN_PROGRAM CALC_ACCOUNT
CATEGORY = BUDGET
ENTITY = %ENTITY_SET%
CURRENCY = LC
TID_RA = %TIME_SET%
CALC = FR
*ENDRUN_PROGRAM

Please tell me how to use user-defined dimension (u2) inside *RUN_PROGRAM ?

Thanks

[former_member186338 · Accepted solution]

Use:

OTHER=[ENTITY=%ENTITY_SET%;SOMEDIM1=%SOMEDIM1_SET%;SOMEDIM2=%SOMEDIM2_SET%]

[former_member186338]

Sorry, but I see some typo:

OTHER=[SERVICE=%SERVICE_SET%]

PROMPT(SELECTINPUT,,,,"%TIME_DIM%,%ENTITY_DIM%,SERVICES") - may be SERVICE?

Also:

ENTITY = %ENTITY_SET% - incorrect! ENTITY has to be placed in OTHER with the real dimension name

[Former Member]

HI Vadim,

I tested it. My Userdefined dimension name is "Service". And I write my code likes below:

*RUN_PROGRAM CALC_ACCOUNT
CATEGORY = BUDGET
ENTITY = %ENTITY_SET%
CURRENCY = LC
TID_RA = %TIME_SET%
CALC = FR

OTHER=[SERVICE=%SERVICE_SET%]
*ENDRUN_PROGRAM

And my Data Manager Package script

PROMPT(SELECTINPUT,,,,"%TIME_DIM%,%ENTITY_DIM%,SERVICES")

I do not know why BPC system can not filter based on particular services dimension member. No Error in my BPC Excel.

Is it correct?