Skip to Content

Script logic xdim_memberset bas problem

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Feb 13 at 04:58 AM

    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 .

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 12 at 09:14 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 13 at 08:05 AM

    Use

    PROMPT(KEYDATE,%KEYDATE%,,)

    to ask user

    Add comment
    10|10000 characters needed 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%,,)