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