Hi to all,
CPMBPC 801 SP 17, SAP_BW 740, engine JAVASCRIPT
I have Account with time dependent hierarchy.
For example hierarchy:
for year 2017:
Node1 (has 3 childs)
- child1
- child2
- child3
for year 2018:
Node1 (has 2 childs)
- child1
- child2
I execute my script from DM package.
script: *XDIM_MEMBERSET BAS(Node1)
result: child1, child2
The problem is how to get members from hierarchy 2017 year (child1, child2, child3)
how to put command in script that KEYDATE value is between 01/01/2017 and 31/12/2017?
Thanks Vadim, after your answer I changed my DM script, I created process chain ZDEFAULT_FORMULAS with addition field "KEYDATE" by coping from /CPMB/DEFAULT_FORMULAS.
DM script:
PROMPT(SELECTINPUT,%PLAN%, , "Choose plan version","%CATEGORY_DIM%",,1)
PROMPT(SELECTINPUT,%FORE%, , "Choose forecast version","%CATEGORY_DIM%")
PROMPT(TEXT,%YEAR%,"Planning Year")
INFO(%DIMNAME_KEYDATE%,)
INFO(%EQU%,=) INFO(%TAB%,;)
TASK(ZDEFAULT_FORMULAS_LOGIC,TAB,%TAB%)
TASK(ZDEFAULT_FORMULAS_LOGIC,EQU,%EQU%)
TASK(ZDEFAULT_FORMULAS_LOGIC,SUSER,%USER%)
TASK(ZDEFAULT_FORMULAS_LOGIC,SAPPSET,%APPSET%)
TASK(ZDEFAULT_FORMULAS_LOGIC,SAPP,Budgeting)
TASK(ZDEFAULT_FORMULAS_LOGIC,MEMBERSELECTION,VPLAN%EQU%%PLAN%%TAB%VFORE%EQU%%FORE%) TASK(ZDEFAULT_FORMULAS_LOGIC,REPLACEPARAM,YEAR%EQU%%YEAR%) TASK(ZDEFAULT_FORMULAS_LOGIC,KEYDATE,%DIMNAME_KEYDATE%) TASK(ZDEFAULT_FORMULAS_LOGIC,LOGICFILENAME,FORECAST_CAPEX_CALC.LGF)
======
But result same I can't get members from 2017 year .
Please post the text of advanced DM script for DM package!
Use
PROMPT(KEYDATE,%KEYDATE%,,)
to ask user
I think here some mistake in command because nothing changed in DM package there didn't appear on screen for entering KEYDATE.
PROMPT(SELECTINPUT,%PLAN%, , "Choose plan version","%CATEGORY_DIM%",,1)
PROMPT(SELECTINPUT,%FORE%, , "Choose forecast version","%CATEGORY_DIM%")
PROMPT(TEXT,%YEAR%,"Planning Year")
PROMPT(KEYDATE,%KEYDATE%,,)