BPC 10 NW on Oracle - Accessing src and target values from same DIM within logic script?

[Former Member]

Dear All,

I am accepting source and target cost center values forn the user and I am using the following statements:

-------------------------------------------------------------------

PROMPT(SELECTINPUT,,,,"%CATEGORY_DIM%,%TIME_DIM%")

PROMPT(SELECTINPUT,%SOURCE_CC%,,"Choose source cost center :","FUNCTIONAL_CC")
PROMPT(SELECTINPUT,%TARGET_CC%,,"Choose target cost center :","FUNCTIONAL_CC")

INFO(%EQU%,=)
INFO(%TAB%,;)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%TAB%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,EQU,%EQU%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SUSER,%USER%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SAPPSET,%APPSET%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SAPP,%APP%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SELECTION,%SELECTION%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,MEMBERSELECTION,SOURCE%EQU%%SOURCE_CC%%TAB%TARGET%EQU%%TARGET_CC%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,MOVE_ALL.LGF)

-------------------------------------------------------------------

The issue here is... I am not able to access the source and target values. How can I access them within the logic script?

Pls. note that the two values are coming from the same DIM - FUNCTIONAL_CC. And, I need to know how I can access these two values from logic script.

Initially, it seemed to be straight forward... but it is not or, I am am missing something.

Pls. help to fix this issue.

Thanks,
Peri

[former_member186338 · Accepted solution]

Easy:

$SOURCE$ and $TARGET$ variables in the script logic!

Vadim

[Former Member · Accepted solution]

Vadim,

I did try that. Let me try it one more time to see if I made any mistake...

Thanks,

Peri

[Former Member · Accepted solution]

Sorry, Vadim. Your suggestion worked. Made a mistake in accessing the vars - I was using %% convention. I thought I tried that as well and it seems I have not.

Thanks a lot.

Regards,

Peri