Skip to Content
0
Former Member
Feb 25, 2011 at 08:46 AM

Dynamic Parameters

26 Views

Hi

I have a requirements where I need to prompt the user for a source and destination Category and then do some calculations.

For example, When running the data package, the user should be prompted for a source category - S_CAT and a destination Category T_CAT. I have tried something like the following:

*XDIM_MEMBERSET CATEGORY = %T_CAT_SET%
*FOR %CC% = %CCC%    
         [COSTCENTER].[#%CC%] = ([CATEGORY].[%S_CAT_SET%],[COSTCENTER].[%CC% ]) * ([CATEGORY].[%S_CAT_SET%],[COSTCENTER].[DUMMY])
*NEXT
*COMMIT

But I am not sure what entries in the data package should be maintained, I have tried several options, but none seems to work.

Any assistance with this would be appreciated.