passing value of dimension from input template to logic script

[a_ahmad]

Hi,

i am trying to find a solution (hopefully simple) to pass value of a dimension from input schedule to logic script.

Scope of script:

*SELECT (%FIRST_CYCLE%,"[START_YEAR_MONTH]", CYCLE, "[ID]='%CYCLE_SET%'")

*XDIM_MEMBERSET ACCOUNT AS %ACLIST% = BAS(1000)

*XDIM_MEMBERSET CATEGORY = Plan

*XDIM_MEMBERSET CURRENCY = LC

*XDIM_MEMBERSET CYCLE = %CYCLE_SET%

//*XDIM_MEMBERSET DATASOURCE = INPUT

*XDIM_MEMBERSET ENTITY = %ENTITY_SET%

//*XDIM_MEMBERSET FLOW = FL_999

*XDIM_MEMBERSET TIME = %FIRST_CYCLE%

Requirement:

1- for CYCLE_SET, the value should come from what is selected in input schedule

2- for ENTITY, on run-time when DM package is executed, the user can select one or many entities. This is clear

Any idea how point 1 can be realized.

Thanks for help

Ahmad

[former_member186338 · Accepted solution]

"what is selected in input schedule" = what do you mean by "selected"? In context??

Simple method - use parameter default values in the advanced script PROMPT(SELECTINPUT.

Vadim

[former_member186338 · Accepted solution]

Read here:

[Former Member]

Hi Ahmad,

Does your question mean that you can't work with members of the CYCLE Dimension that user changed? Because those will be in %CYCLE_SET%.

I don't think it's possible to get CYCLE member directly from the context.

Regards,

Gersh

[former_member186338]

Hi Gersh,

If the topic author is talking about default.lgf then yes, it's not possible to get a context value. But looks like he mentioned DM!

If it's a DM package launched from input schedule - then I have provided 2 possible options...

Vadim

[Former Member]

Hi Vadim,

You are right - I missed that "DM" at the end of the posting. In all other parts of the posting author talks about "input template".

So, it's most probably one or the other, but not both:).

-Gersh

[a_ahmad]

Hi Vadim,

Thanks for replying.

The user lands on an Input Schedule through BPF (The CYCLE dimension has been selected means for which cycle e.g. Cycle 2016). The context is locked for all dimensions except CYCLE.

The user will run a DM package which will run the script. In the script there are two variables: ENTITY and CYCLE. In DM package should show only ENTITY parameter where a user can choose one or many entities but the CYCLE should be sent from input schedule to logic script.

your suggestion 1:

I already checked your answer on below link and using this currently to send CYCLE from context to DM package (DM package having two parameters)

How to pass dimension values from context to prompt

your suggestion 2:

How to Call a BPC Data Manager Package from VB

This opens but further link doesn't open: https://go.sap.com/docs/download/2015/08/f8fac683-547c-0010-82c7-eda71af511fa.pdf

I will decide if suggestion 2 is complex then would stay with suggestion1

best regards

Ahmad

[former_member186338]

Then you may close this discussion!

[Former Member]

Hi Ahmad,

Why did you put "input template" in the subject of your question? It looks like you want to pass member from Context to DM Package. This has nothing to do with Input Template.

-Gersh

[former_member186338]

P.S. Complex method requires a lot of VBA coding:

with additional user form to select ENTITY

Vadim