Skip to Content
0
Former Member
Apr 07, 2011 at 05:00 PM

How can I allow a Data Manager package %selection% for some dimensions only

21 Views

Trying to figure out how to allow the user to select only Time in the data manager package and pass category=actuals and datasrc=imput.

I need the %SELECTION% variable to get set correctly. The output I'm hoping for would look like this: [CATEGORY] in (N'ACTUAL') and [TIMEID] in (N'20110300') and [DATASRC] in (N'INPUT'))

Here is a portion of the modify script:

DEBUG(ON)

GLOBAL(USER_SELECTION,%SELECTION%)

PROMPT(SELECTINPUT,%SELECTION%,,"Please select the members to Clear and LOAD",%DIMS%)

How can I accomplish this?

Thanks!