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.