Skip to Content
0

SAP BPC 10MS - PASSING VALUES FROM DM TO SCRIPT LOGIC

Jun 20, 2017 at 10:13 AM

58

avatar image

Hello SAP BPC Expert,

I have a problem while trying to move a values form the DM to a scrip logic. I’m using SAP BPC 10 MS

In a few words, I need to enter only a year in the DM and then use the YEAR value in the script logic to perform some calculation.

So far this is what I tried:

OPTION A:

In the prompt:

PROMPT(TEXT,%YEAR%,"Select a YEAR",,"")

TASK(Execute formulas,USER,%USER%)

TASK(Execute formulas,Environment,%Environment%)

TASK(Execute formulas,Model,%Model%)

TASK(Execute formulas,LOGICFILE,AGGREGATIONS.LGF)

TASK(Execute formulas,RUNMODE,1)

TASK(Execute formulas,LOGICMODE,1)

TASK(Execute formulas,CHECKLCK,1)

TASK(Execute formulas,FORMULASCRIPT,"*FUNCTION YEAR=%YEAR%")

In the logic:

*XDIM_MEMBERSET CATEGORY = ACTUALS

*XDIM_MEMBERSET TIME = %YEAR%.Q1

Error:

Execute formulasError

Invalid member %2006%.Q1


OPTION B:

In the prompt:

PROMPT(TEXT,%YEAR%,"Select a YEAR",,"")

TASK(Execute formulas,USER,%USER%)

TASK(Execute formulas,Environment,%Environment%)

TASK(Execute formulas,Model,%Model%)

TASK(Execute formulas,LOGICFILE,AGGREGATIONS.LGF)

TASK(Execute formulas,RUNMODE,1)

TASK(Execute formulas,LOGICMODE,1)

TASK(Execute formulas,CHECKLCK,1)

TASK(Execute formulas,SELECTION,%SELECTION%)

TASK(Execute formulas,REPLACEPARAM,YEAR=%YEAR%)

In the logic:

*XDIM_MEMBERSET CATEGORY = ACTUALS

*XDIM_MEMBERSET TIME = %YEAR%.Q1

Error:

Execute formulasError

Invalid selection passed:

%SELECTION%


OPTION C:

In the prompt:

PROMPT(TEXT,%YEAR%,"Select a YEAR",,"")

TASK(Execute formulas,USER,%USER%)

TASK(Execute formulas,Environment,%Environment%)

TASK(Execute formulas,Model,%Model%)

TASK(Execute formulas,LOGICFILE,AGGREGATIONS.LGF)

TASK(Execute formulas,RUNMODE,1)

TASK(Execute formulas,LOGICMODE,1)

TASK(Execute formulas,CHECKLCK,1)

TASK(Execute formulas,REPLACEPARAM,YEAR=%YEAR%)

In the logic:

*XDIM_MEMBERSET CATEGORY = ACTUALS

*XDIM_MEMBERSET TIME = %YEAR%.Q1

Error:

Execute formulasError

Invalid member 2022

Basically what I’m trying to achieve is to select in the DM the year and then in the script logic aggregate the data for %YEAR%.Q1, %YEAR%.Q2, %YEAR%.Q3 = %YEAR%.Q4

In NW this was easy to achieve since by having REPLACEPARAM in the DM Promt + the syntax $YEAR$ in the logic was (in a few words) enoght but now, in the MS version the syntax “$” is been recognize (or I’m doing something wrong.

I will appreciate any help.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers