Skip to Content
0

Script logic xdim_memberset bas problem

Feb 12 at 06:40 PM

39

avatar image

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?

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

3 Answers

Amirkhan Kozhageldiyev Feb 13 at 04:58 AM
0

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 .


p1.jpg (171.5 kB)
Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Feb 12 at 09:14 PM
0

Please post the text of advanced DM script for DM package!

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Feb 13 at 08:05 AM
0

Use

PROMPT(KEYDATE,%KEYDATE%,,)

to ask user

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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%,,)

0