copying the data from one period to other period with calculation.

[former_member592209]

I need to calculate the 10% on Actual data and copy the data from source period to Target period how to achieve this dynamically in SAP BPC standard?

[former_member186338]

"Can we give percentage to calculate also dynamically" - absolutely easy!

Use PROMPT TEXT to get a value and pass it to variable using task REPLACEPARAM

*REC(EXPRESSION=%VALUE%*(1+$PERCENT$),TIME=%T%)

All the mentioned things were discussed a lot of times, why not to search a little?

And please, accept the correct answer.

[former_member592209]

Hi Vadim,

Can we give percentage to calculate also dynamically given by prompts in Datamanager Packages or any other approach is possible?

[former_member186338]

Absolutely easy!

Use script logic like:

*XDIM_MEMBERSET CATEGORY=ACTUAL
*XDIM_MEMBERSET TIME=$SOURCE_TIME$ //Source time periods
*WHEN TIME
*FOR %S%=$SOURCE_TIME$ AND %T%=$TARGET_TIME$
*IS %S%
*REC(EXPRESSION=%VALUE%*1.1,TIME=%T%)
*NEXT
*ENDWHEN

Use PROMPT COPYMOVEINPUT to get source and target for time. Use TASK MEMBERSELECTION to pass variables $SOURCE_TIME$ and $TARGET_TIME$.

[former_member186338]

P.S. Slightly corrected the script