Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Data Manager: limit user selection or take substring

Hi experts,

my user selects some members for the TIME dimension using PROMPT(SELECTINPUT...

My questions are:

1) Is there a way to limit the selection only to base members or to certain values?

2) Is there a way to take a substring from a variable such as %TIME%? E.g. if the user selects 2015.08 I would like to store inside a variable the value 2015.

This is because next I will concatenate 2015 with 06 and 12 (month) and send it to a TASK to perform and extraction:

TASK(/CPMB/APPL_TD_SOURCE,SELECTION,%SELECTION%|DIMENSION:TIME|2015.12....

Thank you

Former Member
replied

"1) Is there a way to limit the selection only to base members or to certain values?" - no with PROMPT(SELECTINPUT, possible with manally created list with PROMPT(COMBOBOX

"2) Is there a way to take a substring from a variable such as %TIME%? E.g. if the user selects 2015.08 I would like to store inside a variable the value 2015." - not possible! Only concatenation is available and only with text strings resulted from PROMPT(TEXT or PROMPT(COMBOBOX...

Vadim

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question