Skip to Content
0
Former Member
Oct 25, 2012 at 02:34 PM

Multiple Time Prompts in Data Mgr Package

37 Views

Hi,

I need to prompt for start date and end date in a Data Manager packager, but seem to be limited to only 1 TIME prompt. I've tried:

PROMPT(SELECTINPUT,%MYSTARTPERIOD%,,"Select Start Period",%TIME_DIM%)

PROMPT(SELECTINPUT,%MYENDPERIOD%,,"Select End Period",%TIME_DIM%)

and

PROMPT(SELECT,%MYSTARTPERIOD%,,"Select Start Period",TIME)

PROMPT(SELECT,%MYENDPERIOD%,,"Select End Period",TIME)

but in both cases only the first SELECT appears.

How can I get multiple SELECT or SELECTINPUT prompts to work? Or how can I prompt for multiple dates?

This is BPC 7.5 with SQL Server 2008 environment.

Thanks,

Joe